Telerik Create Report

-
Create Report:
There are some steps to create telerik report
1. go to visual studio create a new project as ClassLibrary under Windows Template and name it as ClassLibrary1. 


 2. go to ClassLibrary1 add new item select DataSet under Data Template and name it as DataSet1.xsd

  

 3. go to DataSet1 window and Create new Data Table name it as Data.
4. Add columns to this table like DataColumn1, DataColumn2, DataColumn3 and build the Project ClassLibrary1
5. go to ClassLibrary1 add new item and select Telerik Report under Reporting Template and nae it as Report1.cs.


6. When you add new report then one telerik report wizard will be open.

  

 7. Click add new Data Source

8. Select Object Data Source and click ok

 9. Select DataSet1 and Click Next >

  

 10. Click Radio Button Choose a data source member and select DataSet1() and Click Finish >>|

11. Select objectDataSource1 and click Next >

 12. Next >
 14. Select DataColumn1 DataColumn2 DataColumn3 and click Report > and click Next >

 15. Next

 16. Next

 17. Finish >>|

18. Adjust fields according to what you need. where you want fields or Data Columns.

 19. Go to solution and add new project ASP.NET Web Application

20.  Go to Default.aspx and drag Report Viewer to this page.

 21. Build Solution

 22. Go to WebApplication1 add reference select ClassLibrary1

 24. Default.aspx:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication1._Default" %>

<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=6.2.12.1017, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"
    Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <telerik:ReportViewer ID="ReportViewer1" runat="server"></telerik:ReportViewer>
    </div>
    </form>
</body>
</html>
 
25. Default.aspx.cs:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using ClassLibrary1;
using System.Data;

namespace WebApplication1
{
    public partial class _Default : System.Web.UI.Page
    {       
         Report1 r = new Report1();
         protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                filldata();
                this.ReportViewer1.ReportSource = r;
            }
        }

        private void filldata()
        {
            DataSet1 ds = new DataSet1();
            DataTable dt1 = ds.DataTable1;
            dt1.Rows.Add("Data1", "Data2", "Data3");        
            r.DataSource = ds;
        }
    }
}


Comments

  1. chameleon20 October 2014 at 21:43

    I can not find Telerik Report under Reporting Template
    Need help

    ReplyDelete
  2. rama4 December 2014 at 03:58

    Thanks for this example . I need to create columns and rows dynamically so please made a example on that

    ReplyDelete
  3. Unknown8 June 2015 at 02:30

    This comment has been removed by the author.

    ReplyDelete

Post a Comment

Popular posts from this blog

C# Copy files from one server to another

-
Sometimes we need to copy files from one sever and paste those files to another server programmatically. So for that we can use below code but we should have admin credentials of that server where we want to paste files. In below method we need to pass source path of the server, from where we want to copy and destination path of the server, where we want to paste. Also we need to provide UserName, Domain, Password of the server where we want to paste those files. public void CopyFiles(string sourcePath, string destinationPath)         {             try             {                  IntPtr admin_token = new IntPtr();                 // use LOGON32_LOGON_NEW_CREDENTIALS as LogonType                 if (LogonUser(" UserName ", " Domain ", " Password ", 9, 0, ref admin_token) != 0)                 {                     WindowsIdentity wid_admin = new WindowsIdentity(admin_token);                     WindowsImpersonationContext wic =
Read more

Suppress StyleCop SA1600

-
    Local Suppression: [SuppressMessage("Microsoft.StyleCop.CSharp.DocumentationRules",  "SA1600:ElementsMustBeDocumented", Justification = "Reviewed.  Suppression is OK here.")] for local suppression you must use namespace  using System.Diagnostics.CodeAnalysis;   OR you can also use   [System.Diagnostics.CodeAnalysis.SuppressMessage ("Microsoft.StyleCop.CSharp.DocumentationRules", "SA1600:ElementsMustBeDocumented")]  Example:   using System.Diagnostics.CodeAnalysis;   [SuppressMessage("Microsoft.StyleCop.CSharp.DocumentationRules", "SA1600:ElementsMustBeDocumented", Justification = "Reviewed. Suppression is OK here.")] protected void Button1_Click(object sender, EventArgs e)   {   } [SuppressMessage("Microsoft.StyleCop.CSharp.DocumentationRules", "SA1600:ElementsMustBeDocumented", Justification = "Reviewed. Suppression is OK here.")]  protected v
Read more

Telerik Rad Grid Sorting

-
If you are using Telerik Rad Grid and also need to sort column on column's header click than for your requirement below code will help you surely. .aspx Code : <telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True" EnableViewState="false" AutoGenerateColumns="False" OnSortCommand="RadGrid1_SortCommand"  OnNeedDataSource="RadGrid1_NeedDataSource">  <SortingSettings EnableSkinSortStyles="true" />   <MasterTableView AllowNaturalSort="false" AllowSorting="True" AutoGenerateColumns="False">     <Columns>        <telerik:GridBoundColumn DataField="Name" HeaderText="Name"  SortExpression="Name">        </telerik:GridBoundColumn>        <telerik:GridBoundColumn DataField="Address" HeaderText="Address"  SortExpression="Address">        </telerik:GridBoundColumn&g
Read more