Skip to Content

Supress field or write another value if the value is null

Hi SAP workers, I come again with a new question.

I have a report with a field that can be null. I use four tables to make the PDF and It works fine.

The problem is when the value of a field is null, the report don´t show me nothing.

And when I take the query of the report in my database, the query functions completely normal.

My question is: Is there a form to add a formula or condition for when the field is null, Give me all the remaining information?

Please help me, I don´t understand what can I do?

Thank you so much, have a nice day.

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    Posted on Mar 11, 2019 at 03:21 PM

    Where are you using the field that can be null? If you're filtering on it in the Select Expert, that might be the issue. You have a couple of options for handling this:

    1. In the Select Expert, edit the formula to include something like this instead of just looking for a value or values in a field:

    (IsNull({MyTable.NullableField}) or {MyTable.NullableField} = 'Value')

    Please note the bold outer parentheses. You MUST include these around an "or" statement if you want this to work correctly with other filter criteria. Also, you have to check for null first in this case.

    2. Using the syntax of your database, create a SQL Expression that will provide a default value for the field if it is null. Then use the SQL Expression in your selection criteria instead of the field.


    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 21, 2019 at 11:45 PM

    Thank you so much

    Add comment
    10|10000 characters needed characters exceeded