Crystal Reports update command to sp

Data Connectivity
Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity

Topic: update command to sp

Author	Message
scabral79 Newbie Joined: 13 Aug 2009 Location: United States Online Status: Offline Posts: 8	Topic: update command to sp 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
	IP Logged

KAIBIRO Newbie Joined: 11 Aug 2009 Location: Canada Online Status: Offline Posts: 5	Posted: 13 Aug 2009 at 1:49pm
	You need to create the Stored procedure in your database.
	kaib
	IP Logged

scabral79 Newbie Joined: 13 Aug 2009 Location: United States Online Status: Offline Posts: 8	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?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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
	IP Logged

scabral79 Newbie Joined: 13 Aug 2009 Location: United States Online Status: Offline Posts: 8	Posted: 17 Aug 2009 at 7:20am
	Thanks DBlank, that worked!!!
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.