SubReport Formatting/Layout

D

Daniel

Hi,

I create two sub reports. The 1st, a simple single column report and the
2nd is a multi columns report. In preview, they both appear exactly as I
want them to. however, when I combine them into a single report, as
subreports, the multi column no longer appears properly. I only get data in
one column on half of the page instead of the 2 column layout that appear
when previewed independantly.

What settings do I need to adjust to rectify this problem. All I want is to
combine the 2 subreport without changing any of the formatting.

Thank you in advance for the help,

Daniel
 
D

Duane Hookom

Subreports have no page sections or events. A two column report that
displays Down Then Across requires the definition of the Page within the
report. Since there isn't a Page in the subreport, it prints only one
column.

You can set the columns to print Across Then Down.
 
D

Daniel

Duane,

Across then Down totally changes the look/layout of the documents and will
force me to export to Word.... (a whole lot of work for nothing). Is there
no way to be able to incorporate a Down then Across layout as a subreport?
Could you explain why, just for personal purposes. Any ideas on getting
around this problem.

Thank you for your help,

Daniel
 
D

Daniel

Duane,

Can this be done using VBA?

Daniel

Duane Hookom said:
Subreports have no page sections or events. A two column report that
displays Down Then Across requires the definition of the Page within the
report. Since there isn't a Page in the subreport, it prints only one
column.

You can set the columns to print Across Then Down.
Click to expand...
 
D

Duane Hookom

You can create an expression in your query that has a value when sorted in
the report will make across then down look like down then across. This
usually requires a ranking/sequence value and both Mod and integer divide
(\).
 
L

Larry Linson

Is there no way to be able to incorporate a Down
then Across layout as a subreport? Could you
explain why, just for personal purposes.
Click to expand...

He just did, Daniel. Suimmarizing: "Down-then-Across requires a Page event;
there is no Page event in Reports run as Subreports."

Larry Linson
Microsoft Access MVP
 
Top