Report and Subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK lets try this agian since I have some things figured out.

How do I bring 2 reports together into one report? Each report works on its own and both are sorted according to Servicing Division, Assigned Consultant and then Date Written Report Sent which is a date field.

I would like the information from both reports in one report that would show up under the Date Written Report Sent.

What is the secret to placing the subreport into the main report to make this work? I keep trying but the months of data do not match up correctly.

Am I missing something in my sorting and grouping properties?
 
Just a few things to check. Do you have your subreport in
the detail section of your main report? I am guessing
that's where you would want it. Also, check the link
master and child fields on the properties for the
subreport. They should have the same hierarchy as your
sort order.
-----Original Message-----
OK lets try this agian since I have some things figured out.

How do I bring 2 reports together into one report? Each
Click to expand...
report works on its own and both are sorted according to
Servicing Division, Assigned Consultant and then Date
Written Report Sent which is a date field.
I would like the information from both reports in one
Click to expand...
report that would show up under the Date Written Report
Sent.
What is the secret to placing the subreport into the main
Click to expand...
report to make this work? I keep trying but the months of
data do not match up correctly.
 
Okay, really obvious question: Do you know that you have
data from both reports for the same Servicing Division,
Assigned Consultant, and dates?

If not, you may want to start by taking the source data
from your 2 reports (queries?) and combining them
beforehand.

You could try a union query to pull all the data
together. Then, your 1 report, using your current
sorting/grouping would give you everything, without
needing a subreport.

Hope I'm not way out in left field. If so, post some more
details.


-----Original Message-----
If I use all three sorting items as links I get no report
Click to expand...
data. If I use 1 or 2 I get dta but the wrong months for
some and multiple date for others.
I have put the links in the order of sorting for both reports.

Any ideas
Click to expand...
 
I have tried to combine but data comes from two different tables and when I tried join I get duplicate values for some fields.

I may try a union query.

The fact that the tables are not joined until the query makes it more difficult
 
Back
Top