SubReport Formatting/Layout

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

Guest

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
 
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.
 
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
 
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...
 
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
(\).
 
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
 
Back
Top