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 / rajasivam

Just we create a variable in report studio, in expression
window type salary>50000 result in boolean if it is true
return 1 else 0.
In report page select particular column then in properties
panel (assign created variable in conditional variable )in
true part assign foreground color blue,in false part assign
foreground color red.
Conditional part can be selected through conditional explorer

Is This Answer Correct ?    5 Yes 1 No

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

Answer / kasturi

by using conditional formatting we can do it

Is This Answer Correct ?    2 Yes 1 No

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

Answer / suman palisetty

simplest solutionis use conditional styles.


Regards
Suman P

Is This Answer Correct ?    1 Yes 0 No

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

Answer / gopal

Suman way is the easy way....

Is This Answer Correct ?    0 Yes 0 No

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

Answer / palzkumar

Kasturi is right, we can achieve this using conditional formating

Is This Answer Correct ?    0 Yes 1 No

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

Answer / samba

use condistional blocks.

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Cognos Interview Questions

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

0 Answers  


How to publish a package by running Java Script?

0 Answers  


Diff b/w Crossproduct and Outerjoin?

0 Answers   IBM, Mind Tree,


What is stitched Query?

5 Answers  


what is report burn and where it occurs

3 Answers   IBM, Target,






What is Model Versioning or Versioning in Cognos Framework Manager?

2 Answers   Systime,


----------How to cretae a Template?

4 Answers  


What errors and types of errors you faced in Cognos ReportNet?

1 Answers  


Why need staging area database for dwh?

0 Answers  


how to change the colour of the bar in charts...?

3 Answers   IBM,


how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

0 Answers   HCL,


what is stitched query???

2 Answers   IBM,


Categories