在FlashViewer下图表的导出
回复 4楼frank.zhang的帖子在FlashViewer下,对于在后台绑定数据源的图表,要如何导出,数据如何传递?如果有范例的话最好 您好,
这个问题明天继续调查。 回复 2楼frank.zhang的帖子
请问我上面的问题该如何解决 您好,
后台绑定数据源的图表和普通的报表的导出方式是一致的。
以导出excel为例:
// Provide the page report you want to render.
string report = "RdlReport2";
GrapeCity.ActiveReports.PageReport _reportDef = new GrapeCity.ActiveReports.PageReport(new System.IO.FileInfo(Server.MapPath("/Reports/" + report + ".rdlx")));
_reportDef.Report.DataSources.DataSourceReference = "";
_reportDef.Report.DataSources.ConnectionProperties.DataProvider = "OLEDB";
_reportDef.Report.DataSources.ConnectionProperties.ConnectString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};", Server.MapPath("/Data/NWind_CHS.mdb"));
GrapeCity.ActiveReports.Document.PageDocument _reportRuntime = new GrapeCity.ActiveReports.Document.PageDocument(_reportDef);
// Create an output directory
System.IO.MemoryStream ms = new System.IO.MemoryStream();
// Provide settings for your rendering output.
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;
//Set the rendering extension and render the report.
GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension
excelRenderingExtension = new
GrapeCity.ActiveReports.Export.Excel.Page.ExcelRenderingExtension();
GrapeCity.ActiveReports.Rendering.IO.MemoryStreamProvider outputProvider = new GrapeCity.ActiveReports.Rendering.IO.MemoryStreamProvider();
_reportRuntime.Render(excelRenderingExtension, outputProvider, excelSetting.GetSettings());
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "inline;filename=MyExport.xls");
outputProvider.GetPrimaryStream().OpenStream().CopyTo(ms);
Response.BinaryWrite(ms.ToArray());
Response.End(); 回复 4楼frank.zhang的帖子
请问如果我是SQL Server该怎么做 您好,
SQL Server是网络连接,在报表设计时绑定数据源就可以了。
回复 6楼frank.zhang的帖子
可是这样不符合要求,我在后台访问SQL Server数据库,并与报表绑定显示,在导出时该怎么传递数据呢? 您好,
我想跟您确认下,在导出时传递数据,是传递什么数据?是参数吗? 回复 8楼frank.zhang的帖子
我在导出时不是需要对报表绑定数据源吗,那在我后台访问SQL Server的前提下,我要如何绑定呢 您好,
您是否方便留一个电话,可以短消息给我。我想跟您在电话中沟通下这个问题。