
Passing Parameter in Crystal Report
Define a Formula named 'Headline' in your report
then you can assign values to it .
For instance if you have a formula named headline:
CrystalReport1.Formulas(0) = "Headline= ""Salary"""
making more assignments:
CrystalReport1.Formulas(1) = ...
CrystalReport1.Formulas(n) = ...
Selecting Data:
CrystalReport1.SelectionFormula = "{Invoice.Date} = Date(1999, 06, 09)"
or
CrystalReport1.SelectionFormula = "{Customer.Name} like ""Smith*"""
( The german version uses double quotes ("). I do not know wheter
the english version requires single quotes (') or not)
Quote:
> Hi everybody,
> May someone show me a example how parameters ( variables ) can pass in
> to Crystal Reports using programming control. The reason is I only want
> the report that match that criteria from a large database instead of
> showing all data. The user only need to entry the value of parameters in
> the textboxes of a form, the system will automatic print the report.
> Thanks in advance
> G.H.
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.