Multiple Column Report Help

[mrssevans]

I am trying to create a report that looks much like a spreadsheet. Such as this:
Location1 Location2 Location3
label1:location1data...location2data...Location3data
label2:location1data2...etc....etc

They would like to only see the label once and the data in columns across, much like an Excel spreadsheet. I have tried working with cross tab queries some, but I have over 50 fields that will need to be listed below each location. Can anyone suggest anything?

 

[MStef]

Open report ind design view.
Click on "File", "Page Setup", "Columns".
You'll find here what you need.

 

[mrssevans]

Thank you for the reply, but I have already tried that. In order to only have one label this option does not work. Thanks anyway.