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

what is the diffence between render variable & style variable with egs? Plz reply ASAP

4 Answers   TCS,


How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)

4 Answers   Mphasis,


Hi Experts, Can a single package be shared by multiple users?

3 Answers  


When we use consume in cognos?

1 Answers   IBM,


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  






what are the joins present in reportnet?which is most widely used?

2 Answers   IBM, Satyam,


Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!

1 Answers   Wipro,


What are the two types of framework manager?

0 Answers  


advantages of cascade prompt ???

3 Answers   iFlex,


What is content store?

1 Answers   HCL,


How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?

1 Answers   HCL, iGate,


what is symmetric key?where do u use this?

1 Answers  


Categories