The_Sheckster
asked on
Displaying multiple embedded reports
I am trying to create a report that is structured as follows:
page 1:
group xxx header
detail section
group xxx footer
page 2-6:
variable number of detail sections, each linked with xxx on page 1
Essentially, I want to write a 1-page letter to each of my clients, and on the pages that follow the letter, i want to give a 1-page per job summary of the jobs open for that client.
For example, if client xxx has 5 jobs, the letter would list the 5 jobs in summary form on the letter, and then then next five pages should each be a 1-page summary per job.
I am having a difficult time figuring out the best way to organize my report/subreport structure to make this work. Any suggestions would be greatly appreciated. Thank you.
page 1:
group xxx header
detail section
group xxx footer
page 2-6:
variable number of detail sections, each linked with xxx on page 1
Essentially, I want to write a 1-page letter to each of my clients, and on the pages that follow the letter, i want to give a 1-page per job summary of the jobs open for that client.
For example, if client xxx has 5 jobs, the letter would list the 5 jobs in summary form on the letter, and then then next five pages should each be a 1-page summary per job.
I am having a difficult time figuring out the best way to organize my report/subreport structure to make this work. Any suggestions would be greatly appreciated. Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You cannot have detail sections outside of a group.
Pete
Pete
not even if it is embedded in completely separate subreport?
Client 1 - page 1:
Client 1 - group xxx header
Client 1 - detail section
Client 1 - group xxx footer
Client 1 -page 2-6:
Client 1 - variable number of detail sections, each linked with xxx on page 1
Client 2 - page 1:
Client 2 - group xxx header
Client 2 - detail section
Client 2 - group xxx footer
Client 2 -page 2-9:
Client 2 - variable number of detail sections, each linked with xxx on page 1
etc.
Should there be a total of 2 report objects or 3? Your answer seems to suggest 3, but my intuition tells me there should just be 2 reports - one main and one subreport.
Thank you.