Symptom
-
How to export a number and a string value for same column to Excel.
-
Exporting multiple data type on a single column.
Environment
-
Crystal Reports 2008
-
SAP Crystal Reports 2011
Resolution
- Insert the database field e.g. field1 on the report on which value returned must be number and if it is a NULL return NA.
- Create a formula @test which has the same database field as: {field1}
- Right click on the field object.
- Select Format Field…
- Under Common tab go to X-2 of Suppress.
- Add the suppression formula as:
If isnull({field1}) then “NA”; - Save and close the formula editor. Click OK.
- Right click on the formula object.
- Select Format Field…
- Under Common tab go to X-2 of Suppress.
- Add the suppression formula as:
If not (isnull({field1})) then {@test}; - Save and close the formula editor. Click OK.
- Place both the field and the formula field such that, they overlap.
Keywords
Export to Excel string and number value, Multiple data type on same field , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2001 V1