Displaying in a table format

[GCL2007]

Trying to present data in a table.. Have a series of test results I need to report. I have fields for test_type (could be mechanical, chemical, physical, etc).
For each test type, I have a test_id for each test run.
There may be multiple test_ids for each test_type. I have a number of results fields for each test_Id, such as temperature, strength, heat, elongation, etc.
I am trying to report this in a 'horizontal' manner

test1 test2 test3 (test_id)
temperaturetext temperature temperature temperature
strengthtext strength strength strength
heattext heat heat heat
elongationtext elongation elongation elongation
etc

and I would have one chart for each test type. Not sure if that made sense, but does anyone have ideas?

 

[lbass]

You could insert a crosstab that uses test type as a column or a row, test_id as the column, and then adds the result fields as summary fields. In the customize style->summaries, check "show labels". Or you could leave out the test type, and insert a group on test type in the main report and place the crosstab in the group header.

-LB