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

Display "Report Data Period : From - TO " on heading

Started by kbasha2004, 01 May 2008 10:07:06 AM

Previous topic - Next topic

kbasha2004

Hi friends,

I need to Display "Report Data Period : From -  TO " on heading of the report.The report is driven by a date field for example ORDER_DT and there are 2 prompts(parameters) one is COUNTRY and other one is ORDER_DT as range (from ORDER_DT to ORDER_DT ).The reports filters the data as per the 2 paramters.

Now I need to display the "Report Data Period : From -  TO " the  " From -  TO  " is  the paramter ORDER_DT which is entered while running (ORDER_DT paramter value)

for example

2 Prompts .......

1.Country ==  USA

2.ORDER_DT  04/01/08 to  04/30/08

The same date should be displayed as "Report Data Period : 04/01/08 to  04/30/08 "

Please help me how to display

Thanks in Adv

Kbasha2004

almeids

The simplest approach is to create a report expression:

'Report Data Period : '+ParamDisplayValue(order_dt_param)

...but doing it that way you have to live with the display format of the parameter (in our environment it looks like "Between May 1 2008 and May 23 2008", if the format is tweakable I can't tell you where).
If you try to use a range parameter in a data item you only get the start of range, so if you want to do anything fancy in terms of reformatting I believe you have to use separate parameters for start and end date.