SAP Crystal Report - How to Get the Grand total from Subreport

[former_member366557]

Dear All,

I am sorry i  have another problem in crystal report, i hope you help me:

I have a report  and i am using a subreport: my proble is how can i get the grand total Freight 1 as you can see in the screen shot. and how can i view this into Main report:

MAIN REPORT :

BELOW IS THE SUBREPORT

Thank you

Regards \

Silent

[abhilash_kumar · Accepted solution]

Hi Silent,

Inside the Subreport, create a formula with this code:

shared numbervar freight := Sum({@Freight});

Back in the Main Report, create another formula that refers to this variable and place it on a section below the section that holds the subreport:

shared numbervar freight;

-Abhilash

[former_member366557 · Accepted solution]

sir please see  of what i doing with regards to your instruction

on the subreport

and in my main report

but the output is as you can see below- it will display the last row in the subreport

[abhilash_kumar · Accepted solution]

If you need the sum of freight for all groups, modify the formula in the subreport to:

shared numbervar freight := freight + Sum({@Freight});

-Abhilash

[former_member366557 · Accepted solution]

ok sir i will try thank you