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

what is model and say about process how to create model and how to test model?

0 Answers   IBM,


what are the types of scheduling and what are the errors faced while scheduling then how to solve those errors?

1 Answers   Dr Reddys, TCS, Thomson Reuters,


These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?

6 Answers   IBM, Logica CMG,


3. What was the size of your cube?

1 Answers   IBM,


I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

0 Answers   IBM, KKL, Reliance,






-------------What is Coditional Prompting?

0 Answers   IBM,


---------------How to identify First Record and Last Record?

2 Answers  


What is a query set?

3 Answers   IBM,


what is catalog and types of catalogs in cagnos and which is better?

0 Answers   IBM,


Why Star Schema is de-normalized? Please explain in detail probably with some examples.

2 Answers   DELL,


How to create users and permissions in cognos?

4 Answers   IBM,


Can you define drill down and drill up?

0 Answers  


Categories