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
Graham Cunningham replied
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;
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 ''