Print Page | Close Window

update command to sp

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7368
Printed Date: 02 May 2024 at 4:20pm


Topic: update command to sp
Posted By: scabral79
Subject: update command to sp
Date Posted: 13 Aug 2009 at 12:59pm

Hi,

I have a crystal report that is using a command with a sql script to get data from a sql database.

I need to change the command to be a stored procedure.  How do i do that in Crytal Reports XI?

thanks

Scott


Replies:
Posted By: KAIBIRO
Date Posted: 13 Aug 2009 at 1:49pm
You need to create the Stored procedure in your database.

-------------
kaib

Posted By: scabral79
Date Posted: 13 Aug 2009 at 1:50pm
sorry,
 
i should have articulated a bit more...
 
i did create the stored proc and now i need to change the report to use the stored proc instead of the sql script command.
 
How do i do that?

Posted By: DBlank
Date Posted: 17 Aug 2009 at 7:16am
If you named all of your fields the same try this link (use a back up of the report just in case )
 
http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5229 - http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5229

Posted By: scabral79
Date Posted: 17 Aug 2009 at 7:20am
Thanks DBlank, that worked!!!


Print Page | Close Window