How to pass an empty string to a prompt macro

Use a space for the default value in prompt macro.

The prompt, which is created in FM using prompt macro, becomes required prompt. This means that we need to supply a value in order to satisfy this prompt.

If a space is added as a default value in prompt macro, the prompt is satisfied and the report runs.

Macro will look like this: # prompt('Desk' , 'string' , ' ')#

Please note that there is space between " ".

Also, in the SDK a space needs to be used as a value to satisfy the required prompt.

For example: item.setUse(" ");

The space does not get passed to the stored procedure and the report runs successfully.