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