CR 2008 on an SQL database.
I need to count the records for each of my names, but the suppression field uses a running total, and I can't work out how to distinctcount.
Gp1: Name
Gp2: Reference
Gp3: Details: Units of Time: Value of Time: Activity Code: Budget Vale:
I have running totals in the Reference group footer, for the time value by each different activity code.
I have a separate formula that evaluates each of the activity totals against the budget value for that specific activity, which generates a %.
I then suppress each reference group if none of the % > 80.
I can't work out how to count how many records are displayed for each name.
I hope someone can make sense of my problem !
Thanks
I need to count the records for each of my names, but the suppression field uses a running total, and I can't work out how to distinctcount.
Gp1: Name
Gp2: Reference
Gp3: Details: Units of Time: Value of Time: Activity Code: Budget Vale:
I have running totals in the Reference group footer, for the time value by each different activity code.
I have a separate formula that evaluates each of the activity totals against the budget value for that specific activity, which generates a %.
I then suppress each reference group if none of the % > 80.
I can't work out how to count how many records are displayed for each name.
I hope someone can make sense of my problem !
Thanks