크리스탈리포트사용 스토어드프로시저에 파라미터값 넘기기 예제

protected void Page_Load(object sender, EventArgs e)
    {

//TableLogOnInfo객체생성
        CrystalDecisions.Shared.TableLogOnInfo cryLogonInfo = new CrystalDecisions.Shared.TableLogOnInfo();

 

        //계정정보설정
        cryLogonInfo.ConnectionInfo.ServerName = "10.51.97.83";
        cryLogonInfo.ConnectionInfo.Password = "패스워드";
        cryLogonInfo.ConnectionInfo.UserID = "DB로그인아이디";
        cryLogonInfo.ConnectionInfo.DatabaseName = "디비명";

 

        //계정추가
        CrystalReportViewer1.LogOnInfo.Add(cryLogonInfo);

 

        //데이터베이스 로그인창 false 설정
        CrystalReportViewer1.EnableDatabaseLogonPrompt = false;

 

        //피라메터 설정 시작
        CrystalReportSource1.Report.Parameters.Clear();

 

        CrystalDecisions.Web.Parameter param1 = new CrystalDecisions.Web.Parameter();
        param1.Name = "@EDUCATIONAL_GUBN";
        param1.DefaultValue = "S03001";
        CrystalReportSource1.Report.Parameters.Add(param1);
        //파라메터 추가1

 

        CrystalDecisions.Web.Parameter param2 = new CrystalDecisions.Web.Parameter();
        param2.Name = "@YEAR";
        param2.DefaultValue = "2010";
        CrystalReportSource1.Report.Parameters.Add(param2);
        //파라메터 추가2

 

        CrystalDecisions.Web.Parameter param3 = new CrystalDecisions.Web.Parameter();
        param3.Name = "@HAGGI_GUBN";
        param3.DefaultValue = "E01001";
        CrystalReportSource1.Report.Parameters.Add(param3);
        //파라메터 추가3

 

        CrystalDecisions.Web.Parameter param4 = new CrystalDecisions.Web.Parameter();
        param4.Name = "@SUBJECT_CD";
        param4.DefaultValue = "s008";
        CrystalReportSource1.Report.Parameters.Add(param4);
        //파라메터 추가4

 

        CrystalDecisions.Web.Parameter param5 = new CrystalDecisions.Web.Parameter();
        param5.Name = "@USER_NO";
        param5.DefaultValue = "NSU10010193";
        CrystalReportSource1.Report.Parameters.Add(param5);
        //파라메터 추가5

 

        CrystalDecisions.Web.Parameter param6 = new CrystalDecisions.Web.Parameter();
        param6.Name = "@CLASS_CD";
        param6.DefaultValue = "B05001";
        CrystalReportSource1.Report.Parameters.Add(param6);
        //파라메터 추가6

 

        //파라미터 로그인창 false 설정
        CrystalReportViewer1.EnableParameterPrompt = false;

}