Error running report

Posted by: croy75 on 4 August 2017, 2:45 pm EST

  • Posted 4 August 2017, 2:45 pm EST

    Hi all,

    I have a report and I get this error when I run it:

    Error 5800 : Scripting Error. 
     [ Extended Info:Source: Report , Event: Line number: 2  Description:Syntax error]

    The report has 5 columns, 3 groups, 2 subtotals and 1 report total.

    Any ideas?

    Thanks,
    Ivan
  • Replied 4 August 2017, 2:45 pm EST

    It sounds like you have some script on your report.

    Open the script for the report:
    http://www.datadynamics.com/Help/AR2/AR2Std/HX_Chapter_14_Scripting_and_XML.html

    If there is script you are not using, remove it.  If you are not using any script, delete it all.  Be sure you go through each one of the drop down items in the top left drop down, as each contains its own script.
  • Replied 4 August 2017, 2:45 pm EST

    It was actually the following script:

    Option Compare Database

    ]]>

    The report was exported from Access 2003 without any modifcations. The problem lies in the 'Option Compare Database'.

    Would be a good idea to add it as a fix in the next service release.


  • Replied 4 August 2017, 2:45 pm EST

    Our imports are open source and are available for modifications if you would like:
    ftp://ftp.datadynamics.com/ActiveReports2/
  • Replied 4 August 2017, 2:45 pm EST

    Great! Thanks!

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels