Using Subreport Field in Main Report

[Hillary]

Can a field in a subreport be used in a formula in the main report? The table the field is on is only in the subreport, not in the main report.

Thanks,
Hillary

 

[IanWaterman]

Hillary

You can not use the actual field, but you can capture its value using a shared variable.

This variable can then be used inside a formula in the main report.

Ian

 

[Hillary]

Can you help me with creating a shared variable? I have never done a variable before.

In the main report I have Work Order and Quantity fields. The subreports are linked via the Work Order field. One subreport has the Material Cost. The other subreport has the Labor Cost, Burder Cost and Service Cost fields. I want to get the Unit Cost of a Work Order. The formula will be (Material Cost + Labor Cost + Burden Cost + Service Cost)/Quantity

Thanks for your help!

Hillary

 

[IanWaterman]

Create formula in sub report and insert in detail line or group line if calculated from a summary.
@material cost

whileprintingrecords;

// This ensures it is reset to 0 every time you use it.
shared numbervar material:=0;

// This calculates variable value
material:= {Feldname or formula};

In your main report amend your formula which calculates total cost.

whileprintingrecords;
shared numbervar material;

(material+ Labor Cost + Burden Cost + Service Cost)/Quantity


Hope this is clear good luck.

Ian Waterman
UK Crystal Consultant