Question

Business Reporter - Displaying Function Parameters

  • 8 June 2020
  • 1 reply
  • 271 views

Badge +1

I am creating a BR where I have a requirement to display the output from an advanced Function Parameter in the report.

I am aware that with Simple Parameters, you are able to drag and drop those items onto the report in Design Mode.
However, the same is not possible for Function Parameters.

How can I display the output from these on the report?


1 reply

Userlevel 4
Badge +8

Hi,

I am not sure if there is an existing functionality to cater this requirement. Anyway, another way of achieving this is to

  • Drag and Drop a standard parameter (value or name) to the Excel sheet . 
  • Click on the cell
  • Edit the Parameter Name in the Formula Bar

For an example, if the standard parameter name is YearStandard, the formular bar will be like this.

=IFSREPPARAM("YearStandard.Value")

If the function parameter name is YearFunction, what you can do is to change the name to

=IFSREPPARAM("YearFunction.Value")

This way you can show the value or name from the function parameter. Just check if you can show the values this way.

Best Regards,

Nisansala

Reply