Ok, got it. In this case I'd suggest the same solution you already tried:
?parameter?='-1' OR [dataItem] = ?parameter?
Did a quick test and it doesn't affect the report performance. Which datasource/databse do you use? Have you tried to write FQD makros instead of abbreviations? (#prompt('parameter';'datatype';'default value')# instead of ?parameter?)
------------------------------
Robert Dostal
Team Leader BI
GEMÜ
Ingelfingen
------------------------------
Original Message:
Sent: Thu March 16, 2023 10:20 AM
From: Logenthiran Thangavel
Subject: Select all option in value prompt
Thanks Robert , For now i made the report like this way only. Also checking if there is any way to achieve this.
------------------------------
Logenthiran Thangavel
Original Message:
Sent: Thu March 16, 2023 10:14 AM
From: Robert Dostal
Subject: Select all option in value prompt
Hi,
why do you want an "all elements" selection in a filter/prompt? Just don't let the user select anything which will result in an unapplied filter = all data. The filter in our query just needs to be optional. Cognos then captures when a filter criteria is selected by the user and will activate the filter automatically.
------------------------------
Robert Dostal
Team Leader BI
GEMÜ
Ingelfingen
Original Message:
Sent: Thu March 16, 2023 10:07 AM
From: Logenthiran Thangavel
Subject: Select all option in value prompt
Hi Experts,
How can we add Select All option in Value prompt? We have a case like user will select a country in value prompt ( Single selection). If they want all countries data, then they need to select "All Countries" from prompt. So,I added "All countries" in Static Choices and made the report query filter as ( ?Parameter? = 'All Countries" or [Data item] = ?Parameter? ). This is taking long time to generate the report result in HTML / Excel. How can we rectify it? IS there any other option to add "All Countries". The Prompt is Required and single selection.
------------------------------
Logenthiran Thangavel
------------------------------