bmatumbura
asked on
Using VB Reports without Data Environment
I have a relational database that has 3 tables. The tables are as follows:
1. Quotation
============
QID
Date
Customer
2. Repairs
==========
RID
Date
Amount
QID
3. Fitments
===========
FID
Date
Amount
QID
The primary keys of the tables are QID, RID, and FID. QID in tables 2 and 3 is a foreign key to participate in the relationship with table 1.
I need to produce a report that shows, for each quotation: All the repairs and fitments that were done using vb code. I don't want to use the Data Environment/Designer to produce the report. The report should show the Quotation details followed by a grouped list of all repairs and a grouped list of all fitments, all on one page. It should compute the sum of all repairs and all fitments and put the total at the bottom of the report.
1. Quotation
============
QID
Date
Customer
2. Repairs
==========
RID
Date
Amount
QID
3. Fitments
===========
FID
Date
Amount
QID
The primary keys of the tables are QID, RID, and FID. QID in tables 2 and 3 is a foreign key to participate in the relationship with table 1.
I need to produce a report that shows, for each quotation: All the repairs and fitments that were done using vb code. I don't want to use the Data Environment/Designer to produce the report. The report should show the Quotation details followed by a grouped list of all repairs and a grouped list of all fitments, all on one page. It should compute the sum of all repairs and all fitments and put the total at the bottom of the report.
Éric Moreau
looks like homework.
Use Excel-object
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for the late response: thought more solutions might come.