Open Forum

ROI Error in Custom Report

  • 1.  ROI Error in Custom Report

    BRONZE CONTRIBUTOR
    Posted 10-31-2018 01:49 PM
    Edited by Karla Johnson 10-31-2018 01:51 PM
    ​We have a custom report and when you load a template we get "Error in populating the array of fields.  Possibly a syntax error in the ROISelect formula"
    There is no ROISelect formula in the crystal report.
    If we run the report without a template no error is received.
    Also, when going to the select tab, no Fields display

    Thoughts??

    Thanks!!!

    ------------------------------
    Karla Johnson
    System Architect
    Schneider Electric
    Carrollton TX
    ------------------------------


  • 2.  RE: ROI Error in Custom Report

    SILVER CONTRIBUTOR
    Posted 10-31-2018 01:59 PM
    Hi Karla,

    I found redoing the template usually fixes the issue.  I would delete and recreate the template...

    Let me know of any issues.

    Thanks,
    Michael

    ------------------------------
    Michael O'Neill
    Controller
    Eastex Telephone Cooperative
    Henderson TX
    ------------------------------



  • 3.  RE: ROI Error in Custom Report

    BRONZE CONTRIBUTOR
    Posted 10-31-2018 02:10 PM
    I thought that too and I still get the error
    Click OK and then get a blank field list


    ------------------------------
    Karla Johnson
    System Architect
    Schneider Electric
    Carrollton TX
    ------------------------------



  • 4.  RE: ROI Error in Custom Report

    SILVER CONTRIBUTOR
    Posted 10-31-2018 02:11 PM
    You're going to need a Crystal expert now, not an accountant like yours truly  :)

    ------------------------------
    Michael O'Neill
    Controller
    Eastex Telephone Cooperative
    Henderson TX
    ------------------------------



  • 5.  RE: ROI Error in Custom Report

    BRONZE CONTRIBUTOR
    Posted 10-31-2018 02:14 PM
    ​Figured it out!
    The CmpnyName formula had nothing in it.  Commented it out and it worked.

    ------------------------------
    Karla Johnson
    System Architect
    Schneider Electric
    Carrollton TX
    ------------------------------