<div>
I'm a bit confused. &nbsp;You say that you want a sum of &quot;@Labour Hours&quot;, but you say that the subreport has a formula that declares a variable named BudgetValue, and doesn't put anything in that variable. &nbsp;Also, you say that in the main report you have a formula named @DECVAL and a formula named @Labour Hours, and they're exactly the same (they both set Hours to 0). &nbsp;Do you really have two formulas in the main report that do the same thing?<br />
<br />
&nbsp;Basically, if you have a value in a subreport that you want to use in the main report, you put that value in a shared variable in the subreport, and then use that shared variable in the main report, in a formula that's located in a section that comes after the section that the subreport is in. &nbsp;If you want to add a total from the subreport, you can have a formula add each amount to the variable. &nbsp;For example, in a subreport detail section you might have a formula with a line like Hours := Hours + {some field}. &nbsp;Or, in the subreport report header or footer, you might have a formula with a line like Hours := Sum ({some field}), to put the total from the subreport in the variable.<br />
<br />
&nbsp;If you're trying to get a total for a group in the main report, you would put a formula in the group header in the main report that reset the variable to 0 for each new group.<br />
<br />
&nbsp;Without knowing more about your report and exactly what you're trying to do, it's hard to be specific.<br />
<br />
&nbsp;James
</div>


<div>
Hi James<br />
Good to hear from you<br />
The sub report DECVAL is <br />
shared numbervar Hours;<br />
<br />
if isnull (Sum ({@Labour_Hrs})) then Hours:=0.00 else<br />
Hours:= Sum ({@Labour_Hrs})<br />
&nbsp;not the one I intially sent<br />
<br />
Gordon
</div>


<div>
As usual a working solution
</div>


<div>
<div class="content wysiwyg-content">
I have a report with a sub report for Labour Hours<br />
With a @Sum of @Labour_Hrs<br />
I have created a shared formula in the sub report<br />
@DECVAL<br />
WhilePrintingRecords;<br />
Shared numberVar BudgetValue ;<br />
BudgetValue<br />
<br />
in the main report have also created @DECVAL<br />
WhilePrintingRecords;<br />
Shared NumberVar Hours := 0;<br />
<br />
Have created a formla in the main report @Labour Hours<br />
WhilePrintingRecords;<br />
Shared NumberVar Hours := 0;<br />
<br />
The main report has a group called @Equiplocation<br />
I would like to sum the @Labour Hours on the main report in both the @Equiplocation group and footer<br />
<br />
Gordon
</div>
</div>


I have a report with a sub report for Labour Hours
With a @Sum of @Labour_Hrs
I have created a shared formula in the sub report
@DECVAL
WhilePrintingRecords;
Shared numberVar BudgetValue ;
BudgetValue

in the main report have also created @DECVAL
WhilePrintingRecords;
Shared NumberVar Hours := 0;

Have created a formla in the main report @Labour Hours
WhilePrintingRecords;
Shared NumberVar Hours := 0;

The main report has a group called @Equiplocation
I would like to sum the @Labour Hours on the main report in both the @Equiplocation group and footer

Gordon

How to total a sub report

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.