4/26/2024 7:29:52 PM
|
| |
| 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!
Forum to discuss ADO specific questions for use with SalesLogix. View the code of conduct for posting guidelines.
|
|
|
|
SLXOLEDB Provider, Crystal Report XI, Stored Procedures, SLX Version 7.51
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 |
|
|
| |
| |
|
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!
|
|
|
|
|
|
|
|