Parameters for a Crystal Rpt are in Access. How to Pass to CR

[jsteff]

Crystal 8.5
Crystal is using a SQL Server 7 DB for data. I have a report which requires a start and end job date. The start date and end date are stored in an Access table name DateParam.

How can I tell Crystal to query the Access DB for the date parameters?

 

[dgillz]

This is a known issue. Crystal does not report a MS Access query with parameters as a datasource. Attach instead to the raw .mdb file, and add the parameters and record selection criteria on the crystal side.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[synapsevampire]

dgillz: I don't think that they're using a MS Query.

Add the table to the report.

To create parameters, select Insert->Field Object->right click parameters and select new.

Make the parameter a Range type.

Now to make it work with the database, select Report->Edit Selection Formula->Record, and place something like:

{table.datefile} = {?MyDateParm}

-k