I have a report that I can run just fine. However, when I schedule it through Logicity and attempt to run it - I get following error:
Specified cast is not valid. Couldn't store <12/30/1899 12:00:00 AM> in @BlockTime Column. Expected type is TimeSpan. (emailCrystalReport)
@BlockTime is a formula that reads:
if Minute ({@DateTime}) < 30
then Time (Hour ({@DateTime}) , 0 , 0)
else Time (Hour ({@DateTime}) ,30 , 0)

@DateTime reads: DateTimeValue (({mCallEnd.Timestamp} / 1440) + 1)

This only coverts a number to a Date Time.

@BlockTime is also used as a group.

I have included the report fr you to see. Like I said I can run it fine through Crystal Reports, but cannot schedule it to run. Any help would be greatly appreciated.