Report Columns

[Zonie32]

Hello. Not sure how to explain, but I am trying to create a report with columns that are the same heading. For example:
I have a field called Network. There are 5 different networks. Each has 4 other fields related to the network.

I want the report to list across the top the Network names and under the names I want it to list the other 10 fields. What I keep getting is the same data in each column. How do you tell it to go to the next Network and list their info? It should look like this: It keeps repeating data for the same network.

ABCNetwork CDE Network FGH Network

InNtwk - 500 InNtwk - 500 InNtwk - 200
OutNtwk - 1000 OutNtwk - 2000 OutNtwk - 1000
Phys - 25 Phys - 50 Phys - 35
ER - 50 ER - 100 ER - 50
Any help is appreciated.

 

[Zonie32]

Okay. I figured out how to do this. In the report design view I went to File, Page Setup and clicked the columns tab and set things accordingly. Ie, set number of columns to 3 for this particular report.

However, there will be times where when I run the report I will not know how many columns will be needed. Is there any way to tell it to do this automatically based on the data?