Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Updating a Table Post Reply Post New Topic
Author Message
solent
Newbie
Newbie


Joined: 07 Apr 2008
Location: United Kingdom
Online Status: Offline
Posts: 22
Quote solent Replybullet Topic: Updating a Table
    Posted: 30 Apr 2008 at 6:17am
Hi,
 
On completion of a report I want to run a Stored Procedure.  Is this possible from within Crystal Report.  Is there anyway of setting a reference to ADO etc from within the Basic code
 
Thanks
Mark
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 01 May 2008 at 10:37pm
You can't set a reference to ADO from CR, but you can have a subreport that uses the stored procedure and put that subreport at the end of the report. You also need to have the subreport return a dummy value or b/c CR won't call a stored procedure if no data is returned.

I give a complete example of how to have Crystal Reports update a database using a stored procedure in Tutorial 11-1 of my Encyclopedia book. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
solent
Newbie
Newbie


Joined: 07 Apr 2008
Location: United Kingdom
Online Status: Offline
Posts: 22
Quote solent Replybullet Posted: 02 May 2008 at 1:19am
Thanks Brian for your help, appreciated
IP 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.