Catch exception in universal function?

Answered

Cameron Scully

• September 21, 2016 23:18

I have a crystal reports form with a universal function on the OK button so that it stores the 5 fields' info in SQL when it is printed. However, this form is used for all crystal reports and some don't have more than one field so when the macro executes @WoNum = $[$1000003.0.0] and it doesn't exist it throws an exception.

Is there a way to either check to see if an element like $[$1000003.0.0] exists before reading from it or the ability to catch the exception when it happens and recover from it?

Thanks

Vote

0

• Official comment

  

  Naama Aharoni

  • October 09, 2016 08:51

  Hi Cameron,

  You can try and using if/else or case structure into your SQL or Macro to make sure a value exist before if is being transferred to the relevant variable,

  Thanks, Naam

Please sign in to leave a comment.