Rows count of a linked table

DomiDomi Belgium
edited November 2018 in FastReport .NET
Hi,

I have 2 linked tables : "Customers" and "Transactions", Customers contains unique entry but the linked transactions can have 0 or x transactions per customers.
I need a list to display each customers and the number of transactions per customers without displaying any field of the transactions table

is there any function which returns the row number like 'select count(*) from ...'

how can I achieve this easily ?

thanks in advance,
Domi.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport .NETComment As ...

© Vanilla Keystone Theme 2024