Hi,
i have a prompt that has month values in it. It displays all the months and at the top...it has the name of my data Item (Month Code). When I click on it, the resulting list becomes the sum of all months.
This is exactly what I want but I want to change the name of that value to "All Months". So when I click on this it should show the sum of all months.
Any ideas??? Thanks
Hi,
I think it is solved by creating static choice. Try this way.
Yes, it can be achieved using static choice... Add a static choice with some use value and display value as "All Months", and in the prompt filter add condition something similar to this...
QuoteIF (?ParamMonth? = 0)
THEN( [Month] = [Month])
ELSE( [Month] = ?ParamMonth?)
where
- 0 is the use value you have specified for the static choice. It can be any value of your choice
- [Month] is the data item on which you are filtering the report
- ?ParamMonth? is the parameter name of the month prompt