Relational 10.1.2 Report and Showing Begin and End date of a Range

[gosoccer]

Friends,
I have a Parameter Value Display as following that needs to show the St_Date and the same for Final_Date as a part
of our "Relational" Report. ParamDisplayValue('St_Date') and ParamDisplayValue('Final_Date'). The report works perfectly based on the following QUERY-filter to show only the last 31 days worth of data.

Code Select Expand

[BW].[QUERY].[DATE] between _add_days(current_date, -31) and _add_days(current_date,-1)
Now, all I need to do is the show the Begin and End date based on begin date being Current_Date and End Date being the last
day of the 31 days.
If anyone could help on this, I'll greatly appreciate it.

Thx in advance for your time. :D :D

[MFGF]

Friends,
I have a Parameter Value Display as following that needs to show the St_Date and the same for Final_Date as a part
of our "Relational" Report. ParamDisplayValue('St_Date') and ParamDisplayValue('Final_Date'). The report works perfectly based on the following QUERY-filter to show only the last 31 days worth of data.

Code Select Expand

[BW].[QUERY].[DATE] between _add_days(current_date, -31) and _add_days(current_date,-1)
Now, all I need to do is the show the Begin and End date based on begin date being Current_Date and End Date being the last
day of the 31 days.
If anyone could help on this, I'll greatly appreciate it.

Thx in advance for your time. :D :D

Hmmmm. Now I'm seriously confused.

If the begin date is current_date, how can the end date be before this? That makes no sense.

What do you mean by "show"? Do you mean you want a report title with these dates in it? Do you mean you want different dates in your report than the filter is delivering? I'm utterly confused by your requirements. Can you explain?

MF.

[gosoccer]

MFGF,
My bad, I meant the end date as current_date, and begin date going back 31 days.

I got it working by just using the notation you and Lynn provided me in the past for OLAP report and use the current_date.

Code Select Expand

_add_days(current_date, -31) Going back 31 days.
Just created a data item and dropped it to the header instead of using the Layout Calculation.

Please let me know if you know a better way to handle this.

Thx so much,
:) 8)