Pass Crystal parameter to a SQL sp

cphspain · November 12th, 2003, 05:59 AM

I would like to pass parameters to an SP. I already have created the SP and it has parameters, so now i need to know how point to it as the data source in Crystal.
If you also know where i can find samples, would wellcome.

Regards

cphspain

melvik · November 12th, 2003, 06:06 AM

Insure u can find many samples at http://www.crystaldecisions.com/prod...alreports/net/ but wait a min, have create ur Report (i mean .rpt file) or u just neet to set parameters from aspx files?

Always:),
Hovik Melkomian.

cphspain · November 12th, 2003, 06:42 AM

Well, i have some sp that update tables and others are just only querys that not need special kind of report.
For the first one, sp that update tables, the idea is put a link on intranet, that after click oon it, open a crystal report where the first step is ask to the user for Start & End dates, these are the parameters that i need to pass to the SP.
After entered the dates sp run and refresh the report.

Thank you

cphspain

melvik · November 12th, 2003, 07:01 AM

Well this is a sample I've done HTH.

Code:

        //CR Variables
        Empower.reports.foreign        crReportft;
        Empower.reports.foreign_p    crReportfb;
        Empower.reports.vekalat        crReportvt;
        Empower.reports.vekalat_p    crReportvb;
        ConnectionInfo crConnectionInfo;
        TableLogOnInfo crTableLogOnInfo;
        Database crDatabase;
        Tables crTables;
        ParameterFields crParameterFields;
        ParameterField crParameterField;
        ParameterValues crParameterValues;
        ParameterDiscreteValue crParameterDiscreteValue;
        protected CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer1;
        protected CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer2;

        private void Page_Load(object sender, System.EventArgs e)
        {
            string id, type;
            id = Request.QueryString.Get("id");
            type = Request.QueryString.Get("type");

                crReportvt = new Empower.reports.vekalat();
                crConnectionInfo = new ConnectionInfo();
                crConnectionInfo.ServerName = "BORNA";
                crConnectionInfo.DatabaseName = "NewBaz";
                crConnectionInfo.UserID = "report";
                crConnectionInfo.Password = "";

                crDatabase = crReportvt.Database;
                crTables = crDatabase.Tables;

                foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
                {        
                    crTableLogOnInfo = crTable.LogOnInfo;
                    crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
                    crTable.ApplyLogOnInfo(crTableLogOnInfo);
                }

                crReportvb = new Empower.reports.vekalat_p();
                crConnectionInfo = new ConnectionInfo();
                crConnectionInfo.ServerName = "BORNA";
                crConnectionInfo.DatabaseName = "NewBaz";
                crConnectionInfo.UserID = "report";
                crConnectionInfo.Password = "";

                crDatabase = crReportvb.Database;
                crTables = crDatabase.Tables;

                foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
                {        
                    crTableLogOnInfo = crTable.LogOnInfo;
                    crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
                    crTable.ApplyLogOnInfo(crTableLogOnInfo);
                }
                CrystalReportViewer1.ReportSource = crReportvt;
                CrystalReportViewer2.ReportSource = crReportvb;

            crParameterFields = CrystalReportViewer1.ParameterFieldInfo;
            crParameterField = crParameterFields["@DepForm"];
            crParameterValues = crParameterField.CurrentValues;

            crParameterDiscreteValue = new ParameterDiscreteValue();
            crParameterDiscreteValue.Value = id;
            crParameterValues.Add(crParameterDiscreteValue);

            // Set Second Parameter
            crParameterDiscreteValue = null;
            crParameterField = crParameterFields["@Type"];
            crParameterValues = crParameterField.CurrentValues;

            crParameterDiscreteValue = new ParameterDiscreteValue();
            crParameterDiscreteValue.Value = type;
            crParameterValues.Add(crParameterDiscreteValue);
        }

Always:),
Hovik Melkomian.

ayazahmad22 · January 23rd, 2004, 07:35 AM

when you create a blank report, select the data source. Then select your sp from the stored procedures list. If you are not able to see the stored procedures, write what version of CR and what database are u using?

sadiku · January 27th, 2005, 07:03 AM

how to create crystal report and all objects of it dynamically?