"Down then Across" Span Report

  • Thread starter Thread starter Rick Allison
  • Start date Start date
R

Rick Allison

I saw this post on the Internet but there was no resolution.
Is there a way to do this? I need to do something very similar.

Rick
----------------------------------------------------------------------------------------------------
I have the need to print 2 columns, but the column interval needs to span
over all pages printed. Usually, if I specify the column group to go 'down
then across', it does so page by page. But I need it to span over the
entire
report before it prints the 2nd column. This what I mean:

Currently, it looks like:
page 1:
---------------------
| 1 asdf 6 asdf |
| 2 asdf 7 asdf |
| 3 asdf 8 asdf |
| 4 asdf 9 asdf |
| 5 asdf 10 asdf |
---------------------
page 2:
----------------------
| 11 asdf 16 asdf |
| 12 asdf 17 asdf |
| 13 asdf 18 asdf |
| 14 asdf 19 asdf |
| 15 asdf 20 asdf |
----------------------

I'm trying to get it to look like this:
page 1:
---------------------
| 1 asdf 11 asdf |
| 2 asdf 12 asdf |
| 3 asdf 13 asdf |
| 4 asdf 14 asdf |
| 5 asdf 15 asdf |
---------------------
page 2:
---------------------
| 6 asdf 16 asdf |
| 7 asdf 17 asdf |
| 8 asdf 18 asdf |
| 9 asdf 19 asdf |
| 10 asdf 20 asdf |
---------------------

I need the 'break' number (in this case - 11) to be a user defined number.
I
tried setting the group interval to 11, but it still limits prints the
columns
as above.
 
Hi Rick,

Untried idea: Could you do it with two side-by-side subreports? One
starting with 1 and the other starting with 11. You could probably refine it
for any number of items if it works.

Clifford Bass
 
Clifford,

Interesting idea. I'd have to create two queries because I do not know how
many rows I'll have.

Thanks,

Rick
 
Hi Rick,

Strange, Microsoft said there was a reply, but does not show it.
Anyway, you may not need two queries. One subreport with one query might do.
The subreport being placed twice into the detail section. If your items are
actually numbered as you show through the query, in your report's On Open
event you could do a DCount("*", "qrySubreportQuery") and then use the value
returned to create filters for each subreport. There are probably other
ways, depending on the data and how it is sorted to figure out the dividing
point programmatically and then apply filters. Of course it two queries is
easier, definitely go that way.

Clifford Bass
 
Back
Top