水晶报表 push模式连接 解决登陆问题 和参数传输问题

 string ct = Request.QueryString["str"];

       
        string conStr = ConfigurationManager.ConnectionStrings["ACDataConnectionString"].ConnectionString;
       
        ReportDocument oRpt = new ReportDocument();
        oRpt.Load(Server.MapPath("CrNewIn.rpt"));
        DataSet1 ds = new DataSet1();
        SqlConnection MyConn = new SqlConnection(conStr);
        MyConn.Open();
        //string strSel = "select ani.filename,ani.checktime,ani.checktype,filetypeid,pvss from anifile,"
        //+ "(select aniversion.anifileid,checks.checktime,checks.checktype,aniversion.aniversionid,aniversion.filename from "
        //+ "aniversion,(select * from anicheck where checktype= " +ct+ ")as checks "
        //+ "where aniversion.aniversionid = checks.aniversionid) as ani where anifile.anifileid=ani.anifileid;";

      
        string strSel = "SELECT AniFile.FileTypeId, AniFile.Pvss, AniVersion_1.FileName, AniCheck_1.CheckType, "
        + " AniCheck_1.CheckTime, AniCheck_1.CheckId FROM AniFile INNER JOIN "
        + " AniVersion AS AniVersion_1 ON AniFile.AniFileId = AniVersion_1.AniFileId INNER JOIN"
        + " AniCheck AS AniCheck_1 ON AniVersion_1.AniVersionId = AniCheck_1.AniVersionId"
        + " WHERE (AniCheck_1.CheckType = "+ ct +");";
               
        SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel, MyConn);
        MyAdapter.Fill(ds, "newin");
        oRpt.SetDataSource(ds);
        this.CrystalReportViewer1.ReportSource = oRpt;

 

        ParameterFields ParamFields = new ParameterFields();
        ParameterField ParamField = new ParameterField();
        ParameterDiscreteValue ParamValue = new ParameterDiscreteValue();

        ParamField.ParameterFieldName = "str";   //   参数名    
        ParamValue.Value = ct;   //   参数值      
        ParamField.CurrentValues.Add(ParamValue);
        ParamFields.Add(ParamField);

        CrystalReportViewer1.ParameterFieldInfo = ParamFields;

        MyConn.Close();