動態水晶報表

建立動態水晶報表的官方 VB.NET 程式執行個體.exe
http://blog.csdn.net/haibodotnet/archive/2003/12/11/21546.aspx

建立不受資料庫限制的報表
http://blog.csdn.net/babyt/category/39074.aspx

也可以建立一些空的公式欄位，預先防在報表上，然後動態給公式欄位扶植。

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();
  }