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!

ACCESS 2000 passing parms into Crystal reports

Status
Not open for further replies.

fpc

IS-IT--Management
Dec 22, 2000
13
US
Can anyone provide me with information on passing a paramter from an Access form into Crystal reports to filter data?
Example: Job ticket# is on a form with the Job Ticket Information, I would like to pass the Job Ticket to Crystal to print info re the job ticket displayed..

Thanks for any assistance
 
I see this is kind of old and not relevant any more but ran across it in a search
here is how I do it.

crviewer1.ReportFileName = "G:\Intsrv\reports\" & rptName
crviewer1.PrintReport
crviewer1.SelectionFormula = "{EQPINV.ItemID} like '00*'"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top