Passing Data from SubR1 to SubR2

[Legend1]

Hi all,

New to this forum and new to crystal, so I'm hoping someone can help.

This is the scenario:

Main Report is driven by the Customer Table and lists all customers being grouped by Customer's Code. Subreport 1 holds customers sales from a diferent table and is also being grouped by Customer Code. Subreport 2 hold's customers budget information and is also grouped by customer code. I am them using Shared Variables to carry the information form Sub 1 and Sub 2 to another subreport (Sub 3) which will perform calculations based on these Variables. I am bring the data across no problem but for example, if a customer has made no sales, Sub 3 repeats the previous customers sales until it reaches the next customer with a value and then refreshes is.

Hope this makes sense and someone can save my sanity.

Legend1

 

[Ngolem]

In other words....you are carrying over a previous customer's sales.

You have not described how your report is set up..but just reset all of your shared variables to zero prior to starting the Group....do this in a section before the first subreport...creating a suppressed section if necessary.

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!