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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing Parameters into Crystal Report

Status
Not open for further replies.

michaellince

Programmer
Feb 18, 2002
4
PH
How could i connect my stored procedures into crystal report?
or
How could i connect my DLL file into crystal report?

Example:
****stored procedures
crystalreport.sql = 'Select * from table where <mytablename> = <>'
crystalreport.action = 1

crystalreport.parameterfield(0) = 'mytalbe';'myparameter';'true'
crystalreport.action = 1
 
When you create the report, you pick the stored procedure as the data source.

You either a) pass parameters or b) overwrite the entire SQL string of the report. You don't do both. Usually, overwriting the entire SQL string is a bad practice.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top