O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learning SAP Crystal Reports 2011

Video Description

In this training course for SAP Crystal Reports 2011, veteran trainer Guy Vaccaro teaches you how to use this powerful enterprise-level business intelligence software. You will learn how to connect to your data sources, design reports, and distribute your reports as required. You start by learning the basics of creating a report - making a connection to a database, selecting your tables and views, adding fields, and finally, saving your report. From there, using audio and video training techniques in this computer based training course, Guy teaches you how to format your report, and deal with special field data such as dates, non-data items, and sorting your data. You will continue to learn the features of SAP Crystal Reports 2011 with subjects such as filtering your data, grouping reports together, and using paramaters. Finally, you will explore some more advanced features such as formula fields, using the report wizard, linking data tables, and distributing your report via email, Excel, and more. As a bonus, Guy has included a chapter on how to use the Workbench, included with Crystal Reports. By the conclusion of this video based training course for SAP Crystal Reports 2011, you will be fully capable of connecting to your data source, and creating rich, informative reports, and distributing these reports. Working files are included, to allow you to work alongside the author as he teaches you the software.

Download the working files for this course at: http://www.infiniteskills.com/01661

Table of Contents

  1. 01. In The Beginning
    1. What Will I Be Able To Do With Crystal Reports 00:04:34
    2. Quick Tour Of Crystal Reports Interface And Toolbars 00:05:08
    3. Making Use Of The Included Working Files 00:02:52
    4. Installing The Sample Databases Provided 00:05:00
    5. Changing The Datasource Of The Working Files 00:07:00
    6. About The Author 00:01:44
  2. 02. Setting Up A New Report
    1. Starting Crystal Reports And A New Report 00:03:43
    2. Setting Page Size Orientation For The Report 00:02:50
    3. Making A Connection To The Sample Access Databases 00:05:21
    4. Making A Connection To The Sample Excel Files 00:03:26
    5. Making A Connection To The Sample SQL Server Database 00:05:19
    6. Selecting The Correct Tables or Views 00:05:28
    7. Field Explorer And Sections Overview 00:05:39
    8. Adding And Removing Fields On The Report 00:05:19
    9. Field Masks And Column Header Control 00:03:29
    10. Browsing The Data Before Insertion 00:02:17
    11. Previewing The Report For The First Time 00:02:37
    12. Refreshing The Reports Data 00:02:55
    13. Saving The Report 00:02:56
    14. Saving The Report Without The Data 00:03:00
  3. 03. Report Navigation
    1. Paging Through The Report 00:02:11
    2. Searching For Text Within The Report 00:04:51
    3. Changing The Zoom In Preview And Design 00:02:53
    4. Using The Group Navigation Pane 00:02:27
  4. 04. Formatting The Report
    1. Moving And Resizing Objects On The Report 00:06:43
    2. Using The Guides And Other Alignment Options 00:03:38
    3. Snap To Grid Saves The Day 00:03:21
    4. Changing The Font Style, Size And Color 00:05:11
    5. Adding A Color Border Or Background To Controls 00:05:03
    6. Paragraph Settings 00:02:43
    7. Number Formatting For Numerical Data Fields 00:03:40
    8. Currency Formatting For Money Data Fields 00:03:56
    9. Date Formatting Options 00:04:41
    10. Using The Format Painter 00:04:06
    11. Adding A Hyperlink To A Field 00:05:29
    12. Lock The Format Size And Position Of An Object 00:02:12
    13. Default Font Formatting Options 00:04:24
    14. Default Data Formatting Options 00:04:27
    15. Background Colors 00:02:37
  5. 05. Using The Special Data Fields
    1. Adding Special Date Fields 00:05:27
    2. Inserting Page Numbers 00:04:12
    3. Adding The File Path To The Page Footer 00:01:34
    4. Report Author And Title Fields 00:02:31
    5. Of What Use Are The Remaining Special Fields 00:02:41
  6. 06. Adding Non Data Items To A Report
    1. Inserting And Editing Text Objects 00:03:11
    2. Format Options For A Text Object 00:06:11
    3. Adding A Horizontal Or Vertical Line 00:03:56
    4. Formatting A Line And Controlling Its Behaviour 00:05:29
    5. Adding And Formatting A Box 00:03:20
    6. Adding A Box That Crosses Section Boundaries 00:03:36
    7. Adding A Company Logo Or Other Image 00:04:32
    8. Adding Data Fields To Non Data Text Boxes 00:04:46
    9. Removing Non Data Items 00:01:46
  7. 07. Sorting Data
    1. How To Sort By A Field On The Report 00:03:18
    2. Sorting By More Than One Field 00:04:09
    3. Sorting By Fields NOT Visible On The Report 00:01:58
    4. Removing Sort Criteria 00:02:31
  8. 08. Filtering Report Data
    1. Filtering A Field By Existing Values 00:05:51
    2. Using The Different Comparison Operators With Text Fields 00:06:23
    3. Filtering The Data By Date Fields 00:06:37
    4. Filtering Numeric Fields 00:03:35
    5. Removing Filters From The Report 00:02:29
    6. Filtering By More Than One Field 00:04:09
    7. Multiple Field Criteria And/Or 00:04:40
    8. Using A Wildcard In Filter Criteria 00:05:03
    9. Filtering For Empty(NULL) Fields 00:04:10
  9. 09. Grouping Reports
    1. What Is Grouping 00:03:46
    2. How To Add A Group 00:03:26
    3. Formatting The Group Name 00:03:45
    4. Enhancing The Group Header 00:03:44
    5. Grouping A Report On Dates Or Time 00:02:41
    6. Creating Multiple Level Groups 00:06:33
    7. Removing A Group 00:01:41
    8. Changing The Group Sort Order 00:03:47
    9. Customizing Group Heading Labels 00:03:47
    10. Group Preview Options 00:05:40
    11. Specifying Your Own Groups 00:07:25
    12. Swapping The Data Field For A Group 00:03:28
  10. 10. Summarizing Data
    1. Inserting A Grand Total Field 00:06:40
    2. Insert A Sub Total Field 00:06:39
    3. The Effects Of Moving Summary Fields Within A Report 00:03:50
    4. Displaying Sub Totals As A Percentage Of Grand Totals 00:06:25
    5. Summary Fields Using Average Minimum Or Maximum 00:04:39
    6. Creating A Summary Report By Hiding Details 00:08:26
    7. Creating A Drilldown Report 00:03:51
    8. Refreshing A Drilldown Report 00:03:00
    9. Sorting Group Based On Summary Values Not Group Values 00:02:56
    10. Using Top Or Bottom N To Filter Summary Data 00:06:04
  11. 11. Using Parameters In Reports
    1. What Are Parameters 00:03:39
    2. Adding A Free Text Parameter Field 00:06:20
    3. Using A Text Parameter To Filter Data 00:06:32
    4. Number Parameter Fields For Filtering 00:05:35
    5. Date Fields Used In Parameters 00:05:15
    6. Creating And Using A Pick List Parameter 00:07:00
    7. Creating And Using A Dynamic Pick List 00:05:10
    8. Multiple Parameter Fields 00:07:11
    9. Deleting Parameter Fields 00:02:37
  12. 12. Formula Fields
    1. Creating A Formula To Enhance A Report 00:06:05
    2. Altering And Renaming A Formula Field 00:03:40
    3. Deleting A Formula Field 00:01:40
    4. Creating A Formula To Concatenate 00:06:15
    5. String Manipulation Formula In Action 00:08:58
    6. Date Formula In Action 00:07:18
    7. Calculating Age With Crystal Reports 00:04:41
    8. Sorting And Filtering With A Formula Field 00:03:33
    9. Using Formula Fields While Grouping 00:04:31
    10. Formula And Parameter Fields Working Together 00:09:11
    11. Conditions Within Formulas 00:05:28
    12. Using IF To Negate A NULL Concatenation 00:06:40
  13. 13. Section Formatting
    1. Report Header And Footer Options 00:06:11
    2. Formatting Options Of The Page Header And Footer 00:03:19
    3. Group Header And Footer Settings 00:04:07
    4. Details Section Formatting Including Multiple Columns 00:05:16
  14. 14. The Standard Report Wizard
    1. The Steps Involved In The Standard Report Wizard 00:05:47
    2. Editing A Report Generated By The Wizard 00:02:08
    3. Using The Report Templates On Your Own Reports 00:03:51
  15. 15. Data Table Linking
    1. Quick Overview Of Relational Databases 00:06:22
    2. Visual Linking In Crystal Reports 00:04:34
    3. Warning Watch For Cartesian Joins 00:04:40
    4. Link Types And Their Effect 00:06:35
    5. Removing Tables From A Report 00:02:53
  16. 16. Distributing The Report
    1. Choosing The Appropriate Export Format 00:07:28
    2. Export Directly To Email 00:04:20
    3. Exporting Data Into 2007/2010 Excel xlsx Format 00:03:29
    4. Exporting To The New Read Only Format To Protect Report Design 00:02:17
  17. 17. The Workbench
    1. Opening The Workbench 00:02:12
    2. Adding Projects And Reports To The Workbench 00:02:25
    3. Managing Reports Within The Workbench 00:03:32