Crystal Reports 2011

Video description

In this SAP Crystal Reports 2011 Training Video, 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.

Table of contents

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

Product information

  • Title: Crystal Reports 2011
  • Author(s):
  • Release date: November 2011
  • Publisher(s): Infinite Skills
  • ISBN: 9781926873732