forum

home / developersection / forums / how to create rdlc report in mvc

Ask Question

how to create rdlc report in mvc

Anonymous User 2707 15-Feb-2016
we want to  create rdlc report in mvc how will  do this  please help me.
reporting c#  reporting  mvc 
Updated on 15-Feb-2016
Anonymous User

Anonymous User

Follow

I am a content writter !

Can you answer this question?
Answer

1 Answers

Anonymous User

Anonymous User

15-Feb-2016 
Controller

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data.Entity;
using System.Data;
using Microsoft.Reporting.WebForms;
using System.IO;
using ForumMVC;
using ForumMVC.Models;
using System.ComponentModel;
namespace ForumMVC.Controllers
{
    public class HomeController : Controller
    {
        forumEntities1 db = new forumEntities1();
        public ActionResult Index()
        {

            return View();
        }

        public ActionResult PrintPDF()
        {
            LocalReport localReport = new LocalReport();
            localReport.ReportPath = Server.MapPath("~/Graph.rdlc");
            ReportDataSource reportDataSource = new ReportDataSource();
            reportDataSource.Name = "DataSet1";
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();

            var Result = from c in db.CUSTOMER
                         join o in db.ORDER on c.CUST_ID equals o.CUST_ID
                         join p in db.PRODUCT on o.PRODUCT_ID equals p.PRODUCT_ID
                         select new
                         {
                             Id = c.CUST_ID,
                             Name = c.CUST_NAME,
                             Date = o.ORD_DATE,
                             Product = p.PRODUCT_NAME,
                             Price = p.PRICE
                         };
            dt = ConvertToDataTable(Result.ToList());
            ds.Tables.Add(dt);
            reportDataSource.Value = ds.Tables[0];
            localReport.DataSources.Add(reportDataSource);
            string reportType = "PDF";
            string mimeType;
            string encoding;
            string fileNameExtension;

            string deviceInfo =
            "<DeviceInfo>" +
            "  <OutputFormat>PDF</OutputFormat>" +
            "  <PageWidth>8.5in</PageWidth>" +
            "  <PageHeight>11in</PageHeight>" +
            "  <MarginTop>0.5in</MarginTop>" +
            "  <MarginLeft>1in</MarginLeft>" +
            "  <MarginRight>1in</MarginRight>" +
            "  <MarginBottom>0.5in</MarginBottom>" +
            "</DeviceInfo>";
            Warning[] warnings;
            string[] streams;
            byte[] renderedBytes;
            renderedBytes = localReport.Render(
                reportType,
                deviceInfo,
                out mimeType,
                out encoding,
                out fileNameExtension,
                out streams,
                out warnings);
            //Response.AddHeader("content-disposition", "attachment; filename=Data." + fileNameExtension);          
            Response.ContentType = "application/pdf";
            Response.AddHeader("Content-length", renderedBytes.Length.ToString());
            Response.AddHeader("content-disposition", "inline;filename=Data." + fileNameExtension);
            Response.BinaryWrite(renderedBytes);
            return null;
        }

        public DataTable ConvertToDataTable<T>(IList<T> data)
        {
            PropertyDescriptorCollection properties =
               TypeDescriptor.GetProperties(typeof(T));
            DataTable table = new DataTable();
            foreach (PropertyDescriptor prop in properties)
                table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);
            foreach (T item in data)
            {
                DataRow row = table.NewRow();
                foreach (PropertyDescriptor prop in properties)
                    row[prop.Name] = prop.GetValue(item) ?? DBNull.Value;
                table.Rows.Add(row);
            }
            return table;

        }


    }
}

index view 
<!DOCTYPE html>
<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
    <script src="~/Scripts/jquery-1.9.1.min.js"></script>
    <script>
        $(document).on('click', '.PrintPDF', function (e) {
            var win = window.open('../Home/PrintPDF/', '_blank');
            console.log('click');
            if (win) {
                win.focus();
            } else {
                alert('Please allow popups for this site');
            }
        });
    </script>
</head>
<body>
    <input id="btnreportmvc" type="button" value="Generate report" 
class="btn btn-info PrintPDF" style="margin-right: 10px;" />
</body>
</html>

Report Design
how to create rdlc report in mvc
Report 
how to create rdlc report in mvc

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy