groups sometimes print twice

[bardley]

Hi. I have a report with three groups. The first is an interior/exterior group. The value is included in each record as a separate field, and is either 1 or 0 (basically a boolean). The second is an IP address (e.g. 50.50.75.75).
This is stored as a text field. The third is a cluster number, because within each IP address there are clusters of records (by time). The report appears to run beautifully, except that I noticed that sometimes a group will appear twice (with different data). E.g.

[group header] 210.253.184.3

details and group3 stuff

[group footer] totals blah blah blah

[group header] 210.253.184.3

details

[group footer] totals

The duplicate sections appear to always print after the section with the same ip address. I inserted a formula to check the length of the IP address (to see if there were spaces getting in there or something), but both group names (in the above example) return 13, meaning they're identical, right? Also, the problem doesn't appear to be with the int/ext group, because this problem occurs within interior or exterior groupings.

Has anyone else experienced this problem? Any advice as to what I should be looking at? Thanks in advance for any help!!

 

[kenhamady]

First, confirm that the field that you are seeing in the group header is the same field as used for that group. sometimes they will group on an ID field, but display the description, which will give you this behavior.

Do you mean the length is 13?

In CR V6, I have seen this problem occasionally. Change the group to another field temporarily, and then change it back, and see if that clears the problem. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[MalcolmW]

A few questions
Does this happen on the same page (ie have you check Repeat Group Header on New Page)? It wouldn't fit all your symptoms, but let's get that out of the way.
What is the boolean value for Group 1 in your problematic Group 2 values?
What type of sort are you using for Groups 1 and 2? (if you are sorting in specified or orginal order, you could get this behaviour) Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[bardley]

Hey guys,

First, I stuck a "strcmp" field in the details section, and all the details match up with the group header.

Second, I was sorting the groups in "original order," and then with the top N expert on the number of events in the group. Well, I changed from original to ascending, and it appears to work now.

Thanks for your help, gentlemen. Brad Gunsalus
Cymtec Systems, Inc.
bgunsalus@cymtec.com