SQL Server Performance

the source of report definition has not been specified

Discussion in 'ALL SQL SERVER QUESTIONS' started by waqar100, Oct 18, 2012.

  1. waqar100 New Member

    Code:
    ReportViewer ReportViewer1 =null; try { rptData = new DataSet(); objReportHelper = new ReportHelper(); ReportViewer1 = new ReportViewer(); ReportViewer1.Reset(); if (Session["ReporttHelperObject"] != null) { objReportHelper = (ReportHelper)Session["ReporttHelperObject"]; this.Title = objReportHelper.ReportMode.ToString().Replace("_", " "); rptData.ReadXmlSchema(Server.MapPath("Reports/DataSets/spReport_LoanSummaryBatchOther.xsd")); for (int i = 0; i < 5; i++) { rptData.Tables[0].Rows.Add(); foreach (DataColumn dCol in rptData.Tables[0].Columns) { rptData.Tables[0].Rows[dCol.ColumnName] = dCol.DefaultValue; } } //------------------------------------------------------------- ReportViewer1.ProcessingMode = ProcessingMode.Local; LocalReport rep = ReportViewer1.LocalReport; rep.Refresh(); rep.ReportPath = "Reports/BatchOtherComments.rdlc"; rptData.DataSetName = "spReport_LoanSummaryBatchOther"; objReportDataSource = new ReportDataSource("spReport_LoanSummaryBatchOther", rptData.Tables[0]); //ReportViewer1.LocalReport.ReportPath = "Reports/BatchOtherComments.rdlc"; rep.DataSources.Add(objReportDataSource); // ReportViewer1.LocalReport.ReportEmbeddedResource = "Reports/BatchOtherComments.rdlc"; // byte[] rdlbytes = System.Text.Encoding.UTF8.GetBytes("Reports/rptDeniedLoansDetails.rdlc"); //MemoryStream stream = new MemoryStream(rdlbytes); //ReportViewer1.LocalReport.LoadReportDefinition(stream); Warning[] warnings; string mimeType; string encoding; string extension; string deviceInfo; string[] streamids; deviceInfo = "<DeviceInfo>" + " <OutputFormat>PDF</OutputFormat>" + " <PageSize>A4</PageSize>" + " <PageWidth>8.5in</PageWidth>" + " <PageHeight>11in</PageHeight>" + " <MarginTop>0.25in</MarginTop>" + " <MarginLeft>0.25in</MarginLeft>" + " <MarginRight>0.25in</MarginRight>" + " <MarginBottom>0.25in</MarginBottom>" + "</DeviceInfo>"; byte[] bytes = ReportViewer1.ServerReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings); FileStream fs = new FileStream(@"C:/Users/wnaeem/Sample.PDF", FileMode.Create); fs.Write(bytes, 0, bytes.Length); fs.Close(); } } catch (Exception ex) { throw ; } finally { ReportViewer1.Dispose(); }
  2. Shehap MVP, MCTS, MCITP SQL Server

    May you elaborate more you case..?

Share This Page