Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Call SQL SProc from Crystal Post Reply Post New Topic
Author Message
jsmarlow7102
Newbie
Newbie


Joined: 18 Mar 2013
Online Status: Offline
Posts: 4
Quote jsmarlow7102 Replybullet Topic: Call SQL SProc from Crystal
    Posted: 16 Feb 2016 at 11:28am
I am running Crystal 2008.   I have a standard report with three tables and all that works good.

Now I was asked to provide time difference from a prior date and time to the present.   The calculation is available on a stored procedure that accepts a ticket number as a parameter and in return it will give me the last update. Then I can do the date diff calculation.

From within Crystal is it possible to call this sproc with a parameter and get back a datetime value?

I tried using a Command but it wants the parameter upfront but I need to provide the ticket number from each row as it is read and printed.   Not user input.

ideas anyone?     
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 20 Aug 2020 at 5:19am
no, Crystal doesn't work that way. You would need to call a subreport to accomplish this.

You have probably figured that out already.
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.