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 we check the errors before running the report?

0 Answers  


how many types of keys are there i.e primary key and foreign key etc..?

3 Answers   IBM,


Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

0 Answers  


How to hide value prompt box and list when run report?

4 Answers   IBM,


what is report studiio and how to start it?

2 Answers  






In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?

1 Answers  


how you provide security to reports? How you provide security to packages ?

0 Answers   IBM,


Sales person are there in one company How to do Bursting on this particular requirement?

0 Answers  


Define catalog in cognos and write its various types?

0 Answers  


what is difference btw summary filter and detail filter, plz explain with example

10 Answers   IBM, TCS,


how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

0 Answers   IBM,


----------------------What are the User Securities?

0 Answers   IBM,


Categories