Columns

  • Thread starter Thread starter user777
  • Start date Start date
U

user777

I have a report with 8 1" columns running vertically down the page/report
and the data wraps around at the bottem and begins again at the top of the
next column and continues like this across the page/report. This is fine--not
the problem.

The problem is on the last page the columns do not make it all the way
across the page/report; they end halfway (i.e. I have 3 1/2 full columns on
the last page). What I want is a way to fill the space with the remaining
columns. Instead of having the columns run all the way down the
page/report, I want them to continue as they do, but end at a certin point
so they are all the same length down the page/report but fill 8 1" columns.

For the visual: This: 1 2 3 To: 1 2 3 4 5 6 7 8
t t t t t t t t t t t
t t t t t t t t t t t
t t t t t t t t t t t
t t
t t
t t



Let me know if this makes any sense.
 
This makes sense but the solution is not easy. I have done this by setting
the report columns to display across then down. Since this is probably not
the order you desire, you must create a calculated value in your report's
record source that can be used in the report's Grouping and Sorting dialog so
that the records appear to display down then across.

I use a complex DCount() in the record source to provide the order/sequence
value.
 
Back
Top