1652835 - Combine Fields in a Formula where some Fields are Null.

•  No data, when combining two fields in crystal reports.

 Crystal Reports (All Versions)

1. Create a Crystal Report, with three text fields.
2. Give Null values to some fields. 
3. Create the following formula to combine three fields. 

{Field 1} + {Field 2} + {Field 3}

4. Place formula in detail section.

 

This is default behavior of Crystal Reports

Do the following to get desired results with the formula :

1. Open the formula. 
2. Select drop down box ‘Exception For Null’ and select ‘Default values for Null. 
3. Save the formula.

Or

1. Insert a Text field on report.
2. Place the three fields with a Space after field.
3. Then right click on text box, select format and check suppress embedded field blank lines 

 Combine blank fields, blank fields, no data in crystal reports , KBA , BI-RA-CR-DSL , Crystal Reports on Data Semantic Layer , How To