DLL Error & Legend Question

I'm using version 8.5.
Is there a way to limit the legend to only show elements that are shown on the chart (i.e have a value)?

Also I'm recieving the following error when I attempt to generate a report into PDF:

"ERROR IN DATABASE DLL, CHECK REPORT'S SQL"

The report sql works fine in Query Analzyer, the database is up to and it is verified.

Any advice is greatly appreciated,

Thanks,
GalahadHi,
Change your database driver and try once again.

Regards

Deepak|||Yes i had tried that. But whenever i try to change to any other driver than pdsodbc.dll (ODBC), i get errors that are the same as before.

I'm accessing SQL Server data so I have changed to every driver that i know that would work w/ sql server. But no luck.

Other reports that I run have no issues using the same driver.

FYI, The reports are run locally on my machine for testing and migrated over to a dev server. A java client converts the Crystal into PDF files.

Any suggestions?

Thanks,
Galahad|||Open the report and Do verify Database
Set the Database Location path also|||Dear all in this discussion
i am also stuck with this problem , for an immediate solution , the DNS connection , along with a set location works , but the report speed is slow

The senario, the rpt files are in the local machine , the server has the database , when the report is requested it gives the error "Physical database not found"
please let me know the solution