If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Setting date range based on Params?

Started by RobSil, 28 Jan 2010 11:11:02 AM

Previous topic - Next topic

RobSil

My report is a monthly report... you say what month by passing in a param...

?MonthParam?
    - allowed values are "ThisMonth", "PrevMonth", "CustMonth"

If custom month, then I look to optional params,
?SpecMonth?
?SpecYear?

I'd like to somehow check the params and set params to be used for date range in my query... is this possible?

That is... if the value is PrevMonth... I set ?StartDate? and ?EndDate? one way, Custom month, another.  I can handle the expression properly... but not sure if you can set the value of parameters in the report vs. passing them in? 

Thanks,
Rob

paddhu

The only way of passing values to parameters is by drill through, or prompt controls. Unless you decide you can go for JavaScript.