Crystal Reports Excel Exports

Deliver Excel Workbooks People Can Use.

Automate the workbook preparation that follows your Crystal report. Create group worksheets, name the tabs and apply workbook controls with CRD. All CRD functionality is included in your licence, with no paid feature add-ons.

Put report groups on separate worksheets.

Give each tab a meaningful name.

Use the Excel export mode your recipients need.

Prepare and deliver the workbook on a recurring schedule.

The Workbook Challenge

An Export Should Not Mean Another Rebuild.

Your report runs correctly, but the recipient still needs a workbook they can sort, reconcile or review. CRD brings the supported workbook options into the reporting job.

Groups Need Their Own Tabs

Departments and branches may need separate worksheets within one workbook.

The Structure Matters

Tab names, frozen panes and workbook protection affect how people use the file.

The Actual Data Must Survive

Dates, identifiers, leading zeros and totals need checking in the finished workbook.

Why Choose CRD

Create the Excel Workbook Your Recipients Need

Choose CRD for configured group worksheets and workbook controls around the recurring output your team has to deliver.

SAP Crystal Server

Excel Export and Extensions

SAP Crystal Server exports reports to Excel. Crystal Reports’ native Excel export does not split report groups into separate worksheets.

SAP also documents workbook merging through custom publication extensions. Compare that additional processing with the CRD settings needed for your workbook.

CRD

Workbook Preparation in the Reporting Job

Excel Group Bursting: put the report’s groups on separate worksheets in one workbook.

Meaningful tab names: identify the department, branch or group each sheet contains.

Workbook controls: configure supported freeze-pane and protection options.

Export modes: choose formatted XLS or data-only XLSX for the required result.

Related report outputs: use an applicable package workflow when several reports must become one workbook.

Excel Group Bursting and package functionality are included in your CRD licence at no additional feature cost.

A Departmental Workbook Ready for Review

For example, a finance team needs the same monthly report split into North, South and Central worksheets. CRD can prepare that workbook without a separate round of tab rebuilding.

Group

Start with a report containing the departmental groups.

Separate

Use Excel Group Bursting to create a worksheet for each group.

Name

Give the worksheets the names recipients use to find their department.

Deliver

Send the finished workbook to the required destination on schedule.

Start With the Workbook’s Purpose

Excel export modes produce different results. Choose the required structure first and verify it with your actual report.

✓

Preserve the Report Layout

Use formatted XLS when the exported report layout is the result you need.

✓

Prepare Data for Analysis

Use the supported data-only XLSX output when recipients need spreadsheet data for analysis.

✓

Create Group Worksheets

Use Excel Group Bursting for separate tabs from one grouped report. It is included in the CRD licence at no additional feature cost.

START FREE TRIAL BOOK A DEMO

A finished Excel workbook contains separate North, South and Central worksheets with meaningful tab names.

Keep the Workbook Preparation Repeatable

Bring the recurring workbook requirements into the configured reporting process.

Names and Workbook Controls

Customize supported worksheet names, freeze panes and protect the workbook so the delivered file suits the reader’s task.

Several Reports in One Workbook

Use the applicable package and merge settings when the workbook must contain outputs from several reports. Check the selected formats and final sheet structure.

Existing Workbook Output

Append to an existing XLSX workbook using the Single Schedule and Excel Workbook Data Only route. Check the target workbook and resulting output during evaluation.

A Database-to-Template Workflow

Use database data to fill an Excel template through an Automation workflow. This is separate from exporting an RPT file into an arbitrary template.

Yes. Excel Group Bursting can put groups from a Crystal report on separate worksheets in one workbook. Use a suitably grouped report and check the resulting sheets during evaluation. This functionality is included in your CRD licence at no additional feature cost.

No. Excel Group Bursting creates separate worksheets within one workbook. A Bursting Schedule creates separate report outputs for recipients.

Choose formatted XLS to preserve the report layout or supported data-only XLSX for spreadsheet analysis. Test the actual file, including totals, identifiers and formatting. Renaming an extension does not convert the file.

Yes, through applicable package and merge settings. Test the selected export modes and the resulting sheet order and structure; not every Excel mode behaves identically.

Use an Automation Schedule with an Export Data to a Report Custom Task and a database source. This is separate from exporting an arbitrary RPT file into any template.

Use a Single Schedule with Excel Workbook Data Only. Verify the target workbook and actual appended output with your report and installed configuration.