P&D: Error from Crystal Report

Answered

Randy Davis

• March 16, 2018 04:06

I'm attempting to schedule a Crystal Report to be sent via email through P&D, but getting the error in the image below. The culprit is a Formula where I've formated a date field using: ToTest({Command.StartDate, "MM/dd/yyyy"}).  I must format the date using a formula since it will be used inside a textbox in a string. The report runs correctly in Crystal and in B1, but I get the error through P&D.  

Any thoughts?

Vote

0

• Official comment

  

  Yaremi Miranda Lopez

  • March 22, 2018 19:26

  Hello Randy,

   

  This seems to be a configuration problem with a formula, please contact your Partner for support with this Layout.
• 

  Randy Davis

  • March 16, 2018 04:14

  Edit: I mistyped the formula in my earlier post. It should have been:

  ToText({Command.StartDate}, "MM/dd/yyyy")

  (The mistype was in the post, not the report. I still need help on this error.)
• 

  Randy Davis

  • March 22, 2018 20:07

  I am actually an SAP Consultant with the Partner. The formula works properly when ran directly from Crystal Reports. However, I get the error when running the report through P&D. The error appears to be related to P&D and not Crystal.
• 

  Yaremi Miranda Lopez

  • March 26, 2018 18:30

  Hello Randy,

  I will create a ticket to follow up this issue.

Please sign in to leave a comment.