Need to group and display by columns instead of rows 1

[BrentJ]

I have a report (Alert Roster) in which I need to group data into 4 columns. The fields are: Squad, Rank, LastName, HomePhone, CellPhone, Room#. They are grouped by squad. I need them to look something like this:

(1)[Squad] (2)[Squad] (3)[Squad] (4)[Squad]

Rank,LastName Rank,LastName Rank,LastName Rank,LastName
HomePhone HomePhone HomePhone HomePhone
CellPhone CellPhone CellPhone HomePhone
Room# Room# Room# Room#

Rank,LastName Rank,LastName Rank,LastName Rank,LastName
HomePhone HomePhone HomePhone HomePhone
CellPhone CellPhone CellPhone CellPhone
Room# Room# Room# Room#

Is there a way to create and group columns side by side on a report? Thanks tremendously for any help.

 

[SarahG]

I don't know of a way to do this neatly.

However, if you have a stable amount of squads, i.e. you don't have sqauds removed/added all the time, then I would suggest creating an individual (and very narrow) report for each squad.
Then create a new report and add in a subreport for each of your squad report you have just created, side by side. Make sure the 'Can Grow' property of each is set to Yes.

 

[josh3217]

What if you named a column in the table "Squad". The data, for example, would look like:
SQUAD|RANK|LNAME|HOME#|CELL#|ROOM#

This way, you could at a later time creat queries that you could pull all of the data you needed.

Select * from

where SQUAD=3

This would pull all of the data for everyone in squad three. You can make reports if you want it to come out in a different format.

Dont know if this will help or not, but just an idea.

 

[BrentJ]

Thanks for the help. Grouping wasn't what I was having problems with though, it was getting the report to display the grouping in columns. Thank you Sarah, the subreports worked perfectly.