Display group vertically

[Juice05]

I have a view that returns data like this:

CompanyID Month Sales Accounts Year
1 1 120 10 2006
1 2 150 12 2006
1 3 90 8 2006
1 1 50 9 2005
1 2 60 6 2005
1 3 80 9 2005

This data will be filtered to only select 1 Company, but 2 years. This year and Last Year. The report must show the data like this:

Jan Feb Mar(Months cont) Q1 Q2(Quarters cont)

Accounts 10 12 8 30 X
Sales TY 120 150 90 360 X
Sales LY 50 60 80 190 X

Now, I can display these vertically by using the "Format with multiple columns" within the sections expert. My problem is, how do I supress the column headers without them taking up real estate? I can supress if duplicated but the area in which they would be is still used up by a blank section.

Any ideas?

 

[Juice05]

OK, I found out that if I group by the Company and then the Month I can place the headers within the Company Group Header and it only shows the header once.

 

[BarbaraFuhrmann]

Juice,

which version of CR do you use?

I don't know a "Format with multiple columns". Unless that, to me it sounds like the best idea to place the column headers into the page header section.

If you place it in the group header it will not be repeated on the next page automatically. You will have to check the option "Repeat group header on every page" in the group expert to force this.

But best for the result you described seems to be to insert a cross tab.

Barbara

Barbara Fuhrmann (Cologne, Germany) - Using Windows 2000/XP, Oracle 9i and Crystal Reports X