Hi ,
in my report i need to display the parameter value in the report.
example
i have 2 prompts...
1. from and to date
2. only year.(2003,2004.....2009)
for example user select option 1. from_Date is Jul 01, 2008 and to_date is Jun 30, 2009
the report will display the value is 2008 in report column
year product sales amount
2008 xxxxx 45 15000
2008 yyyyy 50 22000
if the user select option 2 year will display directly in column.
if not clear please reply back
URGENT....
In order to achieve what I think you're looking for, you'll need to utilize the "use" and "Display" prompt options.
For prompt #1, use 1 and Display "Date"
For prompt #2, use 0 and Display "Year"
In your report, create a case statement for the Text Item column headers, that says something like "case when ParamDisplayValue(YourPrompts) = 1 then [YourDateField] else [YourYearField] end
Let me know if you would like more details.
Good luck!