没有什么特殊的设置.
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();
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();
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();