Control Script Failed in Report

Permanently deleted user

February 21, 2013 06:37

Do anyone know why I would be getting a "control script failed" error when using a calculated field in a report?

LASTNAME  is my calculated field name

formula

= ((LAST_NAME != "") ? LAST_NAME : "")

then in my text box I specify LASTNAME for my DataField

0

• 

  Permanently deleted user

  February 21, 2013 07:01

  Make sure the the field used to create your new field is included somewhere in the report. Even if you don't want to see the original field at all it must be somewhere. You can create a text box to hold it and use 'send to back' to hide it under some other opaque UI element, such as the north arrow, or even the map itself. 

  Bit of a strange workaround, but it is necessary to do this with all fields used in calculated fields or this error will be produced.

   

  0
• 

  Permanently deleted user

  February 23, 2013 04:17

  I tried what you suggested and I was able to get a good report on our test server but when I use the Preview tab in the Report Designer I still get the Control Script Error. I will put the report on the production server and see if it throws the the error.

  0
• 

  Permanently deleted user

  February 23, 2013 05:02

  Hi Bill,

  The Preview tab won't have any of the feature attributes available when it tries to render, and it will throw errors.  For any reports with formatted fields you should test against some live data in Essentials.

  Regards,

  -Malcolm

  0

Please sign in to leave a comment.