Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

need to pass parameters to my report from Access 2003

Status
Not open for further replies.

yehong

Programmer
Sep 22, 2003
291
US
I have CR8.5 Crystal report. I need to pass a parameter value from a form. I have crviewer control my the form and the report runs fine. Can anyone guide me on that?
 
Synap, thanks but this rdc example does not have any sample code for passing parameters.
 
Synap. It did help. Got to a point where I can pass a default value to the report's parameter. Got a new problem. I am getting prompt for the parameter every time I run the report with that default value showing in the value box of the parameter prompt box. I have this code:
crxReport.ParameterFields.Item(1).AddDefaultValue = "NONE"
crxReport.EnableParameterPrompting = False

The second line supresses the prompt but I am not seeing any value in the parameter. Any ideas?
I tried it in this order too but still no value in the parameter.

crxReport.EnableParameterPrompting = False
crxReport.ParameterFields.Item(1).AddDefaultValue = "NONE
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top