How to create report in asp.net using Report Viewer

Question

I am using Visual Studio 2010. I have worked on Crystal Reporting before that but now i want to generate reports using Report Viewer. As i am new to this topic please Guide me. Thanks !!!

Pranay Rana · Accepted Answer · 2012-04-19 06:55:19Z

9

Basic tutorial for you

Adding and Configuring the ReportViewer Controls

Creating an ASP.NET report using Visual Studio 2010 - Part 1

Creating an ASP.NET report using Visual Studio 2010 - Part 2

Creating an ASP.NET report using Visual Studio 2010 - Part 3

How to use the Report Viewer Control to access a Reporting Services Server

answered Apr 19, 2012 at 6:55

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sonam Mohite Over a year ago

Hey Pranay....First thanks for help me out. Just there is little confusion about creating Dataset with Stored Procedures.As i have worked well with DataSet with Table so now wanna try this one.Can you post code for this.

Pranay Rana Over a year ago

@SonamMohite - check this stackoverflow.com/questions/10234562/… here i have answer you will get info from this

xlembouras · Accepted Answer · 2014-02-04 08:02:41Z

My code works to create Report for business class objects...

Creating Report using Business Class Objects & ReportViewer (ASP.NET/ C#) 1.Create Student Class

  public class StudentClass
  {
      public int No { get; set; }
      public string Name { get; set; }
      public string Degree { get; set; }
   }

2.Create Student Repository with GetStudents() function

public class StudentRepository : StudentClass
    {
        public List<StudentClass> studentList = new List<StudentClass>();

        public List<StudentClass> GetStudents()
        {            
            StudentClass student1 = new StudentClass();
            student1.No = 1;
            student1.Name = "Bhuvana";
            student1.Degree = "M.Tech";
            studentList.Add(student1);
            StudentClass student2 = new StudentClass();
            student2.No = 2;
            student2.Name = "Annie";
            student2.Degree = "B.Tech";
            studentList.Add(student2);
            StudentClass student3 = new StudentClass();
            student3.No = 3;
            student3.Name = "Muthu Abi";
            student3.Degree = "B.Tech";
            studentList.Add(student3);
            return studentList;
        }
    }

3.Using Report Wizard create “StudentReport.rdlc” and select DataSource

4.In Index.aspx add Script Manager and Report Viewer from ToolBox(Drag And Drop)

<div>
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>  
    <rsweb:ReportViewer ID="ReportViewer1" runat="server">
    </rsweb:ReportViewer>       
</div>

5.Modify Page_Load() method in code behind file

public partial class Index : System.Web.UI.Page
{
    StudentRepository sr = new StudentRepository();
    List<StudentClass> sc = new List<StudentClass>();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ReportViewer1.ProcessingMode = ProcessingMode.Local;
            ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report/Student.rdlc");
            sc = sr.GetStudents();
            IEnumerable<StudentClass> ie;
            ie = sc.AsQueryable();
            ReportDataSource datasource = new ReportDataSource("DataSet1", ie);
            ReportViewer1.LocalReport.DataSources.Clear();
            ReportViewer1.LocalReport.DataSources.Add(datasource);
        }

    }
}

6.Build And Run

Collectives™ on Stack Overflow

How to create report in asp.net using Report Viewer

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related