Distinct Count in FastReport
Does anyone know how to make a distinct count in fastreport? Example I have the report:
Name sex number
Jo??o m 2
Jo??o m 5
Maria f 8
In the normal count, the result would be 3, but I want one that takes only the number of rows that do not repeat the field name . In this case, the result would be 2. Can anyone help me? That's just an example. I can not do a group by in SQL because I have several fields.
Thanks
Name sex number
Jo??o m 2
Jo??o m 5
Maria f 8
In the normal count, the result would be 3, but I want one that takes only the number of rows that do not repeat the field name . In this case, the result would be 2. Can anyone help me? That's just an example. I can not do a group by in SQL because I have several fields.
Thanks
Comments