没有什么特殊的设置.
string servicestr= Application["service"].ToString();
SqlConnection conn=new SqlConnection(servicestr);
if (conn.State.ToString()!="Open") conn.Open();
DataSet set1=new DataSet();
SqlDataAdapter reader=new SqlDataAdapter(strsql,conn);
reader.Fill(set1,"t_datasetreport");
//在此增加以上的代码进行连接
CrystalReport1 myreport=new CrystalReport1();
CrystalDecisions.Shared.DiskFileDestinationOptions diskopts=new CrystalDecisions.Shared.DiskFileDestinationOptions();
myreport.ExportOptions.ExportDestinationType=CrystalDecisions.Shared.ExportDestinationType.DiskFile;
myreport.ExportOptions.ExportFormatType=CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
diskopts.DiskFileName=@"c:\output.xls";
myreport.ExportOptions.DestinationOptions=diskopts;
myreport.Export();

解决方案 »

  1.   

    没有什么特殊的设置.  
    string  servicestr=  Application[  "service  "].ToString();  
    SqlConnection  conn=new  SqlConnection(servicestr);  
    if  (conn.State.ToString()!=  "Open  ")  conn.Open();  
    DataSet  set1=new  DataSet();  
    SqlDataAdapter  reader=new  SqlDataAdapter(strsql,conn);  
    reader.Fill(set1,  "t_datasetreport  ");  CrystalReport1  myreport=new  CrystalReport1();  
    CrystalDecisions.Shared.DiskFileDestinationOptions  diskopts=new  CrystalDecisions.Shared.DiskFileDestinationOptions();  
    myreport.ExportOptions.ExportDestinationType=CrystalDecisions.Shared.ExportDestinationType.DiskFile;  
    myreport.ExportOptions.ExportFormatType=CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;  
    diskopts.DiskFileName=@  "c:\output.xls  ";  
    myreport.ExportOptions.DestinationOptions=diskopts;  
    myreport.Export();