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