We have just upgraded to Accpac 5.5 and Crystal XI and switched from Pervasive to SQL.  I am working on Order Entry invoices and have run into some trouble with downpayments.  We enter our downpayments in the optional fields.  I am using Accpac's OEINPR3 invoice and trying to customize to our needs.  This is the invoice we have always used in the past, so would like to keep using it.  I created a subreport for the downpayment and that works fine.  My trouble is on the remittance slip, I can't figure out how to show the correct remaining balance.  I tried doing another subreport and that will show be the proper balance if they have a downpayment.  It will return the remaining balance or $0 if they paid in full.  But if I enter that subreport into the main report to use on the remittance slip and they don't have a downpayment, it will return $0 balance instead of the amount due.  I'm not sure how to link these two together to return the correct information.  I haven't used subreports very much, so I'm not real familiar with this part.  Any help would be appreciated. 

Look into Shared NumberVars.  It takes intermediate Crystal skills, but it can be very powerful.  You add two sections, each with a subreport that has a Shared Numbervar formula.  You overlay the sections so they don't take up extra lines.  Then you pull the values you need into the main report using another formula that references the Shared Numbervars in the subreports.

 I am working with JH23 on this.  We have sucessfully used Shared Variables.

1.  Created a shared variable on the main report,

2.  Calculated the shared variable value in a subreport,

3.  Set the value on the main report and then used the formulas as needed on the main report.

This works wonderfully when we are only running one report, but not when we run a batch of reports.  It is using the same value for the shared variable (i.e. down payment) for each report.  I am sure this is because I am setting it to a shared variable.   I don't think I can use a local variable for this because it will not bring the value in from the subreport.  Any ideas on how to get the variable to re-evaluate with each report?

Thanks

Khaas

You need another variable in the group header that sets the shared variable to zero.

 What everyone else said along with going to the Crystal Reports website (www.businessobjects.com) and downloading an example of this - it worked for me.