COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: actcognosuser on 07 Feb 2025 08:43:12 AM

Title: Unable to use value prompt and search and select prompt together
Post by: actcognosuser on 07 Feb 2025 08:43:12 AM
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?))
Title: Re: Unable to use value prompt and search and select prompt together
Post by: dougp on 07 Feb 2025 10:59:32 AM
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?