cancel
Showing results for 
Search instead for 
Did you mean: 

Pulling fields when some are blank

Former Member
0 Kudos

I am pulling information from a table where sometimes, some of the fields are blank.

Example:

Item # Size Color

123 L Red

124 M Blue

125 Null Null

When it pulls the report, item #125 doesn't show on the report. I am sure it is because of the Null fields. how can I get this info to come into the report?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Go to File -> Report Options -> Make sure the Convert Database Null Values to Default and Convert Other Null Values are both unchecked.

See if that works.

Regards,

Zack H.

Answers (3)

Answers (3)

Former Member
0 Kudos

Will this cover the subrepoorts too?

Former Member
0 Kudos

Use the same option in sub report as well

Regards,

raghavendra

Former Member
0 Kudos

do you have any record selection formula? if so add a record selection like this

isnull(Item Field)=true

Regards,

Raghavendra

Former Member
0 Kudos

Either use ISNULL() for size and color or under File -> Report Options check the box next to "Convert Database NULL values to default'