Crystal Reports Counting on UnSuppressed Records

Report Design

Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design

Topic: Counting on UnSuppressed Records

Post Reply

Post New Topic

Author	Message
NCR1 Newbie Joined: 01 Oct 2009 Online Status: Offline Posts: 4	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 Logged


lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	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 Logged

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