Shared Variables duplicating sometimes

[PAULCALLAGHAN]

I'm using Crystal 8.5 with a pervasive database.

I know I'm using shared variables properly because I have carefully checked my results manually. However, I'm getting a duplication type problem when the linked field value is not always a pefect match.

The main report is based on the Part Master file. The subreport is based on the transaction history file, which may not contain all parts from the Part Master file. The link is part number.

When the same part number exists in both files (i.e main report and sub-report), everything is fine. The shared variable works right.

However, when the part number from the Part Master does not exist in the transaction history file the shared variable result uses the previous part number result. The shared variable is then duplicated from the last (valid) shared variable result. Why? How can I correct this?

 

[MColeman]

Put a formula at the end of the part number group, that clears the shared variable.

whileprintingrecords;
shared numbervar myvar :=0;

Or in the subreport, where the shared value is setup, check for
if isnull(secondtable.partnumber)=true then
shared numbervar myvar :=0
else shared numbervar myvar = set the value

 

[PAULCALLAGHAN]

Thanks MColeman, that worked.

That is, I used the second of your two approaches and I don't get the duplication anymore! Nice work.