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
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.
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