Hi friends,

Could anyone help me how to pass parameter in crystal report using c#.net?

Thanks a lot
preetha

Sanket's
Jai Swaminarayan

I presume you are using a crystal reports viewer from within a c# form.

Anyway, this is how I passed a formula field so I guess parameter fields are the same.


ackPrt newReport= new ackPrt();
newReport.DataDefinition.FormulaFields[0].Text="\"ACK\"";
crystalReportViewer1.ReportSource = newReport;

the 1st and 3rd lines should be ok for you.
the important line is line 2. I have created a formula field called reportType. The code in line 2 places the text ACK into the first formula field (a zero seeded array).

Hope that helps

Hi Happyslug,

You are passing a parameter as a formula within Crystal Report from C#.

What about passing a parameter as a parameter within Crystal Report from C#? I'm encountering a lot of problem at my end. I'm unsure if my C# code is incorrect or the Crystal Report I created is incorrect.

A stanza of my C# code is given below:

ParameterDiscreteValue crtParamDiscreteValue;
ParameterField crtParamField;
ParameterFields crtParamFields;

crtParamDiscreteValue = new ParameterDiscreteValue();
crtParamField = new ParameterField();
crtParamFields = new ParameterFields();

crtParamDiscreteValue.Value = "ABC";
crtParamField.ParameterFieldName = "source";
crtParamField.CurrentValues.Add(crtParamDiscreteVa lue);
crtParamFields.Add(crtParamField);

crtRptViewer.ParameterFieldInfo = crtParamFields;

Within Crystal Report itself, I have created a parameter called "source" as well as using the "Select Expert" to refine my search criterion to a specific column of the table I am drawing the data from.

Yet, I get the error: Query Engine Error.

I am at a loss now. Can you kindly advise me?

Thanks.

I am using Visual Studio .NET 2003 and Crystal Report XI. I am wondering if this is one of the several bugs reported for Crystal Report XI?

I have been selfish TAKE TAKE TAKE, a

Now I can give. (after many hours if research)

This worked for me.

private void Page_Load(object sender, System.EventArgs e)
{
    CrystalReportViewer1.DataBind();
    SetParameterFields();
}

protected void SetParameterFields ()
{
    ParameterField f1 = CrystalReportViewer1.ParameterFieldInfo[0];
    ParameterDiscreteValue v1 = new ParameterDiscreteValue();
    v1.Value = Request.QueryString["Whatever"]; //Or Session("Whatever")
    f1.CurrentValues.Add(v1);
    CrystalReportViewer1.RefreshReport();
}

I think I have a solution that does not make errors if U are interested :D


and that is the solution
Parameter_mohammad.ParameterFieldName)
Dim x As New CrystalReport1

x.SetParameterValue(x.Parameter_mohammad.Parameter FieldName,5)

'my point is that the parameter field(mohammad) becomes a property
'of the crystal report object(x.Parameter_mohammad) and the you take
'the parameter field name(x.Parameter_mohammad.ParameterFieldName)
' 5 is the value you want to assign
        CrystalReportViewer1.ReportSource = x

I think I have a solution that does not make errors if U are interested


and that is the solution
Dim x As New CrystalReport1

x.SetParameterValue(x.Parameter_mohammad.Parameter FieldName,5)
CrystalReportViewer1.ReportSource = x



the following is explaination not part of the solution:

'my point is that the parameter field(mohammad) becomes a property
'of the crystal report object(x.Parameter_mohammad) and the you take
'the parameter field name(x.Parameter_mohammad.ParameterFieldName)
' 5 is the value you want to assign

i found that the last line

CrystalReportViewer1.RefreshReport();

refreshed my whole report, and as a result, deleted what i just assigned.

:Dhi everyone....following is the code to successfully
    pass one or many parameters of any datatype from C# to Crystal Report...One can write the code in the page load event...

if (Session["RPT_NAME"] != null)
        {

            ReportDocument rpt = new ReportDocument();
            rpt.Load(Server.MapPath((string)Session["RPT_NAME"]));


            int cnt = rpt.DataDefinition.ParameterFields.Count;
            for (int i = 0; i < cnt; i++)
            {
                ParameterValues myvals = new ParameterValues();
                ParameterDiscreteValue myDiscrete = new ParameterDiscreteValue();

                switch (rpt.DataDefinition.ParameterFields[i].ParameterValueKind)
                {
                    case CrystalDecisions.Shared.ParameterValueKind.DateTim eParameter:
                        myDiscrete.Value = Convert.ToDateTime(Request.QueryString[i]);
                        break;

                    case CrystalDecisions.Shared.ParameterValueKind.Boolean Parameter:
                        myDiscrete.Value = bool.Parse(Request.QueryString[i]);
                        break;
                    case CrystalDecisions.Shared.ParameterValueKind.DatePar ameter:
                        myDiscrete.Value = Convert.ToDateTime(Request.QueryString[i]);
                        break;
                    case CrystalDecisions.Shared.ParameterValueKind.NumberP arameter:
                        myDiscrete.Value = int.Parse(Request.QueryString[i]);
                        break;
                    case CrystalDecisions.Shared.ParameterValueKind.StringP arameter:
                        myDiscrete.Value = Convert.ToString((Request.QueryString[i]));
                        break;
                }
                myvals.Add(myDiscrete);
                rpt.DataDefinition.ParameterFields[i].ApplyCurrentValues(myvals);
            }
            CrystalReportViewer1.ReportSource = rpt;
            CrystalReportViewer1.DataBind();
        }