Call SQL SProc from Crystal
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21882
Printed Date: 25 Apr 2024 at 5:00pm
Topic: Call SQL SProc from Crystal
Posted By: jsmarlow7102
Subject: Call SQL SProc from Crystal
Date 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?
|
Replies:
Posted By: lockwelle
Date 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.
|
|