Customizing Prompts

[lebronjames]

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

[crn.siva]

Hi,

I think it is solved by creating static choice. Try this way.

[Rajaggopal]

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

IF (?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