Quick Reports Question

[rewdee]

Good Morning,

I'm using QR3.5 and D5 Enterprise and I'm trying to create a receipt like report. I have three queries:

1)Customer & Invoice
2)Charges
3)Payments

The master query is the Customer Information and Invoice and the two detail queries hook into the master query (Datasource:=dsMaster). I have grouping on the invoice number and have put all the customer information & invoice number in this group. I have a detail group band that displays the charges and a subdetail band that displays the payments. The subdetail band has its dataset to the qryPayments and HeaderBand is set to the Group band.

When I preview the report I get the qryCredits entire values for each invoice. I know I could write the two queries into one Union SQL statement and put all the QRDBtext into the detail band but I don't want to do that because I want to give the user the option of filtering on payment dates.

How do I create this report? Should I be using a subDetail band?

Thanks,
Bill N

P.s. Bonus question, how do I keep a running balance? Declare a private variable in the form but after that I'm a little lost.