Thanks, that did help. I used a subreport for the items part and listed the payments in the usual way. The problem I had originally was that this report was a subreport already but I just rejigged things so that it was a main report.
Thanks for your time and help
Martin
Thanks for taking the time to reply. I'm using Crystal 10 and have been using the report wizards to query a local MySQL database - I've heard of a left join but wouldn't know what to do with one! Here's my table structure for the report I'm playing with.
# Table structure for table `agents`...
OK, I know I'm being dumb but I'm new to Crystal and really stuck - I'd appreciate any advice on the following.
I'm creating a report to issue a statement of account to a customer. It needs to detail items ordered and payments received (often multiple instances of both) and work out whether...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.