Calculated Fields

Posted by: dniemi-budgetrac-com on 4 August 2017, 2:57 pm EST

  • Posted 4 August 2017, 2:57 pm EST

    <FONT face=Tahoma size=2>Hi,</FONT>

    <FONT face=Tahoma size=2>I have a simple query that returns fields from a single table. When trying to use a calculated field, the following error appears:</FONT>

    <FONT face=Tahoma size=2>Error 2108 : An error occurred while executing control script [ Extended Info:Section : Detail , Event : Format , Line number: 0  Description:Fatal Exception during script excution.]</FONT>

    <FONT face=Tahoma size=2>The calculated field works in only one situation:</FONT>

    <FONT face=Tahoma size=2>DataField   =Budget_Original</FONT>

    <FONT face=Tahoma size=2>The following get the above error:</FONT>

    <FONT face=Tahoma size=2>DataField   =Budget_Original + 100</FONT>

    <FONT face=Tahoma size=2>DataField   =Budget_Original + Budget_Rev_Approved</FONT>

    <FONT face=Tahoma size=2>Any ideas? It seems that no calculations of any kind will work.</FONT>

    <FONT face=Tahoma size=2>Thanks,</FONT>

    <FONT face=Tahoma size=2>David</FONT>

  • Replied 4 August 2017, 2:57 pm EST

    The expressions look to be correct. But the error seems to be raised in Format event of the Detail section in script. Can you paste what you have in that event or compress and post the DSR/DSX files of the report.
  • Replied 4 August 2017, 2:57 pm EST


    Here is the report layout (rpx). Thanks,


Need extra support?

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

Learn More

Forum Channels