How to add 2 different colors for alternative rows?
i.e in a report all rows colors in alternative colors(2
colors)
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 |
how to solve many -many relations ship in frame work manager?and how to avoid cartigen product in frame work manager?
---------- Purpose of Factless Facttable?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
what is meaning by Master detailed relationship ? please explain one example
What is a dimension?
How to pass parameter value into html design page?
set scope level in transformer
i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?
diff b/w layout calculation and query calculation
What are user classes?
My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333
write a query to display to 10 max record from the employee table?