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?