コード例 #1
0
        //Method for Rendering Customer Report
        public ActionResult CustomerReport(string id)
        {
            //Specify Path/ Report Name
            LocalReport lr   = new LocalReport();
            string      path = Path.Combine(Server.MapPath("~/Reports"), "CustomerInfo.rdlc");

            if (System.IO.File.Exists(path))
            {
                lr.ReportPath = path;
            }
            else
            {
                return(View("Index"));
            }
            //Make object
            List <Address>  ad   = new List <Address>();
            List <Customer> cust = new List <Customer>();
            List <Order>    ord  = new List <Order>();

            //Get data from DB
            using (JunkoutDBModelContainer jo = new JunkoutDBModelContainer())
            {
                ad   = jo.Addresses.ToList();
                cust = jo.Customers.ToList();
                ord  = jo.Orders.ToList();
            }

            //Data source from Report
            ReportDataSource rd = new ReportDataSource("CustomerInfo", cust);

            lr.DataSources.Add(rd);
            string reportType = id;
            string mimeType;
            string encoding;
            string fileNameExtension;

            //Set Report
            string deviceInfo =

                "<DeviceInfo>" +
                "  <OutputFormat>" + id + "</OutputFormat>" +
                "  <PageWidth>8.5in</PageWidth>" +
                "  <PageHeight>11in</PageHeight>" +
                "  <MarginTop>0.5in</MarginTop>" +
                "  <MarginLeft>1in</MarginLeft>" +
                "  <MarginRight>1in</MarginRight>" +
                "  <MarginBottom>0.5in</MarginBottom>" +
                "</DeviceInfo>";

            //Rendering Report
            Warning[] warnings;
            string[]  streams;
            byte[]    renderedBytes;

            renderedBytes = lr.Render(
                reportType,
                deviceInfo,
                out mimeType,
                out encoding,
                out fileNameExtension,
                out streams,
                out warnings
                );
            return(File(renderedBytes, mimeType));
        }
コード例 #2
0
        //Method for Rendering Customer Report
        public ActionResult OrdersInCities(string id)
        {
            //set path
            LocalReport lr   = new LocalReport();
            string      path = Path.Combine(Server.MapPath("~/Reports"), "OrdersInCities.rdlc");

            if (System.IO.File.Exists(path))
            {
                lr.ReportPath = path;
            }
            else
            {
                return(View("Index"));
            }
            //create object
            List <Address>         ad   = new List <Address>();
            List <Customer>        cust = new List <Customer>();
            List <Order>           ord  = new List <Order>();
            List <Bin>             bins = new List <Bin>();
            List <TransferStation> tf   = new List <TransferStation>();

            //Use db
            using (JunkoutDBModelContainer jo = new JunkoutDBModelContainer())
            {
                ad   = jo.Addresses.ToList();
                cust = jo.Customers.ToList();
                ord  = jo.Orders.ToList();
                bins = jo.Bins.ToList();
                tf   = jo.TransferStations.ToList();
            }

            // data sourec
            ReportDataSource rd = new ReportDataSource("OrdersInCities", ad);

            lr.DataSources.Add(rd);
            string reportType = id;
            string mimeType;
            string encoding;
            string fileNameExtension;

            //Report Specifications
            string deviceInfo =

                "<DeviceInfo>" +
                "  <OutputFormat>" + id + "</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;

            //Render Report
            renderedBytes = lr.Render(
                reportType,
                deviceInfo,
                out mimeType,
                out encoding,
                out fileNameExtension,
                out streams,
                out warnings
                );
            return(File(renderedBytes, mimeType));
        }