Trouble with Main Reports/Sub Reports and Formulae 2

[edteck]

In essence I need to bring together two disparate unlinkable reports together(Purchase Orders, and Spares Issues) and add some additional information,mostly in text boxes,which will vary from week to week.    The way I do it is by using the Purchase Orders Report as the main report and inserting the Spares Issues report as a sub report.    I need to add the totals of the PO and Spares reports.  I can bring the two fields into the Page header, but can't total them without inputting the values.    Am I missing something?    I am newish to crystal.    

 

[MaryWhitney]

I typed a long response before, but must have done something wrong because it isn't here.&nbsp;&nbsp;(I'm new to this forum.)<br><br>The gist of the message was this:<br>You can try either shared variables or passing the totals as linked parameters to the subreport.<br><br>You may need to put the subreport in the footer of your report for the parameters to work.&nbsp;&nbsp;Either way, you need to define functions where you set the values that you want to pass in order to total them.<br><br>I have found shared variables to be somewhat unpredictable.&nbsp;&nbsp;You need to make sure that the value of the variable is set before you attempt to reference it.<br><br>Mary

 

[edteck]

Sorry for not replying sooner.&nbsp;&nbsp;&nbsp;Shared variables won't work.&nbsp;&nbsp;&nbsp;&nbsp;I'm struggline with parameters at the moment.&nbsp;&nbsp;&nbsp;Will let you know.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;It bugs me that I can export the report to Excel and perform any calculations I wish.&nbsp;&nbsp;&nbsp;&nbsp;I can then import to Access, then back to Crystal.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I must be missing something!!!!!!

 

[edteck]

Sorry for not replying sooner.&nbsp;&nbsp;&nbsp;Shared variables won't work.&nbsp;&nbsp;&nbsp;&nbsp;I'm struggline with parameters at the moment.&nbsp;&nbsp;&nbsp;Will let you know.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;It bugs me that I can export the report to Excel and perform any calculations I wish.&nbsp;&nbsp;&nbsp;&nbsp;I can then import to Access, then back to Crystal.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I must be missing something!!!!!!