Problem passing parameter to crystal report

[jccorner]

Does anyone know how to stop a crystal report from prompting for a parameter that I'm already sending to the report??

[Nerseus]

I'm guessing you have the name wrong? Otherwise Crystal should not be prompting you. If that's not it, maybe Crystal has an option to "always prompt for params" or the reverse, and it needs to be set/cleared?

 

-ner

[jccorner]

What does the name have to do with it??

 

I'm trying to accomplish this is VB and I have checked for any parameter prompting by the crystal report viewer and don't see such an option. I don't know of any options in the report itself but if anyone does, please let me know so I can set it accordingly.

[naturally96]

I instantiate the report object and pass the parameter behind the scenes without using the report viewer object because I thought the viewer made it more difficult to print the report. This avoids all prompts and the user just gets the printed report on their printer. Not sure if you are trying to print directly, but hope this helps....

 

Dim oRpt As New ReportDocument

oRpt.Load("\\Server\folder\Report.rpt")

oRpt.SetDatabaseLogon("logon", "password")

oRpt.SetParameterValue("CrystalParameterName", intParameterValue)

oRpt.PrintToPrinter(1, False, 1, 1)

[lala23]

hi! I'm having the same prob. If you find the solution, pls let me know. Thanks.

[lala23]

Found the answer to Parameter Passing Prob

 

I learned this from Brian Bischof's ebook which you can download at his website: http://www.crystalreportsbook.com/

 

You should do all your runtime customization before you preview your report in the CR Viewer. My code is below...

 

ParameterFields paramFields = new ParameterFields();

ParameterField paramField= new ParameterField();

ParameterDiscreteValue discValue = new ParameterDiscreteValue();

paramField.ParameterFieldName = "Product";

discValue.Value = textBox1.Text;

paramField.CurrentValues.Add (discValue);

paramFields.Add(paramField);

viewer1.ParameterFieldInfo = paramFields;

 

viewer1.ReportSource = new CrystalReport1();

[arahil]

plz i have the same problem with prompting my value again through the crystal viewer

so if u find the solution plz help me to dont see again this prompting window