Preview of Crystal Report Goes Blank if one field is empty?

[Former Member]

Can anyone direct me to any knowledgebase article that would show how to fix an error where I have a basic report that is accessing basic fields from a database, and when a field is blank the print preview option blanks out the entire report?

I'm basically putting biographical info from a database on a report header:

(Name)

(Address)

(City) (State) (Zip)

(Home Phone)

(Cell Phone)

(Email)

If all of the fields have data it works perfectly, yet if a single field is blank, the entire report goes blank?  Any ideas?

[Former Member]

[János_at_SAP]

Hi

Check: in the database, probably the field values are not blank, not empty, just have null values inside.

Try this: Open the report -> Goto File-> Report options -> Set Convert Database NULL values to default.

This will replace nulls in the report with emptry string for nvachar types, 0 for numbers, etc.

I hope this helps,

János

[former_member205766]

Hi

Can you post the screen shot here?

Balaji