Print Page | Close Window

Crosstab distinctcount summary

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21042
Printed Date: 02 May 2024 at 7:33pm


Topic: Crosstab distinctcount summary
Posted By: Macavity
Subject: Crosstab distinctcount summary
Date Posted: 18 Sep 2014 at 8:17am
Hi,

I got wrong totals in a crosstab that has a disctinctcount summary.

The way I solved this :

make a formula @total :

{columnfield} + {rowfield} + {sumfield}

and do a distinctcount on @total in de crosstab.


Print Page | Close Window