Sage ERP X3 V7 Allows you to create a Destination with an Export format of Excel 97-2000. Any Crystal report with a "Vector" to shade headers, for example, and where the header is in white font, does not expert the vector and, therefore, the user gets a white font they cannot see in Excel unless the reformat.

Sample steps:
1. Open BALAGEGRP.rpt (C:\SAGE\SAGEX3V6\X3V6\Folders\X3\REPORT\ENG)
2. Click and left click (multiselect) all the white headers. (BP, @tit1, etc.)
3. Now right click on any header and select “Format Objects…”.
4. Go to “Border” tab, and check “Background” checkbox.
5. Drop down list to the right of “Background”, and select “More”.
6. Type the following values in Red (0), Green (132) and Blue (105) text boxes.
7. Click “Ok” and “Ok” again.
8. Save the report. It´ll ask you about version issues, but it´s Ok.

Now, you can print Excel and it´ll show the green lin.

by: Frank B. | over a year ago | Reporting / BI