2 column sub report

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.
 
M

Marshall Barton

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.


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.
 
G

Guest

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.

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.
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top