not count duplicates in report group

[Guest]

Hi, I have a report that looks like this:
Argentina
Project A Language 1
Project A Language 2

At the bottom I want to count the total unique Projects and Languages. I've
got the languages ok, but how do I count the unique Projects so the result is
1 instead of 2.

I have chosen to group by country, but not Project and don't want to group
by Project. Thanks for any help you can give.

Harold

 

[Marshall Barton]

Hi, I have a report that looks like this:
Argentina
Project A Language 1
Project A Language 2

At the bottom I want to count the total unique Projects and Languages. I've
got the languages ok, but how do I count the unique Projects so the result is
1 instead of 2.

I have chosen to group by country, but not Project and don't want to group
by Project.

You really do need to group by project, but you do not have
to display the group header or footer so the only visual
effect is that the projects will be sorted.

You can then add a text box (named txtProjectCounter) to the
project header or footer section. Set its ControlSource to
=1 and its RunningSum to Over Group

Then the country group footer section can use a text box
with the expression =txtProjectCounter to display the count
for each country.

If you want the count for the entire report instead of for
each country, change the RunningSum property to Over All and
place the total text box in the report footer section.

 

[Guest]

Thanks Marshall, I'd seen a similar response from you to someone posted about
a year ago, but it was different enough that I couldn't figure out how to
apply it to this. Thanks for your help, and I do plan to also run the count
for the entire report, so thanks for answering that before I even asked!

Harold
=============================