Showing results for 
Search instead for 
Did you mean: 

Bizarre behaviour w/ sorted metrics using CR4E (v2.0) and Crystal XI

Former Member
0 Kudos

First post here so go easy on me...

We are having a strange problem with sorted columns and grouping when rendering reports in CR4E (v2.0) on IE 7 with reports created by Crystal XI. Basically, when certain columns are selected to sort in the parameterized view(the sorts are parameterized group sorts), some of the groups are repeated with eronious data. The data is wierd because not only do the groups appear multiple times, but the metrics are incorrect, and the summing of the metrics are incorrect. This is not happening for every column being sorted, only certain ones.

I should mention that the summarized totals of all groups summed together is correct. The eronious data and incorrect addition only happens when one drills down through various groups and sub groups.

Are there known compatiblity issues with parameterized sorting in reports created with CRXI and being displayed in CR4E v2.0? I know that CR4E v1.0 did not even support parameterized sorting. Would Crystal 2008 solve this problem for us?

Edited by: rdudejr on Nov 11, 2009 9:36 PM

Edited by: rdudejr on Nov 11, 2009 9:39 PM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I think I solved this. We removed original order sorting, and all seemed to be well. The grouping and sorting worked properly without duplicating the groups with erroneous data. What concerns me is that the release notes for JRC2.0 says this specifically:

"u2022 Reports containing groups with the group sort option set to u201Coriginal orderu201D

can be opened, but the sort order will not change automatically. If you

require a different sort order, you must manually change the sort order."

Just for curiosity, has anyone else run into this?