Andy Jarrett // Code. Develop. Create.

Crystal Reports and parameters

After an unanswered post on CF-Talk, too many hours of digging around i've managed to find an MM tech note on how to pass a paramter to Crystal Reports XI. Though not one the most confident inspiring tech notes below is an even briefer description of how to do this:
<cfreport report="c:\\reports\\EmpDept.rpt">
{Employees.Department} IN [#Departments#]
</cfreport>
or
<cfreport report="c:\\reports\\CustbyState.rpt">
{Customer.State} = "AK"
</cfreport>

The following is correct syntax for using ODBC 'Date type' in Crystal Reports.
<cfreport report="report.rpt">
{table1.DateField} = {d '1997-07-01'}
</cfreport>
or
<cfreport report="report.rpt">
{table1.DateField} = Date(1997, 07, 01)
</cfreport>

I’m here, learning and working away. If you liked this content and want to keep me going, consider buying me a coffee. Your support keeps this site running and the coffee brewing! ☕️