动态水晶报表

crReportDocument.SetDataSource(Ds);

ExportOptions crExportOptions; //导出选项

DiskFileDestinationOptions crDiskFileDestinationOptions;

String Fname;    //导出完整名称
//String FileName = "";
String FileName = "my.pdf";

String _SystemPath =Request.PhysicalApplicationPath;
if(!System.IO.Directory.Exists(_SystemPath))
System.IO.Directory.CreateDirectory(_SystemPath);

Fname = _SystemPath + FileName; //导出完整名称
crDiskFileDestinationOptions = new DiskFileDestinationOptions();
crDiskFileDestinationOptions.DiskFileName = Fname; crExportOptions = crReportDocument.ExportOptions;

crExportOptions.DestinationOptions = crDiskFileDestinationOptions;
crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;

crReportDocument.Export();//////////////////////////////
//========================================================================================
// 打印和导出水晶报表
//========================================================================================
/// <summary>
/// 打印一份crystal Report
/// </summary>

/// <param name="reportPath">报表路径</param>
/// <param name="reportSet">报表数据源的DataSet</param>
public void printReport(string reportPath,string PrinterPath,string passWrd)
{
ReportDocument  crystalReportObject=new ReportDocument();
// crystalReportObject.
crystalReportObject.Load(reportPath);//"e://temp//crt.rpt"
// crystalReportObject.s
//crystalReportObject.SetDataSource(reportSet);
crystalReportObject.Refresh();
this.SetConnectionInfo(crystalReportObject,passWrd);
//crystalReportObject.PrintOptions.PrinterName =@"\\office1\HP1000";
crystalReportObject.PrintOptions.PrinterName =PrinterPath ;
try
{
crystalReportObject.PrintToPrinter(1,false, 0, 0);
}
catch
{
;
}
finally
{
crystalReportObject.Close();
}
// CrystalDecisions.Web.CrystalReportViewer myView=new CrystalDecisions.Web.CrystalReportViewer();
// myView.LogOnInfo
}
public void printReport(string PrinterPath,ReportDocument crystalReportObject)
{ crystalReportObject.PrintOptions.PrinterName =PrinterPath ;
try
{
crystalReportObject.PrintToPrinter(1,false, 0, 0);
}
catch
{
;
}
finally
{
crystalReportObject.Close();
}
// CrystalDecisions.Web.CrystalReportViewer myView=new CrystalDecisions.Web.CrystalReportViewer();
// myView.LogOnInfo
} // public ReportDocument InitReportDoc(DataSet myDs,string reportPath,string passWrd)
// {
// ReportDocument oRD = new ReportDocument();
// oRD.Load(reportPath);
// oRD.SetDataSource(myDs);
// oRD.Refresh();
// this.SetConnectionInfo(oRD,passWrd);
// return oRD;
//
// } public void ExportCrystalReport(string targetFileName,string reportPath,string docFormat,string passWrd)
{
ReportDocument oRD = new ReportDocument();
ExportOptions  oExO  ;
DiskFileDestinationOptions oExDo=new DiskFileDestinationOptions();
oRD.Load(reportPath);
//oRD.SetDataSource(myDS);
oRD.Refresh();
this.SetConnectionInfo(oRD,passWrd); oExDo.DiskFileName = targetFileName ;
oExO = oRD.ExportOptions;
oExO.ExportDestinationType = ExportDestinationType.DiskFile;
switch (docFormat)
{
case "pdf":
oExO.ExportFormatType = ExportFormatType.PortableDocFormat;
break;
case "doc":
oExO.ExportFormatType = ExportFormatType.WordForWindows;
break;
case "xls":
oExO.ExportFormatType = ExportFormatType.Excel;
break;
case "htm":
oExO.ExportFormatType = ExportFormatType.HTML40;
break;
case "html":
oExO.ExportFormatType = ExportFormatType.HTML40;
break;
default:oExO.ExportFormatType = ExportFormatType.Excel;break;
}
oExO.DestinationOptions = oExDo;

oRD.Export();
oRD.Close();
}
public void ExportCrystalReport(ReportDocument oRD,string docFormat,string targetFileName)
{
//ReportDocument oRD = new ReportDocument();
ExportOptions  oExO  ;
DiskFileDestinationOptions oExDo=new DiskFileDestinationOptions();
// oRD.Load(reportPath);
// oRD.SetDataSource(myDS);
//oRD.Refresh();
//this.SetConnectionInfo(oRD,passWrd); oExDo.DiskFileName = targetFileName ;
oExO = oRD.ExportOptions;
oExO.ExportDestinationType = ExportDestinationType.DiskFile;
switch (docFormat)
{
case "pdf":
oExO.ExportFormatType = ExportFormatType.PortableDocFormat;
break;
case "doc":
oExO.ExportFormatType = ExportFormatType.WordForWindows;
break;
case "xls":
oExO.ExportFormatType = ExportFormatType.Excel;
break;
case "htm":
oExO.ExportFormatType = ExportFormatType.HTML40;
break;
case "html":
oExO.ExportFormatType = ExportFormatType.HTML40;
break;
default:oExO.ExportFormatType = ExportFormatType.Excel;break;
}
oExO.DestinationOptions = oExDo;

oRD.Export();
oRD.Close();
}