Replace multiple tables with a query for existing reports.

[whitfa]

Hi there!

I'm using CR 8.0.

I have written a Crystal query to replace a combination of multiple oracle tables I use in a number of CR reports. I want to be able to remap the fields in the existing reports to the new query, rather than the tables I have there now.

When I try to replace these tables with the query, CR crashes! Am I doing something wrong?

I have been trying this by attempting the following:

1. Database> Add database to report..
2. Select the .qry file
3. 'Remap' the fields to the query
4. Remove the tables

After action 2 above I get the following dialogue;
"Field not found. The data dictionary field xxxx not found."
I get one of these for each field in the existing tables before it brings up the Visual Linking Expert and then straight away an application error.

Is there another way around this? Should this method actually work. Ie. do I need to ask our IS peeps to install a patch to rectify this?

 

[synapsevampire]

Keep in mind that even Crystal did not suggest using the Crystal Query tool in CR 8, and it has since been dropped and is no longer supported.

I would speak to your IS *peeps* to build a View on the database.

I don't lend support to building Crystal Queries, but they are usable and it might be your connectivity, so try posting the database and connectivity when asking about database errors.

-k

 

[whitfa]

Okay, thanks. I hadn't considered a view before. That should do the trick I think!