Combine 2 reports into one

Doug · External Since: Mar 10, 2006 Posts: 54

I have an expense report that calculates all expenses for filtered record. I
also have a report that calculates the amount of time billed for the filtered
record. How can I combine the two reports so that I only have one report that
does both? I have seen a sample template where they designer added an
additional report header but I do not know how to do that.

Steve · External Since: Aug 04, 2009 Posts: 47

One option ........

Create a new unbound report. Add your expense report as a subreport. Below
the expense subreport, add your billing time report as another subreport.

Steve
santus DeleteThis @penn.com

"Doug" <Doug DeleteThis @discussions.microsoft.com> wrote in message
news:BF8CA1E0-4339-41C5-850D-7247FEBA3F9C@microsoft.com...
>I have an expense report that calculates all expenses for filtered record.
>I
> also have a report that calculates the amount of time billed for the
> filtered
> record. How can I combine the two reports so that I only have one report
> that
> does both? I have seen a sample template where they designer added an
> additional report header but I do not know how to do that.

StopThisAdvertising · External Since: Oct 05, 2009 Posts: 2

"Steve" <notmyemail.DeleteThis@address.com> wrote in message
news:wpidnYLFpYAuflXXnZ2dnUVZ_gWdnZ2d@earthlink.com...
> One option ........
>
>

Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... very soon we will
'celebrate' 10.000
pageloads...)

For those who don't 'agree' with this mail , because $teve was 'helpfull'
with his post...
We warned him a thousand times... Sad, but he is not willing to stop
advertising...

He is just toying with these groups... advertising like hell... on and on...
for years...
oh yes... and sometimes he answers questions... indeed...
and sometimes good souls here give him credit for that...

==> We are totally 'finished' with $teve now...
==> Killfile 'StopThisAdvertising' and you won't see these mails....

Duane Hookom · External Since: Feb 07, 2005 Posts: 1359

Many times the record sources of both reports will have similar columns. If
this is true for you, I would first consider creating a report based on a
union query.

Otherwise, you can use subreports. Keep in mind that Page sections will not
display in subreports. You can generally use Report sections or create a new
top level grouping section based on a constant expression like:
=1
Display the header for this section and set its Repeat Section property to
Yes. This will be your subreport's Page Header section.
--
Duane Hookom
Microsoft Access MVP

"Doug" wrote:

> I have an expense report that calculates all expenses for filtered record. I
> also have a report that calculates the amount of time billed for the filtered
> record. How can I combine the two reports so that I only have one report that
> does both? I have seen a sample template where they designer added an
> additional report header but I do not know how to do that.