Discussion:
Passing of Parameter from VB 6 to Crystal Report
(too old to reply)
M P
2005-08-31 04:09:30 UTC
Permalink
Hi!

I am new to crystal report, so I need help. My plan is this, I will create a
form that will pass the value from a text box to Crystal. From Crystal
report, I create a report based on MS Access query. How can I filter the
report based on the parameter that will be inputed on VB?

Hoping for your response.

regards,

Me
Martin Walke
2005-08-31 16:06:48 UTC
Permalink
Hi,

There are two ways of doing this depending upon what the parameter means to
your report.

Either set a formulae (and you can have an array of there strings):

CrystalReport1.Formulas(0) = "ElementName = 'E" & ElementID & "'"

where ElementName is a formula you've already defined in the report

or use the RecordSelection formula this same way. If you open up Crystal and
look in the Developer's help section you can look up the syntax etc for
these properties.

HTH
Martin
Post by M P
Hi!
I am new to crystal report, so I need help. My plan is this, I will create a
form that will pass the value from a text box to Crystal. From Crystal
report, I create a report based on MS Access query. How can I filter the
report based on the parameter that will be inputed on VB?
Hoping for your response.
regards,
Me
Loading...