Click here to Skip to main content
15,894,540 members
Articles / Web Development / ASP.NET

An Open Source RDL Engine

Rate me:
Please Sign up or sign in to vote.
4.77/5 (12 votes)
20 Dec 2010CPOL3 min read 83.8K   3.5K   55  
An Open Source RDL engine for rendering reports to WinForms or ASP.NET
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Security.Permissions;

namespace RdlAspTest
{
    public partial class _Default : System.Web.UI.Page
    {
        private string reportPath = "/SampleReports";

        protected void Page_Load(object sender, EventArgs e)
        {
            if (ConfigurationManager.AppSettings["ReportPath"] != null)
                reportPath = ConfigurationManager.AppSettings["ReportPath"];

            if (reportPath.Contains("/"))
                reportPath = Server.MapPath(reportPath);
        }

        protected void CompanySales_Click(object sender, EventArgs e)
        {
            Rdl.Engine.Report rpt = new Rdl.Engine.Report();
            rpt.Load(new FileStream(@"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports\Company Sales.rdl", FileMode.Open, FileAccess.Read, FileShare.Read),
                @"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports");

            rpt.Run();
            ReportParameters.SetReport(null);
            ReportViewer.SetReport(rpt);
        }

        protected void EmployeeSalesSummary_Click(object sender, EventArgs e)
        {
            Rdl.Engine.Report rpt = new Rdl.Engine.Report();
            rpt.Load(new FileStream(@"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports\Employee Sales Summary.rdl", FileMode.Open, FileAccess.Read, FileShare.Read),
                @"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports");

            ReportParameters.SetReport(rpt);
        }

        protected void EmployeeSales_Click(object sender, EventArgs e)
        {
            Rdl.Engine.Report rpt = new Rdl.Engine.Report();
            rpt.Load(new FileStream(@"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports\Employee Sales.rdl", FileMode.Open, FileAccess.Read, FileShare.Read),
                @"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports");

            rpt.Run();
            ReportParameters.SetReport(null);
            ReportViewer.SetReport(rpt);
        }

        protected void ProductCatalog_Click(object sender, EventArgs e)
        {
            Rdl.Engine.Report rpt = new Rdl.Engine.Report();
            rpt.Load(new FileStream(@"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports\Product Catalog.rdl", FileMode.Open, FileAccess.Read, FileShare.Read),
                @"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports");

            rpt.Run();
            ReportParameters.SetReport(null);
            ReportViewer.SetReport(rpt);
        }

        protected void ProductLineSales_Click(object sender, EventArgs e)
        {
            Rdl.Runtime.Product_Line_Sales pls = new Rdl.Runtime.Product_Line_Sales();
            Rdl.Engine.Report rpt = pls.Report;
            //Rdl.Engine.Report rpt = new Rdl.Engine.Report();
            //rpt.Load(new FileStream(@"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports\Product Line Sales.rdl", FileMode.Open, FileAccess.Read, FileShare.Read),
            //    @"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports");

            ReportParameters.SetReport(rpt);
        }

        protected void ProductsOrdered_Click(object sender, EventArgs e)
        {
            Rdl.Engine.Report rpt = new Rdl.Engine.Report();
            rpt.Load(new FileStream(@"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports\ProductsOrdered.rdl", FileMode.Open, FileAccess.Read, FileShare.Read),
                @"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports");

            rpt.Run();
            ReportParameters.SetReport(null);
            ReportViewer.SetReport(rpt);
        }

        protected void SalesOrderDetail_Click(object sender, EventArgs e)
        {
            Rdl.Engine.Report rpt = new Rdl.Engine.Report();
            rpt.Load(new FileStream(@"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports\Sales Order Detail.rdl", FileMode.Open, FileAccess.Read, FileShare.Read),
                @"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports");

            ReportParameters.SetReport(rpt);
        }

        protected void TerritorySalesDrilldown_Click(object sender, EventArgs e)
        {
            Rdl.Engine.Report rpt = new Rdl.Engine.Report();
            rpt.Load(new FileStream(@"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports\Territory Sales Drilldown.rdl", FileMode.Open, FileAccess.Read, FileShare.Read),
                @"C:\Documents and Settings\MEmerson.VITALBASICS\My Documents\Visual Studio Projects\rdlTest\SampleReports");

            rpt.Run();
            ReportParameters.SetReport(null);
            ReportViewer.SetReport(rpt);
        }


        protected void ReportParameters_ViewReport(object sender, RdlAsp.ViewReportEventArgs e)
        {
            Rdl.Engine.Report rpt = e.Report;
            rpt.Run();
            ReportViewer.SetReport(rpt);
        }
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior) Sawiki Software
United States United States
I have been a professional software developer for 25+ years, most of it supporting the business community of Maine. I have been working with MS dotnet since 1.0 beta. I organized Sawiki Software LLC as an outlet for some open source software that I have been working on.

Comments and Discussions