We are trying to use Crystal Report 8.5, using a front-end and back-end ACCESS database. The reports use the front-end database, which has a combination of real tables and queries, as well as links to all other tables, residing in the back-end database. My problem is that whenever I have linked tables in a report file (.rpt), I cannot verify that .rpt against the front-end database, as it ends up looking for the wrong database wherever there is a link; I also cannot verify it against the back-end database, as it is not a model for the actual database being used. Has anyone else had success with this model?
Thanks.
Thanks.