运行时绑定数据的rdl报表导出pdf时出现错误

收藏

下列导出pdf的代码运行到红色语句报错：无法连接数据源。

现已确认：1.Document_LocateDataSource没有问题（在同一页面下webviewer显示该报表正常）
               2.内部已绑定数据的rdlx报表导出pdf正常。

请问如何解决？

protected void ButtonExportPDF_Click(object sender, EventArgs e)
{
      GrapeCity.ActiveReports.PageReport _reportDef = new GrapeCity.ActiveReports.PageReport(new System.IO.FileInfo(Server.MapPath(@"/Reports/RdlReport_SBTZ.rdlx")));
      _reportDef.Document.LocateDataSource += new GrapeCity.ActiveReports.LocateDataSourceEventHandler(Document_LocateDataSource);
      GrapeCity.ActiveReports.Document.PageDocument _reportRuntime = new GrapeCity.ActiveReports.Document.PageDocument(_reportDef);
      GrapeCity.ActiveReports.Export.Pdf.Page.PdfRenderingExtension _renderingExtension = new GrapeCity.ActiveReports.Export.Pdf.Page.PdfRenderingExtension();
      GrapeCity.ActiveReports.Rendering.IO.MemoryStreamProvider _provider = new GrapeCity.ActiveReports.Rendering.IO.MemoryStreamProvider();
   _reportRuntime.Render(_renderingExtension, _provider);
      Response.ContentType = "application/pdf";
      Response.AddHeader("content-disposition", Server.UrlPathEncode("attachment;filename=客户订单.pdf"));
      System.IO.MemoryStream ms = new System.IO.MemoryStream();
      _provider.GetPrimaryStream().OpenStream().CopyTo(ms);
      Response.BinaryWrite(ms.ToArray());
      Response.End();
}

KearneyKang · KearneyKang

您好这是导出PDF的后台代码，您参考下

// Provide the page report you want to render.
System.IO.FileInfo rptPath = new System.IO.FileInfo(@"..\..\PageReport1.rdlx");
GrapeCity.ActiveReports.PageReport pageReport = new GrapeCity.ActiveReports.PageReport(rptPath);
// Create an output directory.
System.IO.DirectoryInfo outputDirectory = new System.IO.DirectoryInfo(@"C:\MyPDF");
outputDirectory.Create();
// Provide settings for your rendering output.
GrapeCity.ActiveReports.Export.Pdf.Page.Settings pdfSetting = new GrapeCity.ActiveReports.Export.Pdf.Page.Settings();
// Reduce the report size and report generation time.
pdfSetting.OptimizeStatic = true;
// Set the rendering extension and render the report.
GrapeCity.ActiveReports.Export.Pdf.Page.PdfRenderingExtension pdfRenderingExtension = new GrapeCity.ActiveReports.Export.Pdf.Page.PdfRenderingExtension();
GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider outputProvider = new GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider(outputDirectory, System.IO.Path.GetFileNameWithoutExtension(outputDirectory.Name));
// Overwrite output file if it already exists
outputProvider.OverwriteOutputFile = true;
pageReport.Document.Render(pdfRenderingExtension, outputProvider, pdfSetting);

复制代码

yxx7347 · yxx7347

您给的这段代码好像也没有涉及绑定外部数据源的语句。
我现在需要导出并下载PDF的报表是一个rdl报表，该报表用下列代码实现了数据绑定和在webviewer显示。其中Document_LocateDataSource()实现了绑定外部dataset。

private void BuildReport()
{

               GrapeCity.ActiveReports.PageReport rptSBTZ = new GrapeCity.ActiveReports.PageReport(new System.IO.FileInfo(Server.MapPath(@"/Reports/RdlReport_SBTZ.rdlx")));
            rptSBTZ.Document.LocateDataSource += new GrapeCity.ActiveReports.LocateDataSourceEventHandler(Document_LocateDataSource);
            WebViewer1.Report = rptSBTZ;

}

private void Document_LocateDataSource(object sender,GrapeCity.ActiveReports.LocateDataSourceEventArgs Args)
{
      if (Args.DataSourceName == "DataSource1")
      {
         if (Args.DataSetName == "DataSet1")
         {
            Args.Data = GetData();
         }
      }
}

