How to Display Page Wise Total Amount And Grand Total Amount in Last page SSRS & RDLC Report Step 1 Go to Project Menu >> Add Page Footer After click on the Add Footer Menu footer automatically add in the report. See Figure 1 Figure 1 Step 2 Add new TextBox for display page wise total and edit expression of TextBox . See Figure 2 Figure 2 Add this expression for page total TextBox =Sum(ReportItems!TotalAmount.Value) Step 3 Add new TextBox for display Grand Total in Last Page of RDLC report and edit expression of TextBox . See Figure 3 Figure 3 =IIF( Globals.PageNumber =Globals.TotalPages,Sum(Fields!TotalAmount.Value, "DataSet1"), "") Step 4 Run the application and test the reports Thanks Smruti
Comments
Post a Comment