Supress field or write another value if the value is null

[former_member603666]

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.

[DellSC · Accepted solution]

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.

-Dell

[former_member603666]

Thank you so much