protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { ssrsReportViewer1.ProcessingMode = ProcessingMode.Remote; IReportServerCredentials irsc = new MyReportServerCredentials(); ssrsReportViewer1.ServerReport.ReportServerCredentials = irsc; ssrsReportViewer1.ProcessingMode = ProcessingMode.Remote; ssrsReportViewer1.ServerReport.ReportServerUrl = new Uri(_siteConfig.SSRSUrl); ssrsReportViewer1.ServerReport.ReportPath = "/Unplugg IT Solution BI Reporting/UIS_RPT_AllMembersReport"; ssrsReportViewer1.ServerReport.Refresh(); } catch (Exception ex) { Response.Write(ex.ToString()); } } }
public void Test() { // ReportViewer rpw = new ReportViewer(); rpw.ProcessingMode = ProcessingMode.Remote; IReportServerCredentials irsc = new MyReportServerCredentials(); rpw.ServerReport.ReportServerCredentials = irsc; rpw.ProcessingMode = ProcessingMode.Remote; rpw.ServerReport.ReportServerUrl = new Uri(_siteConfig.SSRSUrl); //rpw.ServerReport.ReportPath = "/Unplugg IT Solution BI Reporting/Unplugg IT Busy Days"; rpw.ServerReport.ReportPath = "/Unplugg IT Solution BI Reporting/" + ddlAdminReort.SelectedItem.Text; // var p_PayPeriod = new ReportParameter("parlourid", "F7CAF4C0-B3AB-44E0-8C8A-76AA4E8CDA6D"); //reportParameters.Add(new ReportParameter("parlourid", "F7CAF4C0-B3AB-44E0-8C8A-76AA4E8CDA6D")); //rpw.ServerReport.SetParameters(p_PayPeriod); // Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string filename; byte[] bytes = rpw.ServerReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); filename = string.Format("{0}.{1}", ddlAdminReort.SelectedItem.Text, "pdf"); Response.ClearHeaders(); Response.Clear(); Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); Response.ContentType = mimeType; Response.BinaryWrite(bytes); Response.Flush(); Response.End(); }
public void SSRSReport() { Warning[] warnings; string[] streamIds; string mimeType = string.Empty; string encoding = string.Empty; string extension = string.Empty; ReportViewer rpw = new ReportViewer(); rpw.ProcessingMode = ProcessingMode.Remote; IReportServerCredentials irsc = new MyReportServerCredentials(); rpw.ServerReport.ReportServerCredentials = irsc; rpw.ProcessingMode = ProcessingMode.Remote; rpw.ServerReport.ReportServerUrl = new Uri(_siteConfig.SSRSUrl); rpw.ServerReport.ReportPath = "/Unplugg IT Solution BI Reporting/Unplugg IT Active Parlours"; //ArrayList reportParam = new ArrayList(); //reportParam = ReportDefaultPatam(); //ReportParameter[] param = new ReportParameter[reportParam.Count]; //for (int k = 0; k < reportParam.Count; k++) //{ // param[k] = (ReportParameter)reportParam[k]; //} //ReportParameterCollection reportParameters = new ReportParameterCollection(); //reportParameters.Add(new ReportParameter("parlourid", "6DCBA090-F363-47E6-93F5-6DEF8F80703E")); //reportParameters.Add(new ReportParameter("parlourid", "6DCBA090-F363-47E6-93F5-6DEF8F80703E")); //reportParameters.Add(new ReportParameter("parlourid", "6DCBA090-F363-47E6-93F5-6DEF8F80703E")); //reportParameters.Add(new ReportParameter("parlourid", "6DCBA090-F363-47E6-93F5-6DEF8F80703E")); //reportParameters.Add(new ReportParameter("parlourid", "6DCBA090-F363-47E6-93F5-6DEF8F80703E")); //reportParameters.Add(new ReportParameter("parlourid", "6DCBA090-F363-47E6-93F5-6DEF8F80703E")); //reportParameters.Add(new ReportParameter("parlourid", "6DCBA090-F363-47E6-93F5-6DEF8F80703E")); //reportParameters.Add(new ReportParameter("parlourid", "6DCBA090-F363-47E6-93F5-6DEF8F80703E")); //ssrsReportViewer1.ServerReport.SetParameters(reportParameters); //rpw.ServerReport.SetParameters(param); rpw.ServerReport.Refresh(); byte[] bytes = rpw.ServerReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings); // Now that you have all the bytes representing the PDF report, buffer it and send it to the client. Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename=Monthly BI Stats.pdf"); Response.BinaryWrite(bytes); // create the file Response.Flush(); // send it to the client to download //ssrsReportViewer1.ProcessingMode = ProcessingMode.Local; //IReportServerCredentials irsc = new MyReportServerCredentials(); //ssrsReportViewer1.ServerReport.ReportServerCredentials = irsc; //ssrsReportViewer1.ProcessingMode = ProcessingMode.Remote; //ssrsReportViewer1.ServerReport.ReportServerUrl = new Uri(_siteConfig.SSRSUrl); //ssrsReportViewer1.ServerReport.ReportPath = "/Unplugg IT Solution BI Reporting/Monthly BI Stats"; //ssrsReportViewer1.ServerReport.Refresh(); }
protected void ExportClickEvent(object sender, EventArgs e) { try { // ReportViewer rpw = new ReportViewer(); rpw.ProcessingMode = ProcessingMode.Remote; IReportServerCredentials irsc = new MyReportServerCredentials(); rpw.ServerReport.ReportServerCredentials = irsc; rpw.ProcessingMode = ProcessingMode.Remote; rpw.ServerReport.ReportServerUrl = new Uri(_siteConfig.SSRSUrl); //rpw.ServerReport.ReportPath = "/Unplugg IT Solution BI Reporting/Unplugg IT Busy Days //UIS All Members Report"; rpw.ServerReport.ReportPath = "/Mosys Reports/" + hfAdminReport.Value; // ReportParameterCollection reportParameters = new ReportParameterCollection(); if (!string.IsNullOrEmpty(txtDateFrom.Text)) { reportParameters.Add(new ReportParameter("StartDateFrom", txtDateFrom.Text)); } if (!string.IsNullOrEmpty(txtDateTo.Text)) { reportParameters.Add(new ReportParameter("StartDateTo", txtDateTo.Text)); } //if (!string.IsNullOrEmpty(txtDateFrom.Text)) // reportParameters.Add(new ReportParameter("DebitDateFrom", txtDebitDateFrom.Text)); //if (!string.IsNullOrEmpty(txtDateTo.Text)) // reportParameters.Add(new ReportParameter("DebitDateTo", txtDebitDateTo.Text)); if (!string.IsNullOrEmpty(ddlAgent.SelectedItem.Text)) { reportParameters.Add(new ReportParameter("Agent", ddlAgent.SelectedItem.Text)); } if (!string.IsNullOrEmpty(ddlPolicyStatus.SelectedItem.Text)) { reportParameters.Add(new ReportParameter("PolicyStatus", ddlPolicyStatus.SelectedItem.Text)); } reportParameters.Add(new ReportParameter("Parlourid", ParlourId.ToString())); rpw.ServerReport.SetParameters(reportParameters); // Warning[] warnings; string[] streamids; string mimeType; string encoding; string extension; string filename; // string ExportTypeName = rptExportType.SelectedItem.Text; string ExportTypeExtensions; if (ExportTypeName == "PDF") { ExportTypeExtensions = "pdf"; } else if (ExportTypeName == "Word") { ExportTypeExtensions = "docx"; } else { ExportTypeExtensions = "xls"; } // byte[] bytes = rpw.ServerReport.Render(ExportTypeName, null, out mimeType, out encoding, out extension, out streamids, out warnings); filename = string.Format("{0}.{1}", hfAdminReport.Value, ExportTypeExtensions); //MailSend if (!string.IsNullOrEmpty(txtcemail.Text)) { MemoryStream s = new MemoryStream(bytes); s.Seek(0, SeekOrigin.Begin); Attachment a = new Attachment(s, filename); MailMessage message = new MailMessage(ConfigurationManager.AppSettings["ReportEmailSenderId"].ToString().Trim(), txtcemail.Text.Trim(), hfAdminReport.Value, ""); message.Attachments.Add(a); SmtpClient client = new SmtpClient(); client.Send(message); lblMessage.ForeColor = System.Drawing.Color.Green; lblMessage.Text = "Email Sent Successfully."; } // else { Response.ClearHeaders(); Response.Clear(); Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); Response.ContentType = mimeType; Response.BinaryWrite(bytes); Response.Flush(); Response.End(); } } catch (Exception ex) { ShowMessage(ref lblMessage, MessageType.Danger, ex.Message); } }