In this movie we're going to do a quick Course Overview of what's included in Crystal XI for Beginners. Right out of the gate we come out swinging as it were. We're going to create a basic report. This is going to walk you through step-by-step and as you do, hopefully, you will learn. In this first chapter, Create a Basic Report, we're going to learn how to connect to various data sources. We're also going to get to know our data source as well as three Report Wizards, including Tables, Fields, and Grouping and Filtering. Next, we get into Designing the basics our report. This includes the Crystal work area, Grouping, Filtering, inserting Summaries, Previewing and Exporting reports. Chapter 4 we kind of circle back and we create a report beyond the normal basics. We delve deeper into the Reporting Wizards as well deeper in Grouping Data, Inserting Summaries, and understanding Fields Dimensions and Metrics as well as more Select Export and Export activities. In Chapters 5 and 6 we design our report beyond the basics. We talk about all the options, the Grids, the Layouts, the Colors, Fonts, and Borders that are available to you. Also, we include Charts, Graphs, Special Field options, some design tips from an old pro. In Chapter 7 and 8 we delve deeper into Fields, Dimensions, and Metrics that we have a good fundamental understanding. This also includes how to create your own fields without having to depend on them being already pre-populated in the database table. Chapter 9 we'll discuss Filtering Data using AND, OR, or a combination thereof in what's known a your Where Clause. In Chapter 10 we review the Report Templates that come with Crystal Reports. These are the kind of layout and design options that you can choose from if you find them useful. In Chapter 11 we talk about modifying an existing report. Many times a report just needs to be tweaked slightly, or fields rearranged, or a field added. I'll show you how to do that in this lesson. In Chapter 12 we discuss the Cross Tab Reports, which is a great way to create a very quick report on the fly. One of the most common questions I get while I'm in Crystal also has to do with its Exports to Excel. So in this chapter we spend a great deal of time explaining the ins and outs as a majority of Crystal Reports end up in Excel. We give you the tips and the design features, if you will, that will help you with this goal in mind. From there it's a simple wrap up. Lots of hands-on activities, assignments, and kind of show you how to do something. I find this approach works a little bit better than just going through any, let's say, the Edit or File Menu and explaining what every single option does. We try and base this on a goal. We're trying to create reports and we need them to do certain things, and based on those assignments, we go through the features that we need to arrive at that point. Well, gear up. Next chapter we're going to be creating a basic report.
| Course: | Crystal Reports XI: Beginner |
| Author: | Kurt Dunlap |
| SKU: | 33966 |
| ISBN: | 1-935320-29-7 |
| Release Date: | 2009-02-10 |
| Duration: | 6.5 hrs / 95 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |