水晶报表在预览时改变缩放就显示“没有有效的报表源”
代码如下
string sql = "SELECT T_ID ID ,T_Name Num ,[T_Register_Date] ,'" + startTime + "' as T_StartTime ,'" + endTime + "' as T_EndTime ,(case '" + T_Status + "' when '-1' then '全部' "
+ " when '0' then '预检状态' when '1' then '留抢状态' when '2' then '离抢状态' when '3' then '入院评估' when '4' then '创伤评估' end) as T_Status "
+ "FROM [ZREmergency].[dbo].[ZrPerson] " + (whereStr != null ? " where " + whereStr : "");
string DBConfig_sql = ConfigurationManager.ConnectionStrings["Services"].ToString(); //@"server=192.168.1.5\sql2008;database=ZREmergency;uid=sa;pwd=1;";
DataSet ds = new DataSet();
SqlConnection sqlCon = new SqlConnection(DBConfig_sql);
SqlCommand sqlCmd = new SqlCommand(sql, sqlCon);
SqlDataAdapter sqlAd = new SqlDataAdapter();
sqlAd.SelectCommand = sqlCmd;
sqlAd.Fill(ds, "sql");
string sss = Request.ApplicationPath;
string s = Server.MapPath("PatientDateCountReprt.rpt");
CrystalReportSource1.Report.FileName = "PatientDateCountReprt.rpt";
CrystalReportSource1.ReportDocument.Load(Server.MapPath("PatientDateCountReprt.rpt"));
//注意此处必需指明Dataset中的表的名称,否则会提示“您请求的报表需要更多信息.”
DataTable dt = ds.Tables["sql"];
CrystalReportSource1.ReportDocument.SetDataSource(dt);
//{?}中的参数可以不用赋值,即使赋了值也不起作用。
CrystalReportSource1.DataBind();
CrystalReportViewer1.BestFitPage = true;
CrystalReportViewer1.Zoom(125);
CrystalReportViewer1.ReportSource = CrystalReportSource1;
CrystalReportViewer1.DataBind();
问题如题 希望大神指教
代码如下
string sql = "SELECT T_ID ID ,T_Name Num ,[T_Register_Date] ,'" + startTime + "' as T_StartTime ,'" + endTime + "' as T_EndTime ,(case '" + T_Status + "' when '-1' then '全部' "
+ " when '0' then '预检状态' when '1' then '留抢状态' when '2' then '离抢状态' when '3' then '入院评估' when '4' then '创伤评估' end) as T_Status "
+ "FROM [ZREmergency].[dbo].[ZrPerson] " + (whereStr != null ? " where " + whereStr : "");
string DBConfig_sql = ConfigurationManager.ConnectionStrings["Services"].ToString(); //@"server=192.168.1.5\sql2008;database=ZREmergency;uid=sa;pwd=1;";
DataSet ds = new DataSet();
SqlConnection sqlCon = new SqlConnection(DBConfig_sql);
SqlCommand sqlCmd = new SqlCommand(sql, sqlCon);
SqlDataAdapter sqlAd = new SqlDataAdapter();
sqlAd.SelectCommand = sqlCmd;
sqlAd.Fill(ds, "sql");
string sss = Request.ApplicationPath;
string s = Server.MapPath("PatientDateCountReprt.rpt");
CrystalReportSource1.Report.FileName = "PatientDateCountReprt.rpt";
CrystalReportSource1.ReportDocument.Load(Server.MapPath("PatientDateCountReprt.rpt"));
//注意此处必需指明Dataset中的表的名称,否则会提示“您请求的报表需要更多信息.”
DataTable dt = ds.Tables["sql"];
CrystalReportSource1.ReportDocument.SetDataSource(dt);
//{?}中的参数可以不用赋值,即使赋了值也不起作用。
CrystalReportSource1.DataBind();
CrystalReportViewer1.BestFitPage = true;
CrystalReportViewer1.Zoom(125);
CrystalReportViewer1.ReportSource = CrystalReportSource1;
CrystalReportViewer1.DataBind();
问题如题 希望大神指教
改成
string s = Server.MapPath("~\\PatientDateCountReprt.rpt");