Solved

Displaying multiple embedded reports

Posted on 2004-04-06
4
201 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
  • 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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.

746 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now