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: Reports won't work in Client

Ian Fitzpatrick
Posts: 146

Reports won't work in Client Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Aug 07 3:54 PM

I have just upgraded to v7.0.1 from v5.2.6.

I can run a report in the Architect but in the client I get:
"Failed to retrieve data from the database. Details: Database Vendor Code: 33167768]"

SalesLogix v7.0.1 HF 3 and I have set the read only and read/write passwords on the server.

Does anyone have any thoughts on this?

Thank you.

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Reports won't work in Client Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Aug 07 8:15 PM

Did you upgraded the reports?

Starting with Version 6 saleslogix reports now should use the SLX Provider, so you need to update one by one changing the Library to use OLE instead of ODBC.
Also, when defining the New connection properties on each report, I would recommend that you Save the Credentials before checking it back in into SLX.

[Reply][Quote]

Ronald Thompson
Posts: 6

Re: Reports won't work in Client Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Oct 07 9:08 AM

Ian, I ran into this same issue. The cause was there were spaces in the database table aliases. I removed the spaces and the clients were able to run the reports.

[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 12:22:12 PM