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
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.