2 column sub report

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

Guest

I wish to create a report with a subreport. This sub report will only have 3
rows of information, so I would like them to appear as 2 columns containing 3
rows. Is this possible?

I already have a report based on the two column template online, but that
creates the next column at the end of the page, where I want it to create it
half way through the information so that the information is balanced.


Example of Sub report:


Name Age Name
Age

John Doe 32 Stuart Green
35
Jane Doe 25 Name Name
22
Alice Pickle 33 Blah Blah Blah
27


I hope this gives a good understanding. Main points... I do not want the
column to end at the end of the page but, at the mid point of the
information. I want two possibly 3 columns in order to fit more than one
primary report on a page.

Thanks.
 
TJ said:
I wish to create a report with a subreport. This sub report will only have 3
rows of information, so I would like them to appear as 2 columns containing 3
rows. Is this possible?

I already have a report based on the two column template online, but that
creates the next column at the end of the page, where I want it to create it
half way through the information so that the information is balanced.


Example of Sub report:


Name Age Name
Age

John Doe 32 Stuart Green
35
Jane Doe 25 Name Name
22
Alice Pickle 33 Blah Blah Blah
27


I hope this gives a good understanding. Main points... I do not want the
column to end at the end of the page but, at the mid point of the
information. I want two possibly 3 columns in order to fit more than one
primary report on a page.
Click to expand...


The key trick to using multiple columns in a subreport is to
set the column snaking to Across then Down.

Also make sure the subreport control on the main report has
its CanGrow property set to Yes.
 
Marshall Barton said:
The key trick to using multiple columns in a subreport is to
set the column snaking to Across then Down.

Also make sure the subreport control on the main report has
its CanGrow property set to Yes.
Click to expand...

First I want to thank you for your response, and second I want to ask how to
do this?? I looked it up on the help paperclip, but when I go to my example
report (a copy of the 2 column report template from microsoft), I cannot see
where the snaking is started?? Why does it go to 2 columns? Is there code
or something? I went to the VB code, and nothing there regarding new
columns. How is the computer forcing the new column? And where is it told
how to do this?

Thanks.
 
I figured out how. Duanne answered someone else earlier on... And your advice
took care of the remainder of the issue. THanks.
 
Back
Top