Variable number of columns?

[Leslie Isaacs]

Hello All

Is it possible to have a main report that has one column specified in 'page
setup > format', but that also has a subreport that has two columns?

I guess not - but I'm often amazed by what some of the experts here manage
to achieve!

Hope someone can help.
Many thanks
Leslie Isaacs

 

[Allen Browne]

Yes: a subreport can have more columns than the main report it resides in.
Just make sure the main report provides the space needed for the columns.

For example, say you use Letter paper (8.5") with 1" margins left and right.
That leaves you 6.5" width on the main report. Set up the subreport so it is
only 3.2" wide. Place it on the main report right at the left margin. The
subereport control will be slightly wider than the subreport it contains
(which allows for the line around it), so it will use about 6.41" That's
less than the 6.5" of the main report, so it fits.

 

[PayeDoc]

Hello Allen

Many thanks for your reply - and apologies for the delay in my response -
I've been away!

Both my main report and subreport are on A4 paper (is that OK?). The main
report is 198mm wide, with 6.1mm and 6.17mm left/right margins (the
minimums), so 185.73mm 'available'. The subreport is 86.51mm wide, with two
columns each 86.4mm wide and zero column spacing: the subreport again has
the 6.1mm and 6.17mm left/right margins. I make that (2 x 86.51mm) + 6.1mm +
6.17mm = 185.29mm 'needed': but the subreport only prints in one column when
it's part of the main report (it prints in two columns when printed
independently).

Where am I going wrong?
Hope you can help.
Many thanks
Leslie Isaacs

 

[Allen Browne]

I see you've started a new thread on this.
I'm actually out of office with limited connectivity.
Will let someone else respond to the new thread for you.

 

[PayeDoc]

Hello Allen

OK - many thanks.

Les

I see you've started a new thread on this.
I'm actually out of office with limited connectivity.
Will let someone else respond to the new thread for you.

 

[Larry Linson]

The most common cause for a Report only showing a single Column when used as
a Subreport is that you chose "down then across" for the column format, and
the pagination is affected by its being used as a Subreport. The only "fix"
that I know to make it work in columns is for the columns to be "across then
down".

That may seem a bit "unusual", at first, to readers of the Report, but they
do seem to adapt rather than have to deal with an interminable single-column
Subreport.

Larry Linson
Microsoft Office Access MVP

Hello Allen

Many thanks for your reply - and apologies for the delay in my response -
I've been away!

Both my main report and subreport are on A4 paper (is that OK?). The main
report is 198mm wide, with 6.1mm and 6.17mm left/right margins (the
minimums), so 185.73mm 'available'. The subreport is 86.51mm wide, with
two
columns each 86.4mm wide and zero column spacing: the subreport again has
the 6.1mm and 6.17mm left/right margins. I make that (2 x 86.51mm) + 6.1mm
+
6.17mm = 185.29mm 'needed': but the subreport only prints in one column
when
it's part of the main report (it prints in two columns when printed
independently).

Where am I going wrong?
Hope you can help.
Many thanks
Leslie Isaacs







__________ Information from ESET Smart Security, version of virus
signature database 3995 (20090408) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 3995 (20090408) __________

The message was checked by ESET Smart Security.

http://www.eset.com