Dear All,
 I am creating a crystal report in which I am calling SP (Stored Procedure) which calls another SP and the 2nd SP is having select , insert  statements from the temporary tables e.g. #, ## temporary tables.
 SP returning the result absoultely fine in Sql server 2000 but when I am trying to access that SP from Crystal Reports , It returns nothing. Hence I am unable to create a Report.
 The approach I am following because 2nd Sp is required to change at any time. And it related to different database while 1st SP is using its default database and calling the 2nd SP to get some result from its database and that database name used in 2nd SP can be changed at any time

Please if anyone of you have its solution, plz. inform me. Thanks in advance

Regards
Rakesh Kumar
(Software Engineer)