Interested to Buy Any Domain ? << Click Here >> for more details...
How to add 2 different colors for alternative rows?
i.e in a report all rows colors in alternative colors(2
colors)
- 4 Answers
- 11778 Views
- Mphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / v m v k 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 ? | 13 Yes | 0 No |
Answer / pradeep nagireddy
i have three columns like order year ,month,quantity. i
need to display quantity colun each row saparately
for that create one string variable on quantity then select
metadata of quantity.select yes in conditinal explorer.in
propertys select box type = none
save the report and run it
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / viswa
i'm thinking that the answer given by uma is wrong . the ans is
Mod(rownumber(),2)=0 then (1) else (2)
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / uma
We can create a boolean conditional variable. In the
expression defenition pane of it, give mod(rowcount
(dataitem),2)<>0.
| Is This Answer Correct ? | 0 Yes | 6 No |
In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
where exactly determinants are used in cognos framework manager?
How create measures and dimensions?
What is defined as Cognos Impromptu?
wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?
How do you improve the performance of the Cognos Analytics report
hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.
how u provide security in power play transformer???
3 Answers iFlex, ITC Infotech, TCS,
Can you explain dynamic query mode?
how can you set the image in the report
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Teradata 
