How are you accessing this report? Do you have access to either the full version of Crystal Reports 10 or to a copy of Visual Studio 2008 or older that has CR 10 installed with it? You need one of the two in order to do this.

In the report, I would do this:

1. In the "Field Explorer", look for the Parameters list and delete the parameter that asks for the initials.

2. Group by the Provider name.

3. Put the provider name and the sum of families in the Provider group header.

4. Right-click in the grey area to the left of the report design and open the "Section Expert". Suppress the Details and Group Footer sections.

-Dell

How are you running/opening the report?

-Dell

Ok, you have Crystal 10, not Crystal for Visual Studio.

In the field explorer, is the delete greyed out when you select the parameter? If so, that means one of two things, which you can determine by looking at the Database Expert:

1. The report uses a Stored Procedure to get its data and the parameter is required by that. In order to update the report, you're going to have to work with your DBA to create a new one that doesn't require the parameter. Then you'll have to recreate the report (I think there were issues in CR10 with using "Set Location" for stored procs.)

2. The report uses a Command. This means that SQL was written for the report. Right-click on the Command in the Database Expert and edit it. On the right of the screen there will be a parameter with the same name as the one in the Field Explorer. Delete it. Then look at the "Where" clause of Select query in the Command and remove the part that uses the parameter - it will look something like this:

MyTable.Initials = '{?Initials parameter}'

If that's the only condition in the Where clause, remove "Where" as well. If it's one of many conditions remove one "and" - either before or after the condition, but not both.

-Dell