how can create a report like if the salary>50,000 display
balance,if salary<50,000 display green?

Answers were Sorted based on User's Feedback



how can create a report like if the salary>50,000 display balance,if salary<50,000 display gr..

Answer / arun kiran

In c8 you can achieve this by following these steps
1)drag a conditional block
2) Assign a boolean variable(in expression box if(sal>50k)
to the conditional block
3) go to conditional explorer you find two conditions yes and no
4)when current block is yes...drag a layout calulation (sal-50k)
5) When current block is no... use select background color
of salary as gree

Is This Answer Correct ?    9 Yes 0 No

how can create a report like if the salary>50,000 display balance,if salary<50,000 display gr..

Answer / m m naidu

This is can be done using conditional formating

Proceduce:

From insertable object pan double click on query items which
ever u want

select the revenue data item, from the change layout menu
click on define conditional styles

Enter the new value 50,000 click on insert again enter the
new value 50,000 click on insert

For one revenue 50,000 and greate select the style as you
want and for another revenue 50,000 and below select the
style or color as you like

Finally click ok

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Cognos Interview Questions

How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.

2 Answers   Satyam,


What is the deployment requirements used in cognos?

0 Answers  


What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

0 Answers   IBM,


Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com

2 Answers  


Explain the characteristics of cognos?

0 Answers  






What is the use of Excel files in Cognos8?

1 Answers  


explain how to create powerplay reports?

0 Answers   IBM,


What do you understand by the cognos?

0 Answers  


15. If I select the current month and year how can we display previous 11 months data?

2 Answers   TCS,


Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya

1 Answers  


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

2 Answers   IBM,


..Architectural difference between cognos reportnet and cognos8?

3 Answers  


Categories