Reports with Multiple Subreports

T

Tom

All:

I am struggling with the following problem. Any suggestions would be
appreciated.

I need a report that includes multiple sub reports, some of which will
be multi-column, some not. I can’t seem to get everything to work out
right so that I get one column where I want one, and two where I want
two.

For example, think of a form that has some information from a parent
table at the top, then a tab control at the bottom. Each tab page
contains a subform with data from child tables.

I need to print out a report for one parent record showing all the
information from the parent table and all the associated child
tables. My intent was to make a report with the parent information at
the top, then include a subreport for each of the child tables. Some
of those child tables only have a few fields, so in the interest of
keeping the report compact, I want those subreports to be two
columned.

Clear as mud? Any ideas?
 
N

NetworkTrade

as no one has replied I will give my 2 cents; besides your description
intermingling reports and forms which is a little confusing - - I do
understand that the alignment/layout of subreports is not always easy.
Stacking them on top of one another is fine but aligning side by sides is
not...in terms of then the lines really lining up....

one solution is to consider not using multiple subreports - by developing a
query that brings all the data together into one records set. may not be
feasible in your situation but if it is - then there you go....
 

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