Print Page | Close Window

Stored Procedure Datasource Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4259 Printed Date: 28 Apr 2024 at 3:37am Topic: Stored Procedure Datasource Posted By: svaillancourt Subject: Stored Procedure Datasource Date Posted: 15 Sep 2008 at 9:52am Hello, I'm trying to add columns to a report based on a stored procedure that we have in our SQL2000 database. (1)I've duplicated the procedure and (2)reset the datasource location so that crystal looks for the procedure in the new location. And then (3) refreshed/connected/verified the datasource.  Everything checks out in query analyzer but crystal is getting nothing. I've made sure there's nothing prohibitive in the selection formula but the sql query that crystal is generating is "HMS"."dbo"."udr_Inventory";1 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL For some unknown reason. Is there some step that I have overlooked or something in the above steps I've done wrong to generate this? I've googled extensively and I've been in touch with the vendor who actually created the procedure This is crystal reports 2008 running on Vista Business.

Print Page | Close Window