Sub reports find the sub total and grand total of each sub report in the main report
Posted
by sonia
on Stack Overflow
See other posts from Stack Overflow
or by sonia
Published on 2010-05-25T04:58:24Z
Indexed on
2010/05/25
5:01 UTC
Read the original article
Hit count: 274
sql-server-2005
i want to find the grand total from sub report subtotal. i have three subreports. 1. itemreport 2.laborreport 3. machine report. i have find total of that reports using shared variable. like using formula: shared numbervar totalitem=sum({storedprocedrename.columnname}) i have done dis in all the sbreports. now i m want the grand total of all these. i have written the formula in main report is:
shared numbervar totalitem; // same variable used in subreport item shared numbervar labtotal; // same variable sed in subreport labor shared numbervar machinetotal; // same variable used in subreport machine numbervar total; total=totalitem+labtotal+machinetotal; total
but it is not giving correct result.. it is not giving result in correct format plz tell me code of main report in detail.. thanks
© Stack Overflow or respective owner