Change display of detail data to horizontal instead of vertical

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to change the appearance of a detail section of a report to display
the data left to right instead of top to bottom. There are never more than 4
records in the detail section for each group.

For example, I have a report (based on a query) that displays in groups like
this:

Information Technology (GROUP HEADER)
Strategy 1 Green (DETAIL SECTION)
Strategy 2 Yellow
Strategy 3 Green
Strategy 4 Red

Research (GROUP HEADER)
Strategy 1 Yellow (DETAIL SECTION)
Strategy 2 Green
Strategy 3 Red
Strategy 4 Green

I want the report to look like:

Module Strategy1 Strategy2 Strategy3
Strategy4
Information Technology Green Yellow Green Red
Research Yellow Green Red
Green

Any suggestions?
 
Hi,

try a pivot query from the query editor based on your report query, arrange
the fields as you want them to be displayed, save the query and run the
report wizard with this query, this should work.
 
Back
Top