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
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 |
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 |
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
What is Normalization?
What are the different uses of a repository manager?
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?
What are slice and dice?
Explain informatica architecture?
what do u mean by bridge group? where we r using this one?
is there any possibility to hide items other than render variable?
how to connect datamarts
What is zero-foot print?
how u provide security to reports??how u provide security to packages ?
What are all the different types of prompt in cognos?