COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: balaji.jkb on 10 Dec 2007 05:36:49 AM

Title: How to perform multi select in OWN SQL?
Post by: balaji.jkb on 10 Dec 2007 05:36:49 AM
HI All,
Query type: OWN SQL Developed in sql server
Problem: unable to perform multi select in value prompt even though i have created report using the filter with 'in' clause but even though it shows all the value listed in value prompted but it doesnt show the icons to select all and deselect all.. Suggestions plz...

Title: Re: How to perform multi select in OWN SQL?
Post by: MFGF on 10 Dec 2007 05:51:51 AM
Hi,

Did you check that the 'multi select' property of your value prompt is set to 'Yes'?

Regards,

MF.
Title: Re: How to perform multi select in OWN SQL?
Post by: balaji.jkb on 19 Dec 2007 11:27:19 PM
Hiii...
Mutli select property is already set to be in yes. and i have used in clause in filter. but even though its not showing to options 'select all' and 'deselect all' options in value prompt. thanks for your reply MF