Physical database not found

[phirst]

I am using Crystal Reports Developper V8.
I created a query using the SQL Designer, 'cos I need to use a UNION. The query, on its own, works fine.
When I try to view a report using this query I get the error "Physical database not found" and a blank report.
There are no problems with the database connection as I have created and viewed several other reports, some of which use queries (without UNION).
I did have trouble with parameter fields, however.
I have two parameter fields defined in the query. The first time I created a report using this query one of the parameter fields was renamed (CR added 57 to the end). When I viewed the report I got the error parameter xxx not defined (where xxx was the name in the query).
I got rid of this problem by deleting the report and starting again.
...
I have tried to simplify things, and even without the UNION and the parameter fields, I get the same error.
Suggestion?

 

[cc5305]

Well, I think you can keep the UNION. Is the parameter created in the SQL Designer? If it is, then I suggest you to get ride of that and just run a simple query in SQL Designer without the parameters. Then create the new report base on that query in Report Designer and create the parameter fields there. You might need to create formula fields as well depending on what you're looking up in the parameter field.
But remember to change the query so that you have the fields you need for the parameter selections later in the Report Designer. In Report Designer, just don't display these field (use hide or suppress). Hope this helps.

 

[kenhamady]

The Union itself should not be the problem, if the QRY can run the file.

Troubleshooting steps:

1) Verify that the SQL can be run from the SQL designer. Verify the database in the SQL designer. Save the QRY File again. Try creating a new report using this file. Run this report from the same PC as the SQL designer to eliminate permissions issues.

2) If the new report above gives an error, rerun the QRY and save it "With DAta". Now try running a new report against the QRY.

3) If new reports are OK but the problem is an existing report, Open the report and verify the database. IF the QRY has been renamed, use "Set Location" to assign to the new QRY.

Let me know what errors or info these provide Ken Hamady

http://www.kenhamady.com/

 

[phirst]

Thanks for your suggestions, but nothing worked.
I quite simply uninstalled CR then reinstalled.
Now it works fine, even with the UNION, but for how long?
Thanks Windows 98 2nd edition