We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
Crystal Reports XI: Beginner Tutorials
Create a Basic Report / Report Wizard pt. 1 - Tables & Fields
Subtitles of the Movie (Crystal Reports XI: Beginner / Create a Basic Report / Report Wizard pt. 1 - Tables & Fields)
In this movie we're going to start to create a basic report using Crystal Reports XI. If you haven't already, go ahead and launch Crystal Reports. On the Start Page tab, you can either click on the Standard Report Wizard link, or click on the New Report Icon located in the top left-hand corner of your screen. After clicking on either of those you should get the Standard Report Creation Wizard Window. The very first step when creating a report using the Wizard is choosing the data you want to report on. What this means is, you're going to tell Crystal which database or data source you're going to connect to. In the previous lessons, we've shown you two methods of connecting to the data. In this case I'm going to leave it up to you. You can either ODBC Connect, or Direct Connect. For my purposes I'm going to ODBC Connect. I click on the ODBC icon and it pops up the ODBC drivers I've already pre-setup and installed on my machine. In this case I'm going to choose the Crystal XI Training and hit Next. Again, in this case as we've discussed before, the Test Database we're using doesn't require a user ID or password. As we can see, I have all my tables available for me here. Now, this is the part where we have to choose the tables that we're going to use. For now I'm going to choose the Employee Table. Go ahead and hit Next. This next window is where, after choosing the tables, you choose the exact fields you want to see. I can either choose them one at a time by highlighting them and clicking on the right-hand arrow. I can physically drag them over, or I can double-click them until they appear on the Fields to Display Window. I can also remove them the same way. If I want to choose All Fields, I simply hit the double arrow to the right, and if I was to remove all fields, I hit the double arrow to the left; in this case, let's go ahead and choose All Fields. There are also some functions we have here where we can browse the data by highlighting a Field and clicking Browse Data button. In this case we're looking at the EmployeeID Field, and this pops up a window giving me a list of all the values in those fields. So, if I click on First Name, and I click Browse Data it gives me all of the names in those fields. A word of caution: if your database contains millions or hundreds of thousands of records, this might take a while for Crystal to pull back. A lot of that, of course, will depend on your PC, the speed of your network connection, and the ability of your database server to process this request. You can also find a field if you have a large table with thousands of fields, which is within the realm of possibility, you can actually type in what you're looking for, hit Enter, and it will find and highlight it for you. Of course, your search string must be fairly on in order for it to return a result set. This is a usual feature if you're going to, of course, be working with tables with many, many fields and won't fit on the screen. In this case, the test database is a simple compilation of data and not too complex.
Tutorial Information
| 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 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
