[RESOLVED]How to Stop Crystal from prompting for parameters

[Ogeechee]

Thanks to Kleinma I am successfully passing my desired parameters to my Crystal Report.

But I am still being prompted to enter the parameters.

Any assistance on how to disable the paramter prompt when the crystal veiwer opens the report.

[Aspnot]

If you pass 1 parameter to the report, you must pass all of them. Are you passing all of them?

[Ogeechee]

Yes I am successfully passing 2 parameters that were coded in the load event for the report. But I am still being prompted by Crystal to enter the parameters. (and it doesnt matter what data i place in the prompt windows, the coded data overwrites that and displays the correct information in the report). I just want to stop crystal form prompting the user to enter data.

[mar_zim]

It prompts a window asking for a parameter because you didn't supply the correct parameter in which it's expecting a value.

[Ogeechee]

my parameter in the crystal reports are CPMHID ---- number and NoteDate ---- Date

My code being called and the report load event is as below:

Dim rpt As New obhsnotes


rpt.SetParameterValue("CPMHID", paramhid)
rpt.SetParameterValue("NoteDate", paradate)
Me.viewer.ReportSource = rpt
'Me.viewer.PrintReport()

in my main module i have set public the following variables:

Public paramhid As Integer
Public paradate As Date

[JanZuk]

My code being called and the report load event

Just to clarify, are you declaring all of this in an actual load\format event of Crystal or from the Form's Load event?

In my experience passing values to parameters I do my reportDoc.Load(), reportDoc.SetDataSource(),.SetParameterValue() and viewer.ReportSource=reportDoc all from the same event, usually a click event from a button on a form

[Ogeechee]

Yes it is on the Form load event of the form that has the crystal report viewer nested within it.

[JanZuk]

I was able to recreate this by calling RefreshReport() from my CRViewer. You're not making a call to this, are you?

Also, the report object from the CR AxtiveX Design Runtime library has a property called EnableParameterPrompting which you can set to false.

Just covering all the bases.

[Ogeechee]

would you have a code snippet and could you please let me know where i need to place this code

[Asgorath]

Ogeechee what do you mean how to stop crystal from prompting for parameters?
You mean with .SetParameterValue doesn't work??

Regards
Jorge

[Ogeechee]

I found my problem I was call the report form a button and assigning the report source there. I was also assigning the report source from the properties window from the crystal viewer. When I removed the reportsource from the propeties of the Crystal viewer the rport runs successful;. Thank you all for your assistance on this issue.