Calculated Fields

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

  • Posted 4 August 2017, 2:57 pm EST

    Hi,


    I have a simple query that returns fields from a single table. When trying to use a calculated field, the following error appears:


    Error 2108 : An error occurred while executing control script [ Extended Info:Section : Detail , Event : Format , Line number: 0  Description:Fatal Exception during script excution.]


    The calculated field works in only one situation:


    DataField   =Budget_Original


    The following get the above error:


    DataField   =Budget_Original + 100


    DataField   =Budget_Original + Budget_Rev_Approved


    Any ideas? It seems that no calculations of any kind will work.


    Thanks,


    David

  • 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

    Ali,


    Here is the report layout (rpx). Thanks,


    David


    2006/08/Report1.zip
Need extra support?

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

Learn More

Forum Channels