Excel style tables in a report?

Funkbuqet

Registered User.
Local time
Today, 01:52
Joined
Oct 30, 2010
Messages
50
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.
 
So what will happen when there's County 200? Will it fit into one page?
 
Don;t imagine it would but I am only dealing with 5 counties, so that is not really a concern for me. I can now arrange it in a report loike it looks in the query but I have more catagories of summed data that I want to display. THus if I keep it displaying as it is in the query it doe not fit on the page. Moving the counties to the top (since that is how the results of the querry are grouped anyway) fixes the width of the page to 6 columns, which leaves all the downward space for the rest of the data.
 

Users who are viewing this thread

Back
Top Bottom