In my Report
C-id c-name Revenue are the query items
I need to display the report has Alternative colors for rows
and Revenue >=1000 has display in another color?
i.e Both c-id,c-name are applying the alternative
color(red,yellow) condition and revenue (blue) u think..How
its possible?
Iam doing for alternative colors i defined Two dataitems as
running-count and Mod...
and next in Boolean varaible define as [Query1].[Data Item2]
= 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's
correct or not) and define in condition explorer yes and no
purpose two colors(here how to define 4 revenue color)
By selecting the list columns body style its applying only
the Body and run report it working only for alternative colors
Next i defined by using same Boolean condition for revenue
like this.
For selecting only the Revenue Body and define as yes 4 one
color and no for another color?
But here it the revenue column also applying only the
alternative color condition and it's taking the >=1000
condition...
So,i need to display 2 columns have alternative colors and
3rd column >=1000 cell have another color any body pls give
me the replay/answer in step wise.....
Thank u
Basha
No Answer is Posted For this Question
Be the First to Post Answer
How can I disable the drill-down for the last level of my dimensional hierarchy ????
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith
Define report item?
There is any option to delete temp files automatically from temp directory in COGNOS? (without manual)
write a query to display the third record from the employee table?
what is mean by complex starschema ,star schemagrouping?
Diff b/w surrogate Key and Primary Key?
how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?
I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?
1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types of SQL 5. Difference between pass-thro and native sql? 6. will usage of pass thro sql will improve the performance? 7. Complex problems fced in your project 8. performance tuning in reports