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 Lo...
Read more

Export SharePoint Online Group Users to Excel using Powershell

-
Sometimes, we have a requirement to generate user reports from SharePoint groups or validate which user is added to which groups etc. If we do this activity manually, it may take forever (obviously based on the user added to group 😉).  Classic example, recently in my project i got a requirement where i need to find all the users who are added to multiple SharePoint groups. Now i have 2500 users added to my SP Groups and it is difficult to check one by one. So i generated CSV/Excel for each group and added a vlookup in excel and got my report. Below is the Powershell script, which helps to generate CSV file based on group name.  Note: All the input variables are mentioned in Green Color, Please update before executing this script. $aClient = [ System.Reflection.Assembly ]:: LoadWithPartialName( "Microsoft.SharePoint.Client" ) $aClientRuntime = [ System.Reflection.Assembly ]:: LoadWithPartialName( "Microsoft.SharePoint.Client.Runtime" )   Function Get-UserInfo...
Read more