How to write a condition for multy select in conditional
formatting...

Eg:- i added list,crosstab, barchart, columchart,
guagechart, pie chart for value prompt by using static
choices..

if i select multiple that all the things has to be
display.. this is requirement how is possible to
display..

Answers were Sorted based on User's Feedback



How to write a condition for multy select in conditional formatting... Eg:- i added list,crosst..

Answer / mohana krishna k

You can use the like condition:
paramdisplayvalue(?valueprompt?) like ('%Cross%')
or
paramdisplayvalue(?valueprompt?)='All'

Is This Answer Correct ?    0 Yes 0 No

How to write a condition for multy select in conditional formatting... Eg:- i added list,crosst..

Answer / rashmi

1. Create Value Prompt with Parameter 'Parameter1' and add Static Values as 'List', 'Crosstab' etc... and 'All'
2. Create Boolean variable for each report objcts
Example: ParamDisplayValue('Parameter1') in ('List','All')
ParamDisplayValue('Parameter1') in ('Crosstab','All')
etc...
3. Asiign above created Boolean variables to the respective Report object
4. Run the report when you select 'All' -> All the report objects will be displayed

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

0 Answers  


How to generate cubes in cognos?

0 Answers  


Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.

2 Answers   IBM,


What are the different type of securities can we apply in framework manager?

1 Answers  


Can any one tell me cognos training class in chennai? thanks in advance...

5 Answers  






Explain the characteristics of cognos?

0 Answers  


How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?

4 Answers  


How can I test reports in cagonos?

0 Answers  


Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!

5 Answers   DELL,


what is render variable

5 Answers   Accenture, Cap Gemini, Systime, TCS,


how can you get the errors in job? when loops are araised we get error?

0 Answers   Syntel,


what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

0 Answers  


Categories