Summarizing Details in a group header 1

[Adammon]

I'm attempting to summarize date information for an exception based report and am running into several difficulties.

The report I have currently creates an exception for a day based on specific criteria. This is display in the details section of the report. The group above is based on location. What I need is the ability to have a text field that, in the group header, displays the days of the exceptions from the details in a comma delimited list.

IE Arizona being one field and then September 1, September 9, September 14, September 15..etc

I've tried playing with the whilereadingrecords whileprintingrecords but can't seem to get it to read at the right time. I'm sure there has to be something I have to do with these commands and some type of array or global variable to contain them as it runs through it's details.

Any ideas?

Thanks

 

[dgillz]

In the group header:
WhilePrintingRecords;
Stringvar List:="";

In the details section:
whilePrintingRecords;
If OnFirstRecord then Stringvar Names:={YourField} else
if{YourField}=previous({YourField}) then StringVar Names:=StringVar Names else
Stringvar Names:=Stringvar Names+", "+{YourField}

In the group footer:
WhilePrintingRecords;
Stringvar Names;

Let me know if you have any problems with this.
Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com