Multiple Columns on a Report

[WildlyHarry]

I have a Multi-Column Report. The Column headers are the date. Within the
columns I have a set list of transaction codes. There needs to be a label
box for each code in the left most column. I have the report set up fine,
but the lobel box for each code appears in all columns. This causes
confusion and wastes space. Is there anyway to set the label box property as
visible in only the first columns of my report. Below is a sample of what I
have so far. Thank you in advance for your help.

What I have
Date 1 Date 2 Date 3
Label 1 xxx Label 1 xxx Label 1 xxx
Label 2 xxx Label 2 xxx Label 2 xxx
Label 3 xxx Label 3 xxx Label 3 xxx...

What I want
Date 1 Date 2 Date 3
Label 1 xxx xxx xxx
Label 2 xxx xxx xxx
Label 3 xxx xxx xxx...

 

[Duane Hookom]

There is a KB article on "How to Show Only Labels in the First Column of a
Report" at http://support.microsoft.com/kb/208491/en-us

I also think you could use a crosstab query.