Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Counting on UnSuppressed Records Post Reply Post New Topic
Author Message
NCR1
Newbie
Newbie


Joined: 01 Oct 2009
Online Status: Offline
Posts: 4
Quote NCR1 Replybullet Topic: Counting on UnSuppressed Records
    Posted: 01 Oct 2009 at 1:32am
Hi,
I had placed all the Database Fields in Group header in order to suppress some records ,
But when am trying to do distinctcount on the records in group footer its also counting the suppressed records .
I need only the count of those records which are displayed in my report.
 
Any ideas please

Thanks in Advance
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 05 Oct 2009 at 2:28pm
need to use a shared variable and formulas...maybe running totals, but my preference is shared variables.
 
3 formulas
in group header reset:
shared numbervar aVar:=0;
 
in group footer display
Shared numbervar aVar
 
in Details increment:
shared numbervar aVar;
if not suppressed then //suppressed is your criteria
 aVar := aVar + {table.field};  //the amount to increment.
 
HTH
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.020 seconds.