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
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 |
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 |
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
What is Cardinality
Which one is better among Value and select & search prompts,in terms of performance?
Explain about embedded & standalone filters?difference between them
how you create security to reports?
What is the difference between Open Connection command ang Open Session Command?
What is stitched Query?
What do you understand by the term 'aggregate advisor?'
Can you define drill across?
In how many ways we can apply the security to a cube in Transformer? Explain?
What are the Ways to Import Data into Catalong?
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?