A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combine 2 reports into one



 
 
Thread Tools Display Modes
  #1  
Old October 4th, 2009, 06:50 PM posted to microsoft.public.access.reports
Doug
external usenet poster
 
Posts: 616
Default Combine 2 reports into one

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.
  #2  
Old October 4th, 2009, 07:04 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Combine 2 reports into one

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



"Doug" wrote in message
...
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.



  #3  
Old October 5th, 2009, 08:52 AM posted to microsoft.public.access.reports
StopThisAdvertising[_2_]
external usenet poster
 
Posts: 6
Default Combine 2 reports into one

"Steve" wrote in message
m...
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....

  #4  
Old October 5th, 2009, 04:04 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Combine 2 reports into one

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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.