subreports.. Not sure how?
I'm pretty new to report building components because I've always hand coded
reports.
I have just two tables, one credits and anther debits where EVERY record is
tagged with the salesperson code. The report should look like :
-------------------------
salespeson 1:
list all the debits for salesperson 1
list all the credits for salesperson 1
-total debits for sales person 1
-total credits for sales person 1
salesperson 2:
list all the debits for salesperson 2
list all the credits for salesperson 2
-total debits for sales person 2
-total credits for sales person 2
Total for all
Grand total debits
Grand total credits
reports.
I have just two tables, one credits and anther debits where EVERY record is
tagged with the salesperson code. The report should look like :
-------------------------
salespeson 1:
list all the debits for salesperson 1
list all the credits for salesperson 1
-total debits for sales person 1
-total credits for sales person 1
salesperson 2:
list all the debits for salesperson 2
list all the credits for salesperson 2
-total debits for sales person 2
-total credits for sales person 2
Total for all
Grand total debits
Grand total credits
This discussion has been closed.
Comments
This looks like an example of a master with two detail datasets report.
Take a look at Demos 72 and 73 in the \RBuilder\Demos\1. Reports\...
directory. These show how to create this type of report. As for the grand
totals, you will need to make these calculations in the detail band of each
subreport. For instance, if you place a TppVariable in the detailband of
the subreport and use its OnCalc event to update another variable inside the
summary band of the report.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com