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

Unable to use value prompt and search and select prompt together

Started by actcognosuser, 07 Feb 2025 08:43:12 AM

Previous topic - Next topic

actcognosuser

Report has both value prompt and search and select prompt which are both set to optional and multiselect.

The prompts use different queries. Field is orderid

User should be able to select Orderid from the value prompt or search /select prompt or both. DEfualt should be all.

When I use this detail filter the select all option and input box for search prompt disappeared.

(
(paramcount(?SearchOrderid?)=0 OR [ORDER ID] in (?SearchOrderid?))

AND

(paramcount( ?SelectOrderid? )=0 OR [ORDER ID] in (?SelectOrderid?))

dougp

QuoteThe prompts use different queries.

I assume the queries are different.  Otherwise, use the same query to simplify the report.


QuoteDEfualt should be all.

What does that mean?


Can you reproduce the problem using the samples (Go Sales (query)) and post the report spec so we can see what the problem looks like?