Here's my dilemma: We're upgrading our web app from .NET 1 to .NET 4 and everything is going great. We have 56 reports that we use to output pdf's for correspondence letters, invoices, etc. Everything was working properly when we were running in .NET 1 using VS 2003 and CR 9.
Now we are running CR 13 for VS 2010 and .NET 4 and I have all of these working in the new environment with the new .NET version, except for a handful, all of which rely on a sql view as a report datasource. Possible issue?
The reports load, there are no errors, but the data is missing. Hopefully someone can help.
DataTable dt = new DataTable();
dt = (DataTable)Session["ReportsTable"];
ReportDocument oRpt = new ReportDocument();
string strReport = FSL.FSLReportManager.Reports.GetReportAppSetting(ddm) + objReport.FileName;
dt.TableName = oRpt.Database.Tables.Name;
private void ExportPDF(Page pg, ReportDocument rClass, DataTable dt)
ExportOptions exp = new ExportOptions();
exp.ExportFormatType = ExportFormatType.PortableDocFormat;
exp.FormatOptions = new PdfRtfWordFormatOptions();
ExportRequestContext req = new ExportRequestContext();
req.ExportInfo = exp;
st = rClass.FormatEngine.ExportToStream(req);
pg.Response.ContentType = "application/pdf";
byte b = new byte[st.Length];
st.Read(b, 0, (int)st.Length);
I can verify that the report loads data in the report preview.
I can verify that the datatable contains all of the data.
What am I missing?