Nov 20, 2006 #1 nmmure Programmer Joined Jun 8, 2006 Messages 200 Location US Hi, How to pass the parameter values from VB6.0 to crystal reports 10. User values i need to send to rpt file. please help me any one. Mure
Hi, How to pass the parameter values from VB6.0 to crystal reports 10. User values i need to send to rpt file. please help me any one. Mure
Nov 21, 2006 #2 monkeylizard MIS Joined Nov 15, 2000 Messages 322 Location US This code passes Start and End date parms to Crystal. Crystal has two parms named VBSTART and VBEND Code: 'Start Date ParameterFields strStart = "Date" CRRPT.ParameterFields(1) = "VBSTART;" & strStart & ";True" 'End Date ParameterFields strEnd = "Date" CRRPT.ParameterFields(2) = "VBEND;" & strEnd & ";True" Of course the "Date" is whatever you are getting in your VB app that you want to pass in. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes of reading manuals. Upvote 0 Downvote
This code passes Start and End date parms to Crystal. Crystal has two parms named VBSTART and VBEND Code: 'Start Date ParameterFields strStart = "Date" CRRPT.ParameterFields(1) = "VBSTART;" & strStart & ";True" 'End Date ParameterFields strEnd = "Date" CRRPT.ParameterFields(2) = "VBEND;" & strEnd & ";True" Of course the "Date" is whatever you are getting in your VB app that you want to pass in. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.
Nov 21, 2006 #3 monkeylizard MIS Joined Nov 15, 2000 Messages 322 Location US There's also an FAQ in this forum that gives some more detail: http://www.tek-tips.com/faqs.cfm?fid=4575 Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes of reading manuals. Upvote 0 Downvote
There's also an FAQ in this forum that gives some more detail: http://www.tek-tips.com/faqs.cfm?fid=4575 Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.