If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report studio filter & valueprompt without selection

Started by mikeou, 03 Jul 2011 12:54:17 PM

Previous topic - Next topic

mikeou

Hi

I have optional valueprompt in my report page(not in separe prompt page). When report is opened or refreshed I need to check is there ?Param1? selected and if not use default value in filter. I'm trying to use Following code in filter but it's not working. I'm using dimensional data, please help.

if (?Param1? is null) then ([Product forecast].[Product].[Product].[Product line] = [Personal Accessories]) else ([Product forecast].[Product].[Product].[Product line] = ?Param1?)