I have a report ( rptAPDetails) that is based on qryAPDetails shows grant expenses for all invoice payments. Similarly I have a report ( rptPayDetails) that is based on qryPayDetails which shows payroll expenses for grants.
I would like to generate a report combining these two reports. Where I will be able to combine expenses for all grants by types. For example, Grant 9500215
A/P Expenses $xx,xxx.00
Payroll Expense $xx,xxx.00
TOTAL $xx,xxx.00 GRAND TOTAL (All grants) $xxx,xxx.00
I made a copy of rptAPDetails and called it srptAP and similarly created srptPay. Used these two reports as sub reports. But I didn’t succeed. My main form is based on tblECHO where ECHOID is the PK (auto) and ties all these queries.
How do I combine these reports? Can someone please help me with directions?
Thanks.
21 5585 Denburt 1,356
Recognized Expert Top Contributor
The main report should contain a query with tblGrants and tblFundGrants so you can tie them together on the child/master fields using tblFundgrantID. Try that and let me know how it goes.
Thanks for the tip. I will try. This is what I am planning to do. See if I am on right track.
1. Create a query using tblECHO, tblGrants, tblGrantFunds. Let's name it qryECHO
2. Create a main report: rptECHO based on qryECHO
3. Question: Do I add srptAP and srptPay on to rptECHO? or Do I add qryAPDetails and qryPayDetails?
I am looking forward to fruitful Thursday. It will be nice to accomplish something before I leave for the long weekend.
Thanks.
Denburt 1,356
Recognized Expert Top Contributor @MNNovice
Sounds good
3. Question: Do I add srptAP and srptPay on to rptECHO? or Do I add qryAPDetails and qryPayDetails?
I am looking forward to fruitful Thursday. It will be nice to accomplish something before I leave for the long weekend.
Thanks.
Add your two reports to the main report make sure the child/master fields have their relations and you should be set. Good luck, I do hope today is fruitfull for you.
Add your two reports to the main report make sure the child/master fields have their relations and you should be set.
I am assuming you are referring to rptApDetails and rptPayDetails (Post #1). Am I correct?
NeoPa 32,568
Recognized Expert Moderator MVP
Are you dealing with forms or reports (or maybe both)?
NeoPa:
I am dealing with reports. Trying to create a report that will combine info from two other reports. Report 1 is rptAPDetails (has all invoice expense data for grant expenses) and Report 2 is called rptPayDetails which has all payroll expenses for grants.
The process to claim reimbursements for these grant expenses is called ECHO. I have a tblECHO with a PK (auto) ECHOID. Based on Denburt's suggestion, I created qryECHO to include tblECHO and tblGrantFund. GrantFundID is the field that ties these tables.
I was successful in creating reports on AP expenses and Payroll expenses. I am trying to combine the two and create ECHO reports by grant expenses. It should list ECHO No, Grant No and associated AP and payroll expenses for these Grants.
ECHO: 1
Grannt 1xxxxx
AP $00000
Pay $00000
Sub Total $0000000
Grant 2xxxxx
....
Total ECHO 1 $000000
You get the idea.
But I didn't succeed doing this, YET. As I tried to use rptAPDetails as a sub report to rptECHO and selected: " Show tblAP for each record in qryEHO using GrantFundID" I got this error message: "The link you selected cannot be used. This link was created based on relationships betwee source tables. To use this link you must add the missing field to the form or report's record source."
I am not sure I understand what is the solution here. When I select: "show qryECHOAPDetail for each record in qryEcho using ECHOID" each ECHO is repeated several times (16 -18 times). Of course I need to use the GrantFundID but have not been successful.
Can you give me some direction?
Thanks.
Denburt / NeoPa
I think I figured it out a little bit more. So don't respond to my help until I come back and report on my progress. Thanks.
NeoPa 32,568
Recognized Expert Moderator MVP @Denburt
My advice would be very much along the lines of what DenBurt suggested. This isn't an area I have a lot of experience in, but the quoted approach should work, assuming the links between all the items are logically organised.
Denburt 1,356
Recognized Expert Top Contributor
Make sure GrantFundID is in the query that you are using in the record source for the main report and the subreports. It sounds like that is or could be the problem there.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: mark |
last post by:
Access2000
How do I write a query that combines the CTC field from each record below into
one record? I need to concatenate the CTC field with a separator, like below:
BattID VehicleID STDATE STTIME CTC
LKO500HF 00000000 10/27/2003 4:13:51 AM 4
LKO500HF 00000000 10/27/2003 5:13:51 AM 5
LKO500HF 00000000 10/27/2003 10:13:51 AM 6
LKO500HF 00000000 10/27/2003 11:13:51 AM 4
|
by: Jamie Pittman via AccessMonster.com |
last post by:
I have two tables with 5000 entries on them. One is based for regular time
with several variables example (employee name, date,time in and out, code,
customer, building) I have another table that works with overtime but has
the same feilds within the table. I want to be able to run a report that
combines the regular time and overtime for the warehouse and seperated by
each customer. I have tried join tables but I keep ending with, (if it...
|
by: trint |
last post by:
add them into one PrintDocument:
PrintDocument pd1 = new PrintDocument();
PrintDocument pd2 = new PrintDocument();
PrintDocument pdCombined = new PrintDocument();
pdCombined = pd1 + pd2;
pdCombined.Print();
Thanks,
Trint
|
by: Hendri |
last post by:
My company have any report with ms exel , My question is how to make a web
application with asp.net that can join with all office fitur. and i want to
save the spread sheet by day, so if my boss want to see a Tommorow Reports
he can see it , sama like Crystal report ...?maybe that alls thanks....
|
by: Red |
last post by:
So I inherited this db that has multiple 'orders' tables.
Each order table is name for the year of the orders...
i.e. 2005 is 'Orders-2005', 2006 is "Orders-2006"
So, I am not allowed to change the tables (boss likes how her stuff
works.. bleh...)... but I am being asked to created a way to show all
the orders from the last 12 montsh for a particular item, on demand.
Previously the db was just used for quarterly reports, but she wants
| |
by: David Lozzi |
last post by:
Howdy,
Can I compile multiple Crystal Reports into a single PDF? If so, how? I need
this functionality because the second report will be selected by the
user.... Is there a way to select a report in the actual Crystal Report?
Then I can just include it as a subreport....
Thanks
|
by: Venk |
last post by:
I want to combine 2 different reports.
That is Report 1 should be followed by report 2
If Report 1 is in Page 1, automatically report2 should be in page2
Any thought or help on this would be appreciated.
thanks
venk
|
by: drurjen |
last post by:
Good morning.
I am importing an XLS file into one of my tables. The fields are:
Date Id Time IO
12/22/2006 2 12:48:45 PM 9
12/22/2006 16 5:40:55 AM 1
12/22/2006 16 12:03:59 PM 2
When I do the import, I get the following:
|
by: MNNovice |
last post by:
I have three tables, tblAP, tblPayroll and tblAllocation. Each records three separate expenses. All three are related by FK ECHOID, each has common fields such as AccountNo, FundNo, GrantNo, SubClassNo, ProjectNo and Amount
Originally I created these 3 and was able to generate combined reports using queries. But I have been unable to use these queries and tie it to create a report that will show Revenue, Expenses and balance side by side. ...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |