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

Why we take so long time to display date prompt before displaying a report? How can we reduce the time?

2 Answers  


i have one file i saved in csv how can i take these file into framework manager

0 Answers  


what is cardinality that you can give to employee and department query subjects in framework manager?

2 Answers   HCL,


Cleared COG-112 with 100% score today. What next certification should i go for?

0 Answers   IBM,


It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha

0 Answers  






What is the use of report studio?

0 Answers  


What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?

5 Answers   IBM,


How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.

5 Answers   IBM,


what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

0 Answers  


Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.

3 Answers   iGate,


1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question

2 Answers  


-------------------What is StarShema?

1 Answers   Cap Gemini,


Categories