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

How to show unselected Data from Prompt

Started by faz49, 11 Feb 2010 04:43:52 PM

Previous topic - Next topic

faz49

Hi Everybody,
I have an issue regarding showing data from the prompt. My users want to have an option where they want to show all data in the prompt if they don't select the value in the prompt also selection option as well. This prompt has multi select option; cascade option .This prompt is changing values upon 2 other prompts.
For an example prompt A has value 1,2,3 .They will have multi select option , if they don't select value it will show 1,2,3 in the report.
How can I show data in the Report from this prompt dynamically?

Thank s in advance.

Faz

MFGF

#1
Hi Faz,

Assuming the prompt has a dedicated query and is displaying a single item, you could try the following:

1. Add a new query with a single data item with the hard-coded expression 'All Values'
2. UNION this with your existing prompt query, delivering the results into a second new query.
3. Change your prompt to be based on the second new query.
4. Change the filter for your report using the following approach:
    [Item you are filtering on] in (?YourParameter?) OR ?YourParameter? in ('All Values')

Edit - the above is for Cognos 8.  If you are on ReportNet, use a Tabular Set in step 2 to UNION the queries.

MF.
Meep!

faz49

Hi MF,
Thanks for your reply. I have three prompts using L_CD,R_Cd and W_CD and need to show W_CD in the report .


I am trying to show W_CD in my report using following hardcode


if
ParamValue('L_CD')='fet' and  ParamValue('R_CD') ='wia_adult' and ParamValue('W_CD') is null then "102,201"
else if
ParamValue('L_CD')='fet' and  ParamValue('R_CD') ='wia_dw' and ParamValue('W_CD') is null then "105,307,428,501"
else if
ParamValue('L_CD')='fet' and ( ParamValue('R_CD')    in ('wia_adult' , 'wia_dw') ) and ParamValue('W_CD') is null then "102,105,201,307,428,501"

else if
ParamValue('L_CD')='lai' and   (ParamValue('R_CD') in ('wia_adult' , 'wia_dw') )and ParamValue('W_CD') is null then "102,105,201,306,423,428,501"
else if
ParamValue('L_CD')='lai' and  ParamValue('R_CD') ='wia_adult'  and ParamValue('W_CD') is null then "102,201"
else if
ParamValue('L_CD')='lai' and   ParamValue('R_CD') ='wia_dw'  and ParamValue('W_CD') is null then "105,306,423,428,501"

else if
ParamValue('L_CD')='lao' and   (ParamValue('R_CD') in ('wia_adult' , 'wia_dw')) and ParamValue('W_CD') is null then "102,105,201,306,422,429,501"
else if
ParamValue('L_CD')='lao' and   ParamdisplayValue('R_CD') ='Adult' and ParamValue('W_CD') is null then "102,201"
else if
ParamValue('L_CD')='lao' and   ParamValue('R_CD') ='wia_dw' and ParamValue('W_CD') is null then "105,306,422,429,501"

else if
ParamValue('L_CD')='sel' and   ParamValue('R_CD') in ('wia_adult' , 'wia_dw') and ParamValue('W_CD') is null then "102,105,201,307,422,501"
else if
ParamValue('L_CD')='sel' and   ParamValue('R_CD')='wia_adult' and ParamValue('W_CD') is null then "102,201"
else if
ParamValue('L_CD')='sel' and  ParamValue('R_CD') = 'wia_dw'  and ParamValue('W_CD') is null then "105,307,422,501"

else if
ParamValue('L_CD')='sby' and   ParamValue('R_CD') in ('wia_adult' , 'wia_dw')  and ParamValue('W_CD') is null then "102,105,201,422,501"
else if
ParamValue('L_CD')='sby' and  ParamValue('R_CD') ='wia_adult' and ParamValue('W_CD') is null then "102,201"
else if
ParamValue('L_CD')='sby' and  ( ParamValue('R_CD') = 'wia_dw') and ParamValue('W_CD') is null then "105,422,501"

else if
ParamValue('L_CD')='ver' and   ParamValue('R_CD') in ('wia_adult' , 'wia_dw') and ParamValue('W_CD') is null then "102,105,201,307,422,501"
else if
ParamValue('L_CD')='ver' and  ParamValue('R_CD') ='wia_adult' and ParamValue('W_CD') is null then "102,201"
else if
ParamValue('L_CD')='ver' and  ParamValue('R_CD') = 'wia_dw' and ParamValue('W_CD') is null then "105,307,422,501"

else

ParamDisplayValue('W_CD')


But it is not working. What is your suggession ?

Thanks Again,
F