Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Zero out Subtotal FIeld After Post Reply Post New Topic
Author Message
HolyCow
Newbie
Newbie
Avatar

Joined: 18 Sep 2008
Location: United States
Online Status: Offline
Posts: 15
Quote HolyCow Replybullet Topic: Zero out Subtotal FIeld After
    Posted: 16 Jan 2009 at 8:34am
I have a subtotal field in a subreport that is being passed to the main report and added to another subtotal field from a second subreport.  How do you zero out the subtotal field once its been "Shared"?  The problem I am having is it "remembers" the value that was in the field so when I get a blank section, it passes the value that was in the filed before the blank section came along.  Help, PLEASE.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 19 Jan 2009 at 6:41am
You will need to decide where you want it to be 'Reset', but once you know that, the rest is a piece of cake.
 
Create a formula that sets your shared variable to 0, like:
shared numbervar aVar :=0;
""       // I put this here so that nothing displays on the report.
 
Now just drag the formula onto the report where you want the variable reset.
 
Hope this helps
 
IP IP Logged
HolyCow
Newbie
Newbie
Avatar

Joined: 18 Sep 2008
Location: United States
Online Status: Offline
Posts: 15
Quote HolyCow Replybullet Posted: 19 Jan 2009 at 6:45am

Thanks, it did indeed help much.  I figured that it had to go after the catpture of the variable, after a bit of moving and testing.  Thanks.  ;)

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.033 seconds.