Data Report...

Hello guys... help me this problem... I want to make a report using Data Report I want to display an information when i search the name of the customer or after the transaction made the customer has a receipt or information like this when i click print button: in examples:

Table : Customer
Table : Stocks
Table : Details

I want an sql to display/retrive on one name only and the following stocks in the details.

Sample output in Data Report:

Name : James N. Bond

Qty Description Unit Price

3 Stocks 1 50.75
10 Stocks 2 150.00
5 Stocks 3 1500.00

Total 1700.75



Thank you and God bless, I hope that you help me... if you want to see more tables for me just give me your email address.

I'm using Adodc in module.

Public Rs As ADODB.RecordSet
Public Cn As ADODB.Connection

Moved to reporting