Hi
I would like to know how to print a single record of a table based on the user choise using a crystal report ?
Thanks
Printable View
Hi
I would like to know how to print a single record of a table based on the user choise using a crystal report ?
Thanks
Use the SelectionFormula property of the CrystalReport Control
Thank you, That was the clue to the correct needs, Appreciate
CrystalReport1.ReportFileName="c:\project\empdet.rpt"
To pass Numeric type parameter
CrystalReport1.SelectionFormula="{emp.empno}=" & <value>
To pass character type parameter
CrystalReport1.SelectionFormula="{emp.empname}='" & <string value> & "'"
To pass Date type parameter
CrystalReport1.SelectionFormula="{emp.joindate}=date(" & format(<date value>,"yyyy,mm,dd") & ")"
Thanks, I tried it out and it works as per my needs, Thanks alot