Crystal Reports with stored procedures

[Former Member]

Hello Members,

I have come across a unique problem (only for me I guess). When I develop a report using a sql command (with sql script), I can run this report against any server or any datatbase dynamically with out using the "Set Data Source Loaction" found under database fields in field explorer. This report is based on a stored procedure and uses a OLEDB connection. When I developed this report for the first time, I defined its database connection (servername,database). Now I have created a same procedure with the same name on different server under a different database. I wanted to run this report against the new server, but I am getting an error " Failed to retrieve data from database". If i click OK on this pop up window. It displays another pop up window and says the old database name is not found in the new server. The criteria is the report should be able to run on any database on any server if the same stored procedure exists in there just like the report with sql command runs. How to solve this problem ?

Thanks in Advance!!!!

[Former Member · Accepted solution]

Did you try using "set datasource location"? Go to database-->set data source location and create new connection and select the new stored procedure and the old one and click on update. Now your report will connect to new server while refreshing the report.

Regards,

Raghavendra.G

[Former Member · Accepted solution]

Hi Raghavendra,

I know that is one of the way to do this ands it is manual process. The problem here is different clients will be running this report. Each client's data is located on different server and different database and this update process should be done automatically. Do you know any way to do this ?

Thanks!!!!

[Former Member · Accepted solution]

I think you can try using a business view with dynamic data connection.

Regards,

Raghavendra

[Former Member · Accepted solution]

Raghavendra-

I think thats a lot of re work from our side. Is there any way to accomplish this task using the existing stored procedures ?

Thanks.