How to get report details across the page instead of down the pag.

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

Guest

Ok, have a report with
page header
header #1
header #2
header #3
detail #1 detail #2 detail #3

What I want is the details to go across the page instead of down.

So say right now it looks like this:

(Detail section only)
5 42 5
6 56 6
7 72 7
8 90 8
9 110 9

I want it to look like this
(Detail Section Only)

5 6 7 8 9
42 56 72 90 110
5 6 7 8 9

Is this possible????? And if so how do I do it. I have looked throught the
online help, throught a big monster book I bought, have played with settings,
but can not figure out how. Any help is greatly appreicated!!!!!
 
Never mind, had a breakthrough and kept messing with the multi columns and
the new row or column and finally got it, thanks so much for all your
posts!!!!
 
Smilesmommy2 said:
Ok, have a report with
page header
header #1
header #2
header #3
detail #1 detail #2 detail #3

What I want is the details to go across the page instead of down.

So say right now it looks like this:

(Detail section only)
5 42 5
6 56 6
7 72 7
8 90 8
9 110 9

I want it to look like this
(Detail Section Only)

5 6 7 8 9
42 56 72 90 110
5 6 7 8 9
Click to expand...


Break the report's record source query into two queries.
One to get just the grouping fields and a second one for the
detail data and enough other fields to connect it to the
first query's grouping.

Now modify the report so that the header 3 data is in the
report's detail section.

Next create a multi column report based on the second query.
This subreport's detail section would only have the three
text boxes one above the other and the report's width would
be very small, 1/2 inch or so. Use the FILE - Page Setup -
Columns menu item to specify 15 or so columns, whatever will
fit across a page.

Finally, add this report as a subreport in the detail
section of the main report. Set the sunbreport control's
Link Master/Child proerties to link the subreport data to
the main report grouping fields.
 
Back
Top