Group value duplicated

[JanS]

Hi,

Im experiencing a problem with a report. One of the groups in the report is not displaying/grouping values correctly. For example, instead of seeing the following values for each group:

00
01
02
etc

I see

00
01
02
00
01
02
etc

The group values are not reported once but many time depending on the number of detail records.

If I remove the group, readd it and rerun the report the group seems to be displayed correctly. However, if i save the report, close Crystal, reopen and run the report the same problems with the group occur.

I am using CR 8.5. Any help would be greatly appreciated as Ive got some angry users who want to know why a report that was normally 2 pages is now 35!!

Cheers
jan

 

[synapsevampire]

So there's only one group in the report?

Since this group is NOT a number (00), then you'll have problems anyway as 100 would come before 20.

Rather than using text to describe the concern, why not include technical information, such as:

Database used
Example data
Expected output

And in the instance of already having a report layout, demonstrate what you have.

Crystal does group correctly, and I've never heard of this particular error, but I always suggest applying the service pack:

http://support.businessobjects.com/fix/hot/si75/form.asp?file=cr85win_en_sp3.exe

-k

 

[JanS]

No, theres more than one group in the report but only one is causing a problem - no need to mention those.

Im not concerned about the order in which the values are returned, Im concerned that they are being repeated when my understanding of the benefits of using groups was to "group" like values within a particular field and only display the value once.

Im using CR 8.5 (with the service pack you suggested), SQL Server 2000 SP3a.

Example Data:

raw data
Field1 Field2
00 55
00 45
01 70
01 30
02 65

what im expecting to see

00
55
45
01
70
30
02
65

What i do see

00
55
01
70
02
65
00
45
01
30

 

[JanS]

Its okay - Ive recreated the report. All sems fine now. Ive no idea what happened as nothing in the original report had changed for 12 months.

Thanks for the help.