• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

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.
0
bmatumbura
Asked:
bmatumbura
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
looks like homework.
0
 
OlegPCommented:
Use Excel-object
0
 
Anthony PerkinsCommented:
In order to design a report with VB's Data Reports you must use the Data Environment.  Once it is designed, you can then remove the Data Environment and bind the report directly to the recordset.

Anthony
0
 
bmatumburaAuthor Commented:
Sorry for the late response: thought more solutions might come.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now