how to calculate total invoice amount in footer rdlc report in mvc

Question

Anonymous User · Answer

here we are going to demonstrate how to calculate amount in footer . Follow the below steps.

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.Where(m => m.Id < 5).ToList());
            ds.Tables.Add(dt);
            reportDataSource.Value = ds.Tables[0];
            localReport.DataSources.Add(reportDataSource);

            ReportParameter[] parameters = new ReportParameter[3];
            parameters[0] = new ReportParameter("Name", "Anupam Sing");
            parameters[1] = new ReportParameter("Number", "7798930674");
            parameters[2] = new ReportParameter("Date", DateTime.Now.ToString());
            localReport.SetParameters(parameters);
            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.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="Print Invoice"
         class="btn btn-info PrintPDF" style="margin-right: 10px;" />
</body>
</html>

Report Design

in this design we are adding custom line and total invoice bill amount calculate in footer section.
an separated by all section line.

Result Report

.

forum

how to calculate total invoice amount in footer rdlc report in mvc

Anonymous User

Can you answer this question?

1 Answers

Liked By