Join Curt Frye for an in-depth discussion in this video Exporting to Excel, part of Crystal Reports 2011 Essential Training.
Crystal Reports is a powerful analytical and data-summary tool. …That said, if you want to perform further analysis using Microsoft Excel, you can do …so by exporting your data to that program quickly. …When you want to export a ne file to Excel, display the file, and then on the File menu, point …to Export and then click Export Report. …Then, in the Export dialog box, click the format control and from the list that appears, click …Microsoft Excel (97-2003).…
The destination is a disk file. …We want to save it as an Excel workbook, so go ahead and click OK. …After you do, the Excel Format Options dialog box appears. …You probably won't need to change any of the settings in here. …What the program is asking is whether the column width should be based on objects in …the whole report, which means that Crystal Reports will export the data and it will …make sure that all of the data from individual columns fit into cells in your Excel workbook. …So, that won't be an issue. …You don't need to change that.…
Author
Released
5/31/2012- Navigating within a report
- Creating a report
- Linking to a data source
- Adding fields to a report
- Creating sections in a report
- Sorting, grouping, and summarizing data
- Applying a template
- Applying formats to date fields and other report controls
- Managing images and drawing objects
- Creating charts
- Selecting records
- Using formulas
- Adding subreports
- Working with cross-tabs
- Exporting report data
Skill Level Beginner
Duration
Views
Related Courses
-
Excel 2010 Essential Training
with Bob Flisser6h 21m Beginner -
Access 2010: Shortcuts
with Alicia Katz Pollock3h 43m Intermediate
-
Introduction
-
Welcome1m 6s
-
Using the exercise files1m 1s
-
-
1. Getting to Know Crystal Reports 2011
-
Setting program options2m 45s
-
Setting report options2m 1s
-
Changing page layout2m 48s
-
2. Creating a Report
-
Linking to a data source2m 26s
-
Adding fields to a report2m 15s
-
Saving a report3m 9s
-
3. Managing Report Sections
-
Creating a section1m 42s
-
Resizing a report section1m 25s
-
Merging report sections1m 42s
-
Managing section order1m 52s
-
Hiding report sections2m 15s
-
Deleting a section1m 28s
-
-
4. Sorting and Grouping Data
-
Sorting data3m 30s
-
Defining a group2m 29s
-
Changing group options3m 17s
-
Creating a summary2m 55s
-
Creating a drill-down report2m 40s
-
Sorting by group2m 19s
-
-
5. Formatting Reports and Report Elements
-
Applying a report template1m 52s
-
Formatting a report control3m 16s
-
Highlighting records6m 12s
-
-
6. Adding Charts to a Report
-
Creating a chart2m 25s
-
Formatting chart elements4m 10s
-
7. Selecting Records in a Report
-
8. Managing Reports Using Parameter Fields
-
Allowing dynamic parameters3m 55s
-
9. Summarizing Data Using Formulas
-
Using functions in formulas2m 56s
-
Correcting formula errors3m 11s
-
10. Adding Subreports
-
Creating a linked subreport3m 29s
-
Formatting subreports3m 50s
-
11. Summarizing Data Using Cross-Tabs
-
Formatting a cross-tab3m 21s
-
12. Exporting Report Data
-
Exporting to Excel2m 32s
-
-
Conclusion
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Exporting to Excel