Step 1 Create Class file as Pivot.cs and copy the below text and save in your file . using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; /// <summary> /// Pivots the data /// </summary> public class Pivot { private DataTable _SourceTable = new DataTable(); private IEnumerable<DataRow> _Source = new List<DataRow>(); public Pivot(DataTable SourceTable) { _SourceTable = SourceTable; _Source = SourceTable.Rows.Cast<DataRow>(); } /// <summary> /// Pivots the DataTable based on provided RowField, DataField, Aggregate Function and ColumnFields.// /// </summary> /// <param name="rowField">The column name of the Source Table which you want to spread into rows</param> /// <param name="dataField">...
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
What Is Dot Net? Image via Wikipedia .NET, is a software framework primarily for XML web services created and disseminated by Microsoft. In other words, .NET is a software platform through which programmers can develop programs that cause users to interact with one another’s systems rather than the program itself. For example, Windows Live Messenger is a .NET program that allows users to open the application and connect directly to other users. This is as opposed to traditional programs like Microsoft Outlook, which will take input from one user and deliver it to another. Therefore, while most programs act as intermediaries, .NET programs act as direct lines to other users that control only the way users interact rather than the interaction itself. .NET comes complete with a library of coded solutions to common issues that arise and a virtual machine to execute programs created using the framework. Programmers use the framework’s Base Class Library, whic...
Comments
Post a Comment