The Seagate Crystal Report Wizard in Excel offers familiar Crystal layout and selection screens to help you create a report from your spreadsheet. You can select a range of cells, or an entire data range in a spreadsheet to use as your report content.
Note: When you create a report from an Excel spreadsheet, Seagate Crystal Reports creates a database file (.mdb). This file, the Excel spreadsheet file (.xls), and the report file itself (.rpt) cannot be moved or you'll lose the links between them and won't be able to refresh your report data later.
If your spreadsheet has unsaved data, Excel warns you to save before running the Wizard.
Clicking the button minimizes the Wizard so you can click
Note: To select an entire data range in the spreadsheet, click Expand the selected range automatically.
The Seagate Crystal Report Wizard appears.
Note: As you design your report, the program creates a database file (.mdb). The database file, the spreadsheet file (.xls), and the resulting report file (.rpt) cannot be moved or you won't be able to refresh your report data later.
The arrow buttons on this dialog box enable you to move fields from one list to the other. Single arrows move only the selected field; double arrows move all fields at the same time.
When a group field is selected, you can choose a sorting order from the Sort Order box.
Summarized fields apply to the group specified in the For the Group box. You can use the same fields in each of several different groups.
When a summary field is selected, you can choose a summary type for it and add a grand total.
You can select Sort All Groups, or you can specify a Top or Bottom N.
Define your record selection by selecting from the box of limiting operators and entering the appropriate field value.
The Preview option opens the report in the ActiveX viewer. You can view, print, and refresh the report in the viewer.
The Edit and Analyze options open the report in the appropriate program. You can view, print, refresh, and modify the report while using all the capabilities of Seagate Crystal Reports or Seagate Analysis.
The View Later option saves the report with the name you gave it to the directory you specified.
Now that your report has been created, you can use it and modify it as you would any other report in Seagate Crystal Reports. It remains linked to your Excel spreadsheet so if you refresh the report after altering the spreadsheet, your changed data is displayed (see About the Microsoft Excel Add
Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com |