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?