I'm probably making this a lot harder than it really is. I want to create a report that shows a current balance. One table (tableA) has beginning balance information and total charges in it. There is one record per customer. Another table (tableB) has daily deposits in it. There are multiple records per customer.
I need a report that will report:
tableA.beginbalance - tableA.charges + sum(tableB.deposits)
In other applications this is pretty straightforward. I don't see where I can use one report as a datasource for another report.
Do I use a subreport?
Mark
IP Logged
