I am new to crystal report and am trying to figure out how to count the number of unique records in a list. The report draws date from two dables. Tabel1 has got a list of uniqe Project numbers, Table2 holds data of number of times a project has been postponed. Everytime a project is posponed a new record is appended to the botom of the table. Table two is linked to table1 by the unique record identifier.
Count function does not work and crystal complains that there is no group that matches the field.
table2 holds data like this
The result should then be listed like this:
Job 1 3
Job 2 2
Job 3 1
Job 5 1