Is there a way to create excel style reports in a report? I would like to make a table from the information in a query. I have the query sorted by county with all the other information summed or averaged after it. So there is a line item for each county. But in the report I would like it displayed with the grouped data (Counties) to be the column headers and all of the summed data to be rows.
The query results look like this:
County Labor Equip Product Distance
County1 A E I M
County2 B F J N
County3 C F K O
County4 D H L P
And I would like it to look like this in the report:
County: County1 County2 County3 County4
Labor: A B C D
Equip: E F G H
Product: I J K L
Distance: M N O P
Any help is greatly appreciated.
The query results look like this:
County Labor Equip Product Distance
County1 A E I M
County2 B F J N
County3 C F K O
County4 D H L P
And I would like it to look like this in the report:
County: County1 County2 County3 County4
Labor: A B C D
Equip: E F G H
Product: I J K L
Distance: M N O P
Any help is greatly appreciated.