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

Post New Answer

More Cognos Interview Questions

What is the difference between drill through, drill across?

0 Answers  


What are the considerations regarding performance kept in mind while setting up cognos?

0 Answers  


what r the claims? how many type of claims we face from client side?

1 Answers  


How can I change reports to another package???

3 Answers   IBM,


In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.

4 Answers   Accenture, HCL, IBM,






Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.

2 Answers   IBM,


11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance

1 Answers  


what is difference btw summary filter and detail filter, plz explain with example

10 Answers   IBM, TCS,


How you create IQD In ReportNet FrameWork?

3 Answers   IBM,


what is #prompt and #promptmany, runningtotal in report studio

1 Answers  


What is the use of powerplay web viewer in cognos?

0 Answers  


-------------------What is StarShema?

1 Answers   Cap Gemini,


Categories