Optional Filters

[joyal]

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

[JGirl]

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"))

[gidster]

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'))

[JGirl]

yeah i think it changed from '' to NULL in version 8....