APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT
Answers were Sorted based on User's Feedback
Answer / vmvk reddy
Suppose you are creating a report with two data items
Customer_Name and Total-sales respectively.
Create two new data items.
1.Dataitem1: Running-count([CUSTOMER_NAME])
2.Dataitem2: Mod([Data Item1],2)
Create a variable :
Boolean [Query1].[Data Item2]=1 or 0
Come to conditional explorer bar, select YES, under
properties select the background color.
Come to conditional explorer bar, select NO, under
properties select the background color.
Save report and run.
IT WILL WORK.
Regards VMVK REDDY
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / mallika
Create a One Boolean Variable in that write the expression
as mod(RowNumber(),2)=0.
Go to conditional explorer bar, select YES, under
properties select the background color.
Come to conditional explorer bar, select NO, under
properties select the background color.
Save report and run.
thank you
mallika
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / p. uday bhasker reddy
Develope the list report
then
Create a One Boolean Variable in that write the expression
as mod(RowNumber(),2)=0.
then
And go to the report page select the required colume and go to the properties assign the boolean variable
then
Go to conditional explorer bar, select YES, under
properties select the background color.
Come to conditional explorer bar, select NO, under
properties select the background color.
go to the report page
Save report and run.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / gopal
create one boolean variable and write a condition
Mod(rownum(),2)=0
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / cognos
Here is a very useful link for Cognos
http://www.cognosasksumeet.blogspot.in
Cheers !
| Is This Answer Correct ? | 0 Yes | 0 No |
What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
8. Can you use calculations in report headers and footers? How?
what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull
Write various indexes used in cognos?
How to a create header dynamically in a crosstab report in cognos 8.1?
how to convert crosstab into list?
How to Reset Pagenumbers in one report.
What are variable report studio?
---------------What is Dimension?
diff b/w layout calculation and query calculation
Write some methods to apply securities in framework manager model?