modify report to In-cooperate for addition request

[ridhirao22]

Hi All,


Using CR 2008, Oracle 11g

I have a report where it show Division, Department, Units, Amount aggregated by Week, Month and Quarter. Now I have a request to display the top 10 styles for each Division
Is this something I could do by modify the existing report? If so how could I achieve this …Please advise and appreciate all your ideas

Thanks,
RR

 

[lbass]

If you only want to display the top10, you could do a group sort at the division level, based on amount.

If you want this separate, you could insert a crosstab that uses division as the row field and amount as the summary. Then select the crosstab->report->group sort and add the group sort to the crosstab.

-LB

 

[ridhirao22]

Thank you Lbass,

I am using Dense rank function in sql for sub report and showing it as a separate section. But I would like to alternate the color when division changes. I am show this in detail section as I took care of ranking the division by amount in sql
When I tried this formual on background section colour

if division <> perious(division) then crsilver else nocolor

It just colors when the division changes, I want to color the whole division ranking 1-10

Hope I could explain better than this.

for ex: division, rank, amount

aaa 1 $60
aaa 2 $55
aaa 3 $50
bbb 1 $70
bbb 2 $60
bbb 3 $50
ccc 1 $40
ccc 2 $20
ccc 3 $10

I need to alernate the background color when the division change and keep until the ranking is done

Thanks in advance!

 

[lbass]

Insert a running total {#Div} that does a distinctcount of division. Then in the section expert->details->color->x+2 enter:

if remainder({#Div},2)=0 then
crSilver else
crNocolor

-LB

 

[ridhirao22]

Thank you LB!, Worked like a charm