Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Field with no Value

I use CR 2008 and make an Report on Navision5

In the Table I select a field (Varchar10 -notnull) the value is '' means empty.

On SQL Server i can make selections like ...where field=''

In CR I cant edit/change(backgr.color) if it is empty - if there is a value it works.

How can I solve this. SP1 and SP2 installed

Former Member
replied

Tony,

Not being able to change the background color of a field usually only occurs when the value isnull. Try creating a formula to check if the value is coming in as a null;

isnull( )

If it comes back as true then you might want to enable the Report Option Convert Database Null values to default. This will convert a null string to ''

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question