Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: Stored Procedure Datasource Post Reply Post New Topic
Author Message
svaillancourt
Newbie
Newbie
Avatar

Joined: 15 Sep 2008
Location: United States
Online Status: Offline
Posts: 1
Quote svaillancourt Replybullet Topic: Stored Procedure Datasource
    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.


Edited by svaillancourt - 15 Sep 2008 at 9:54am
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.