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: 248

Filed under:

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

Related posts about sql-server-2005