Filter type used - Value Prompt
Use of optional filters is a great feature in cognos reportnet.
I want to display the filters selected in my prompt screen to the report.
I do this using <%paramdisplay%>.
However, if i dont select any value in the Filter, in the report, it shows as Blank.Ã, Can I display the Value "Not Selected-Optional Value", in case i dont select any value in the prompt.
Thanks
Assuming that your parameters name is parm_name, Change the expression that is displaying the parameter to
if (ParamDisplayValue("parm_name") = '') then
('Not Selected-Optional Value)
else
(ParamDisplayValue("parm_name"))
I wonder if this is due to using a different version, but I tried the above in version 8.2 and found it did not work. What DID work was a similar idea, but just using is null in place of the '' ie:
IF (ParamDisplayValue('Param_Name') is null)
THEN ('All')
ELSE (ParamDisplayValue('Param_Name'))
yeah i think it changed from '' to NULL in version 8....