You might study summarized reports and how using fields in the summary parts only shows one instance.
A good starting place is this KB (knowledge base) article:
(follow the links on the page, too!)
Thanks for the pointer but it doesn't seem to do what I need, I'll give you a quick run down:
Receipts file has multiple records for each invoice that has been paid, all with the same reference number. My current report summarises these perfectly, but each line of an invoice has 2 entries in the receipts file, one against the product category and one against Tax.
If you look at the pdf I have an invoice number, customer (which is blanked) and total amount on the invoice. Under that there are two entries for each invoice line, but I want to summarise these as well so I only have 1 for each accounting code rather than duplicates. I need summaries under summaries if that makes sense.
Thanks a lot for any pointers
1 of 1 people found this helpful
If I understand correctly, you need to:
- add another sub-summary part "by category"
- add the category name and your existing summary field to the new sub-summary part
- consequently, sort the found set by invoice number and category
Since at this point you're summarizing everything, you could remove the body part.
If this is not what you want, maybe create a sketch of the desired design and post it.
Perfect, Just what I needed, just have to hide the reference in the new sub-summary
Thanks a lot for your help.