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!

Architect Forums - ADO General
Forum to discuss ADO specific questions for use with SalesLogix. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to ADO General | New Thread

View: Search:

Author

Thread: SLXOLEDB Provider, Crystal Report XI, Stored Procedures, SLX Version 7.51

Jo Tobias
Posts: 10

SLXOLEDB Provider, Crystal Report XI, Stored Procedures, SLX Version 7.51 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Sep 10 1:23 PM

I am writing a fairly large query with complex calculations that one of the company's reports need. For this particular scenario, I was thinking of using a stored procedure that my CR can consume using the SalesLogix provider. I am however, running into an issue:

-- CR cannot properly retrieve the SP's data using the SLXOLEDB provider. On the other hand, I can execute the query "exec " using the Administrator and it properly retrieves the number of rows. My stored procedure contains a table variable.
I've also tried using a temp table instead of a table variable in the SP, but the CR isn't returning any records.
We don't have remote users, so using a stored procedure doesn't sound like a bad option for reporting.

I've also tried just doing a simple query inside my stored procedure to test and see if it was the provider giving me issues -- that seems to work... but once I use either a temp table or a table variable, the report stops working.

Any suggestions?

Jo

[Reply][Quote]

RJ Samp
Posts: 973

Re: SLXOLEDB Provider, Crystal Report XI, Stored Procedures, SLX Version 7.51 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Sep 10 9:30 AM

Don't use the SLX OLE DB Provider.

Use a SQL Server Native connection instead.

[Reply][Quote]

Jo Tobias
Posts: 10

Re: SLXOLEDB Provider, Crystal Report XI, Stored Procedures, SLX Version 7.51 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Sep 10 10:55 AM

Hey RJ

Thanks for the reply. I tried using the SQL Server Native client, but the users will need to run the report from within the SalesLogix app. Crystal Report works seamlessly with the stored procedure using the library, but running the report using the client fails.

[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/22/2024 4:55:25 AM