Force Column Break in multi-column report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WorldCTZen - 05 Jan 2007 01:53 GMT

I have a report with 2 columns. While I could use "across then down" to
create roughly even columns, this will result in gaps between entries in a
column when there's a longer entry in the row above. Also, this causes
sorting to snake, rather than flow vertically.
I can set up fields to figure out how many records there are and compare
where the midpoint is for when to insert a column break.
However, I can't figure out how to cause a column break. Any suggestions?

Reply to this Message

Rick Brandt - 05 Jan 2007 02:59 GMT

> I have a report with 2 columns. While I could use "across then down"
> to create roughly even columns, this will result in gaps between
[quoted text clipped - 4 lines]
> However, I can't figure out how to cause a column break. Any
> suggestions?

I don't think there is such a thing. The only way I know to force a column
break in "Down, Then Across" columns is by setting CanGrow of the subreport to
No and then setting the vertical size to where you want the break.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Marshall Barton - 05 Jan 2007 05:01 GMT

>I have a report with 2 columns. While I could use "across then down" to
>create roughly even columns, this will result in gaps between entries in a
[quoted text clipped - 3 lines]
>where the midpoint is for when to insert a column break.
>However, I can't figure out how to cause a column break. Any suggestions?

You would need to determine the midpoint in a calculated
field in the report's record source query. Then you can
group on the field and use the NewRowOrCol property in the
group header section.

SELECT *,
        2 * (SELECT COUNT(*)
                FROM yourquery As X
                WHERE X.sortfield < yourquery.sortfield)
            \ (SELECT Count(*)
                FROM yourquery)) As HalfGroup
FROM yourquery

Signature

Marsh
MVP [MS Access]

Reply to this Message