Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Cross tab problem Post Reply Post New Topic
Author Message
foxy
Groupie
Groupie
Avatar

Joined: 12 Jul 2007
Online Status: Offline
Posts: 50
Quote foxy Replybullet Topic: Cross tab problem
    Posted: 11 Sep 2007 at 1:26am
I have a cross tab that has a priority level as the rows, a department as the columns, and a distinct count of an indicator ID number is the summary. This works fine and returns the correct data.
 
However, when the grand totals are displayed, crystal seems to be mis-calculating them. I think this is because a few of the indicator numbers are present in more than one department, and the total is performing a distinct count as well, which it shouldnt be.
 
Surely the grand total sections should just add up the numbers displayed in the cross tab, but they seem to be doing their own distinct count calculation on the data.
 
Is there any way to force the cross tab totals to simply add up the values displayed in the cross tab rather than second guessing the data?
 
Thanks
FOXY
IP IP Logged
p&ccrystal
Newbie
Newbie
Avatar

Joined: 06 Sep 2007
Location: United States
Online Status: Offline
Posts: 18
Quote p&ccrystal Replybullet Posted: 12 Sep 2007 at 6:31pm

You can try this and see if it works. Copy the distinct count and paste it in the same section on the report. Right-click the distinct count you copied and scroll down to Edit Summary... Then change the summary type in the 'Calculate this summary:' drop-down box from Distinct count to Count. Then go into the Cross tab expert and replace the Distinct count with the Count you just created. Sounds as if you want to use the Distinct count on another part of the Cross Tab so make sure you do not delete the original summary as your Cross Tab will still need it where it is.

I don't do a lot of cross tabs but copying the summary fields and changing the summary types works in other reports so it should work in cross tabs reports too. You may use the Report Explorer or Cross Tab Expert to make sure you have the new summary where you want it on the Cross Tab.

Hope this works for you!

10 year user of Crystal Reports - recently implemented Crystal Server 11.5
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.