private object GetData()
{
      string ReportSQL = ViewState["ReportSQL"].ToString();
      string ReportBy = CheckAccess_Login1.UserName;
      string ReportDate = string.Format("{0:yyyy-MM-dd}", DateTime.Now);
      DataSet ds = BLL.SQLDBTools.GetDataBySQL(ReportSQL);
      return ds.Tables[0];
}

但在导出pdf时好像并没有进行数据绑定。

除了下载PDF,我还要下载excel和Word文档。AR11有关于这部分操作的详细文档吗？

1楼代码参考的是：http://blog.gcpowertools.com.cn/post/ActiveReports-Export.aspx
本楼上述代码参考的视频教程。

KearneyKang · KearneyKang

本帖最后由 KearneyKang 于 2017-12-13 17:07 编辑

您好，数据源的绑定跟您其它动态数据源绑定一样。如下是导出Excel并且绑定动态数据源的代码

private void tsbExcel_Click(object sender, EventArgs e)
{
string file_name = @"..\..\RdlReport1.rdlx";
//GrapeCity.ActiveReports.PageReport report = new GrapeCity.ActiveReports.PageReport(new System.IO.FileInfo(@"123.rdlx"));
//GrapeCity.ActiveReports.Document.PageDocument reportDocument = new GrapeCity.ActiveReports.Document.PageDocument(report);
GrapeCity.ActiveReports.PageReport pageReport = new GrapeCity.ActiveReports.PageReport(new System.IO.FileInfo(file_name));
pageReport.Document.LocateDataSource += new LocateDataSourceEventHandler(LocateData);
this._document = pageReport.Document;
System.IO.DirectoryInfo outputDirectory = new System.IO.DirectoryInfo(@"D:\MyExcel");
outputDirectory.Create();
GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings excelSetting = new GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtensionSettings();
excelSetting.FileFormat = GrapeCity.ActiveReports.Export.Excel.Page.FileFormat.Xls;
excelSetting.MultiSheet = false;
GrapeCity.ActiveReports.Extensibility.Rendering.ISettings setting = excelSetting;
GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension excelRenderingExtension = new GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension();
GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider outputProvider = new GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider(outputDirectory, System.IO.Path.GetFileNameWithoutExtension(outputDirectory.Name));
outputProvider.OverwriteOutputFile = false;
_document.Render(excelRenderingExtension, outputProvider, excelSetting.GetSettings());
}

复制代码

导出word的代码

// Provide the page report you want to render.
GrapeCity.ActiveReports.PageReport report = new GrapeCity.ActiveReports.PageReport();
GrapeCity.ActiveReports.Document.PageDocument reportDocument = new GrapeCity.ActiveReports.Document.PageDocument(report);
// Create an output directory.
System.IO.DirectoryInfo outputDirectory = new System.IO.DirectoryInfo(@"C:\MyWord");
outputDirectory.Create();
// Provide settings for your rendering output.
GrapeCity.ActiveReports.Export.Word.Page.Settings wordSetting = new GrapeCity.ActiveReports.Export.Word.Page.Settings();
// Set the FileFormat property to .OOXML.
wordSetting.FileFormat = GrapeCity.ActiveReports.Export.Word.Page.FileFormat.OOXML;
// Set the rendering extension and render the report.
GrapeCity.ActiveReports.Export.Word.Page.WordRenderingExtension wordRenderingExtension = new GrapeCity.ActiveReports.Export.Word.Page.WordRenderingExtension();
GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider outputProvider = new GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider(outputDirectory, System.IO.Path.GetFileNameWithoutExtension(outputDirectory.Name));
// Overwrite output file if it already exists.
outputProvider.OverwriteOutputFile = true;
reportDocument.Render(wordRenderingExtension, outputProvider, wordSetting);

复制代码

yxx7347 · yxx7347

另外，关于区域报表导出下载的示例代码有吗？

yxx7347 · yxx7347

总感觉activereports的编程文档资源较为零散，有完整的文档吗？英文的也行

KearneyKang · KearneyKang

您好！这里有一个AR的产品白皮书，这是一个英文的文档。里面有比较详细的介绍。
http://gcdn.gcpowertools.com.cn/ ... &extra=page%3D1

		自动登录	找回密码
密码			立即注册

[已处理] 运行时绑定数据的rdl报表导出pdf时出现错误

6 个回复

微信认证勋章

圣诞拼拼乐

讲师达人

悬赏达人

元老葡萄