Counting Field Values per type
Hello,
I have a master detail report. Articles are listed in detail band.
At the end of the report, I would like to display a summary showing the number of devices per article.
Here is a similar example: http://www.databasedev.co.uk/count_values_countiif.html
How can I solve this with FastReport?
Thank you
I have a master detail report. Articles are listed in detail band.
At the end of the report, I would like to display a summary showing the number of devices per article.
Here is a similar example: http://www.databasedev.co.uk/count_values_countiif.html
How can I solve this with FastReport?
Thank you
Comments
Since it also sounds as if you want the summation to be across all the master-data bands, not just within the given master's detail rows, have you looked at creating a secondary query that simply counts the "device" rows in the detail table?
e.g.
Then display this as a sub report after the Master/Detail bands.