如何将水晶报表中的数据全部导入到excel中呢?? 不通过viewer来另存,就是自动生成怎么弄 ? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 水晶报表预览是用DataSet绑定的,那么可以直接通过DataSet的数据写入Excel中这样也避免了水晶报表保存为Excel文件时没有线条的缺点 主要是我用到了水晶报表中的统计等功能,所以通过DataSet的数据写入Excel中,就不能把用水晶报表的统计出的数据写入excel中了,所以 你用水晶报表的时候,用到了一个DataSet,可以把数据存储在DataSet中,然后再导入excel,隐式实现 你是说用水晶报表的功能统计出的数据也是存储在DataSet中吗? 为什么我在用下面的代码时,当执行到Report.ExportOptions.ExportFormatType = ExportFormatType.RichText;时老是报“无效报表文件路径”呢??DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions(); //设置导出格式 Report.ExportOptions.ExportFormatType = ExportFormatType.RichText; Report.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; //设置磁盘文件选项 diskOpts.DiskFileName = fileName; Report.ExportOptions.DestinationOptions = diskOpts; Report.Export (); ReportDocument crReportDocument; ExportOptions crExportOptions; DiskFileDestinationOptions crDiskFileDestinationOptions; string Fname; crReportDocument = new ReportDocument(); TableLogOnInfo logOnInfo = new TableLogOnInfo(); logOnInfo.ConnectionInfo.ServerName = "blue"; logOnInfo.ConnectionInfo.DatabaseName = "Transportation"; logOnInfo.ConnectionInfo.UserID = "sa"; logOnInfo.ConnectionInfo.Password = ""; logOnInfo.TableName = "MaintenancesStatis"; CrystalReportViewer1.LogOnInfo.Add(logOnInfo);//对参数进行赋什值 crReportDocument.Load("E:\\Transportation\\WebUI\\Report\\MaintenancesStatisReport.rpt"); Fname = "D:\test.pdf"; crDiskFileDestinationOptions = new DiskFileDestinationOptions(); crDiskFileDestinationOptions.DiskFileName = Fname; crExportOptions = crReportDocument.ExportOptions; crExportOptions.DestinationOptions = crDiskFileDestinationOptions; crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; crReportDocument.Export(); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; Response.WriteFile(Fname); Response.Flush(); Response.Close(); System.IO.File.Delete(Fname);这样试试,不过你的水晶报表要记得登录啊 关于多线程问题请教! Effective C# 第二版 中文 之04 C# 2005中MenuStrip与ImageList是不是无法关联? 请教网络监听程序 cpu 主频控制 我做了一个简单的即时通信,2003系统上服务器接收不了信息,用的UDP协议 请教一下用语言怎么对Access数据进行压缩 在客户端要安装.net程序 怎么样将框架打包.. 弟兄们有空帮忙看看!从listview拖拽到datagrid如何实现? 关于水晶报表不能分页显示的问题??急!!在线等待 数据库操作insert老是莫名其妙的报错。。。。 如何在应用程序加载数据等待时显示一个欢迎窗体
这样也避免了水晶报表保存为Excel文件时没有线条的缺点
DiskFileDestinationOptions diskOpts = new
DiskFileDestinationOptions(); //设置导出格式
Report.ExportOptions.ExportFormatType =
ExportFormatType.RichText;
Report.ExportOptions.ExportDestinationType =
ExportDestinationType.DiskFile; //设置磁盘文件选项
diskOpts.DiskFileName = fileName;
Report.ExportOptions.DestinationOptions = diskOpts; Report.Export ();
ExportOptions crExportOptions;
DiskFileDestinationOptions crDiskFileDestinationOptions;
string Fname;
crReportDocument = new ReportDocument(); TableLogOnInfo logOnInfo = new TableLogOnInfo(); logOnInfo.ConnectionInfo.ServerName = "blue";
logOnInfo.ConnectionInfo.DatabaseName = "Transportation";
logOnInfo.ConnectionInfo.UserID = "sa";
logOnInfo.ConnectionInfo.Password = "";
logOnInfo.TableName = "MaintenancesStatis"; CrystalReportViewer1.LogOnInfo.Add(logOnInfo);//对参数进行赋什值 crReportDocument.Load("E:\\Transportation\\WebUI\\Report\\MaintenancesStatisReport.rpt");
Fname = "D:\test.pdf"; crDiskFileDestinationOptions = new DiskFileDestinationOptions();
crDiskFileDestinationOptions.DiskFileName = Fname;
crExportOptions = crReportDocument.ExportOptions;
crExportOptions.DestinationOptions = crDiskFileDestinationOptions;
crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
crReportDocument.Export(); Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.WriteFile(Fname);
Response.Flush();
Response.Close();
System.IO.File.Delete(Fname);这样试试,不过你的水晶报表要记得登录啊