slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: The report cannot make an OLE DB connection.

Josh
Posts: 6

The report cannot make an OLE DB connection. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Mar 09 9:41 AM

When trying to run several reports from SLX 7.2 I get the error:

Unable to retrieve the report.
The report cannot make an OLE DB connection.
Please contact your Administrator.

These reports work fine in Crystal Reports 10, but give this error when ran from SLX. The only thing separating these reports from others I use that work fine is that they use a DB that is not associated with SLX. Can reports ran from SLX use non-slx Databases? Or is it more likely a problem with the connection?

Any information would be helpful.

Thanks.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: The report cannot make an OLE DB connection. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Mar 09 7:28 PM

The short answer to your question is no - your SLX report can access only objects in the SLX database.

But you could create a SQL Server view in the SLX db which gets the other-database data for you. Make sure that the view is owned by the sysdba schema and register it through the SLX database manager - then it should be available to you in your reports.

Phil

[Reply][Quote]

Josh
Posts: 6

Re: The report cannot make an OLE DB connection. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Mar 09 8:10 AM

I see!

Thanks for the help, greatly appreciated.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 6:43:30 AM