Hello,
I'm using Infragistics Reporting and to generate a hierarchical group (Invoice/Payment) require to show the count of invoices (the input data is a list of payment with an invoice key) so I need a count distinct i.e. (invoice key: 1, 4, 4, 4, 5, 5, 7, 7, 7, 7 => count distinct invoice key = 4). How can I achieve that?
Regards,
Dominik
Hi Dominik,
If I correctly understand, you may want grouping your data by invoice key. Please take a look at these samples (Grouping: 1- Grouping through the Report Designer ; 2- Combining Report and Table Groups in a Report) and this help page (How to Group Data).
Hope it helps. But if you need any more help, please ask again.
regards,
Simon
Hi Simon, Thanks for the answer, I did group by Invoice Key, but I can't get the number of different invoice key. In Crystal Report you can have this function =Count(Distinct(InvoiceKey)). So yes I'm grouping by InvoiceKey but how can I get the number of different invoices?
Currently the only place where you can know the number of groups, is in a Summary Section. In the Summary Header or in the Summary Footer, you can add a Label control with the expression "=Count()". The result of the evaluation of the expression in that section is the number of groups.
To add the Summary Section, right click over the group header to display the context menu and select Add Summary { Header/Footer }
hope it solves what you need,
Hi Simon,
In my case I need that value in the report footer. Anyway, I added the value as a calculated parameter before generating the report. I was just hoping to have a solution in the report designer itself.