Example #1
0
        // GET: Reports
        public ActionResult Reports()
        {
            string path = Server.MapPath("ReadMe/userconfig.txt");
            string[] filetext = System.IO.File.ReadAllLines(path);
                                  //username    password    reportservice   reportexecution
            Cred mycred = new Cred(filetext[0], filetext[1], filetext[2], filetext[3]);
            ReportingService2005 rr = new ReportingService2005();
            string username = mycred.userName;
            string pass = mycred.passWord;
            rr.Credentials = new System.Net.NetworkCredential(username, pass);
            rr.Credentials = System.Net.CredentialCache.DefaultCredentials;
            rr.Url = mycred.ReportService;

            CatalogItem[] items = null;

            try
            {
                items = rr.ListChildren("/PWE_Reports", true);
            }
            catch (SoapException e)
            {
                throw e;
            }

            var reports = new List<Report>();

            foreach (CatalogItem value in items)
            {
                reports.Add(new Report() { ReportName = value.Name, ReportDescription = value.Description });
            }

            ReportExecutionService rs = new ReportExecutionService();

            foreach (var report in reports)
            {
                string reportName = "/PWE_Reports/" + report.ReportName;
                bool forRender = true;
                string historyID = null;
                ReportWebReference.ParameterValue[] values = null;
                ReportWebReference.DataSourceCredentials[] credentials = null;
                ReportWebReference.ReportParameter[] parameters = null;

                try
                {
                    parameters = rr.GetReportParameters(reportName, historyID, forRender, values, credentials);

                    if (parameters != null)
                    {
                        foreach (ReportWebReference.ReportParameter rp in parameters)
                        {
                            report.ReportParameters.Add(new Parameter() { ParameterName = rp.Name, Prompt = rp.Prompt });

                            if (rp.ValidValues != null)
                            {
                                foreach (var validValue in rp.ValidValues)
                                {
                                    report.DataParameters.Add(new Parameter() { Value = validValue.Value });
                                }
                            }
                        }

                    }
                }
                catch (SoapException e)
                {
                    throw e;
                }
            }

            return View(reports);
        }
Example #2
0
        public ActionResult DownloadReport(string reportname, string pricegroupid, string productid)
        {
            string path = Server.MapPath("../ReadMe/userconfig.txt");
            string[] filetext = System.IO.File.ReadAllLines(path);
            //username    password    reportservice   reportexecution
            Cred mycred = new Cred(filetext[0], filetext[1], filetext[2], filetext[3]);
            ReportExecutionService rs = new ReportExecutionService();
            string username = mycred.userName;
            string pass = mycred.passWord;
            rs.Credentials = new System.Net.NetworkCredential(username, pass);
            //rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
            rs.Url = mycred.ReportExec;

            string encoding = null;
            string mimeType = null;
            string[] streamIDs = null;
            string devInfo = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";

            string reportPath = null;
            reportPath = "/PWE_Reports/" + reportname;
            string historyID = null;
            byte[] result = null;
            string format = "EXCEL";
            string extension = null;

            ReportWebService.Warning[] warnings = null;
            ExecutionInfo execInfo = new ExecutionInfo();
            ExecutionHeader execHeader = new ExecutionHeader();

            Response.AddHeader("Content-Disposition", "inline; filename=" + reportname + ".xls");
            rs.ExecutionHeaderValue = execHeader;

            ReportWebService.ParameterValue priceGroupID = new ReportWebService.ParameterValue();
            execInfo = rs.LoadReport(reportPath, historyID);

            ReportWebService.ParameterValue[] parameters = new ReportWebService.ParameterValue[1] { priceGroupID };
            if (pricegroupid != null) //report has a pricegroupid parameter
            {
                priceGroupID.Name = "PriceGroupID";
                priceGroupID.Value = pricegroupid;
                rs.SetExecutionParameters(parameters, "en-us");
            }
            if (productid != null) //report has a pricegroupid parameter
            {
                priceGroupID.Name = "ProductID";
                priceGroupID.Value = productid;
                rs.SetExecutionParameters(parameters, "en-us");
            }

            try
            {
                result = rs.Render(format, devInfo, out extension, out mimeType, out encoding, out warnings, out streamIDs);

                execInfo = rs.GetExecutionInfo();
            }
            catch (SoapException e)
            {
                throw e;
            }

            return File(result, "application/vnd.ms-excel");

            /*
                       ViewBag.ReportName = reportname;
                       ViewBag.ReportParam = pricegroupid;
                       return View();
                       */
        }