Force Column Break in multi-column report

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

Guest

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?
 
WorldCTZen said:
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?
Click to expand...

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.
 
WorldCTZen said:
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?
Click to expand...


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
 
Back
Top