Skip to Content

This Array Must be Scripted Error

Hello,

I am working on SAP B1 report and I need to change parameter in Selection screen to use check box which I've done by changing parameter settings with Multiple Values Selection :

Previously this 'item' field was appearing in drop down which I don't want now.. I want check boxes for this I made changes in parameter on report like this:

unfortunately I am getting error on executing this report

on screen :

on back end there is issue occurring in this formula of report :

Any help would be highly appreciated please..

Regards,

Sana

1.jpg (138.0 kB)
3.jpg (132.2 kB)
2.jpg (74.5 kB)
4.jpg (105.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 15, 2017 at 10:16 AM

    Hi Sana,

    Now that you've made the prompt to accept multiple values, you'd also need to modify the formula that displays the selected value.

    If you want those selected values to be displayed as a comma-separated string, replace the highlighted part in your LAST screenshot with:

    Join({?pay_term@ select pymntgroup from octg}, ', ')

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15, 2017 at 11:27 AM

    I may have typed the prompt name incorrectly (Or there could be spaces I'm missing).

    Please replace the highlighted part of the string in your screenshot above with the actual prompt name on your report.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded