Solved

Displaying multiple embedded reports

Posted on 2004-04-06
4
205 Views
Last Modified: 2006-11-17
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.
0
Comment
Question by:The_Sheckster
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 250 total points
ID: 10766671
Hello The_Sheckster,

You would put the subreports one below the other in the group footer section and insert a pagebreak control before each one.

Pete
0
 

Expert Comment

by:DanielAttard
ID: 10766877
Thank you for your suggestion.  I forgot to add that the report should flow as follows:

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.  
0
 
LVL 77

Expert Comment

by:peter57r
ID: 10767009
You cannot have detail sections outside of a group.

Pete
0
 

Expert Comment

by:DanielAttard
ID: 10767818
not even if it is embedded in completely separate subreport?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question