Seagate Info and SQL Server Stored Procedure
Seagate Info and SQL Server Stored Procedure
(OP)
Hi
I have a crystal report that has a stored procedure as a data source. There are two date parameters I am passing as string. The report runs fine in CR 7.0. When I add the report to Seagate Info 7.0 the report does not return any data. I ran a trace on SQL Server and found that Seagate Info passes the parameters as NULL.
Are Stored Procedures with Parameters supported in Seagate Info 7.0?
Any help will be appreciated.
Thanks
Fahim
I have a crystal report that has a stored procedure as a data source. There are two date parameters I am passing as string. The report runs fine in CR 7.0. When I add the report to Seagate Info 7.0 the report does not return any data. I ran a trace on SQL Server and found that Seagate Info passes the parameters as NULL.
Are Stored Procedures with Parameters supported in Seagate Info 7.0?
Any help will be appreciated.
Thanks
Fahim
RE: Seagate Info and SQL Server Stored Procedure
Perhaps you have different connectivity in SI?
Try putting CR 7 on the SI server and see if it runs there.
http://support.businessobjects.com/communityCS/Tec...
-k
RE: Seagate Info and SQL Server Stored Procedure
Thanks for your reply