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

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

0 Answers  


What is Normalization?

3 Answers  


What are the different uses of a repository manager?

0 Answers  


1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?

0 Answers   Wipro,


What are slice and dice?

0 Answers  






Explain informatica architecture?

0 Answers  


what do u mean by bridge group? where we r using this one?

0 Answers  


is there any possibility to hide items other than render variable?

2 Answers   IBM,


how to connect datamarts

0 Answers   HCL,


What is zero-foot print?

0 Answers  


how u provide security to reports??how u provide security to packages ?

5 Answers   Wipro,


What are all the different types of prompt in cognos?

0 Answers  


Categories