Troubleshooting
Problem
How to set up a value prompt so that if user does not select anything, the default behavior will be to select everything.
Resolving The Problem
Option 1: Prompt is single-select and may be required or optional.
- Add 'Show All' as static choice to the value prompt as 'use value' and 'show value'
- Set prompt default selection property to 'Show All'
- Set filter to a conditional expression that will accept the static choice 'Show All'
Example: (?Product line? = 'Show All' ) and (1=1) ) OR ([Product line] = (?Product line?))
Option 2: Prompt is multi-select; may be required or optional
- Add 'Show All' as static choice to the value prompt as 'use value' and 'show value'
- Set prompt default selection property to 'Show All'
- Set filter to a conditional expression that will accept the static choice 'Show All'
Example: ('Show All' in (?Product line?) and (1=1)) OR ([gosales_goretailers].[Products].[Product line] in (?Product line?))
Note: If multi-select is true, and the user selects 'Show All' as well as other values form the prompt, Report will show all values.
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2;10.2.1;10.2.1.1;10.2.2","Edition":"Edition Independent","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
12 October 2022
UID
swg21339895