report columns

  • Thread starter Thread starter shank
  • Start date Start date
S

shank

I have 4 columns setup in the detail section.
I only have enough data to fill about 1.25 of the columns.
Is there a way to "shrink" the detail section to force data into all
columns?
"Can shrink" on the detail section doesn't resolve the problem.
The idea is to get as much data as possible in the smallest amount of page
space.

thanks!
 
shank said:
I have 4 columns setup in the detail section.
I only have enough data to fill about 1.25 of the columns.
Is there a way to "shrink" the detail section to force data into all
columns?
"Can shrink" on the detail section doesn't resolve the problem.
The idea is to get as much data as possible in the smallest amount of page
space.
Click to expand...


Without getting into some severe complexities, you can only
get balanced columns by using Across then Down snaking.
 
Marshall Barton said:
Without getting into some severe complexities, you can only
get balanced columns by using Across then Down snaking.
Click to expand...

Is there such a thing as counting all the records in the recordset, dividing
by 4, then adding a "column break" if such a thing exists? Snaking across
then down ruins the ability to easily lookup numerical ordering.
thanks!
 
shank said:
Is there such a thing as counting all the records in the recordset, dividing
by 4, then adding a "column break" if such a thing exists? Snaking across
then down ruins the ability to easily lookup numerical ordering.
Click to expand...


Maybe there should be, but there is no such thing as a
"column break".

To get that effect, the report's record source query needs
to number each record with the appropriate column number and
row within the column so that when the report sorts and
groups the records by the calculated values and then prints
them using Across then Down, they come out looking the way
you want. If you really want to pursue this, search the
newsgroup archives at Google Groups, Duane Hookom has a nice
example of the kind of query you will need.

Another, limited approach is to use a subreport to display
the data in Down the Across columns. The key here is that
the subreport's CanGrow property must be set to No. By
choosing an appropriate(?) height for the subreport control,
you can control when a new column is started. Since this
hokey workaround only works if all the records fit on a
single page, it's not particularly useful.
 
Back
Top