Crystal Reports 2008 Training Bundle Training Video

Courses For Success

Course

Online

£ 114.42 + VAT

*Indicative price

Original amount in AUD:

$ 219

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Crystal Reports 2008 Training Bundle Training Video A Practical Crystal Reports Training Course That Teaches Real World Skills In this project-based Crystal Reports 2008 Training Bundle video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this Crystal Reports 2008 Training Bundle Training Video course to get: Concise, informative and broadcast-quality Crystal Reports 2008 Training Bundle training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Crystal Reports 2008 Training Bundle subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Crystal Reports 2008 Training Bundle tutorial, online or offline...so you'll know the exact steps for your own projects. Course Fast Facts: Only 914 hours to complete this course 237 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description  This Crystal Reports 2008 Training Bundle, you will get the beginners Crystal Reports 2008 training course, as well as the advanced Crystal Reports 2008 training course. In the Crystal Reports 2008 Training Bundle Training Video, expert author Guy Vaccaro teaches you the basics of creating reports in Crystal Reports 2008.  Covering topics ranging from importing your text based, excel based, or SQL based data, to creating the report and formatting the report, you will get the base knowledge you need to continue to the advanced training.  In the advanced video training course, Guy...

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

System Requirements - DVD and Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do...

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Options
  • Crystal Reports
  • Database
  • SQL
  • Database training
  • Export
  • MS Excel
  • Skills and Training

Course programme

01. Crystal Reports 2008 Fundamentals - Getting Started
  • What To Expect From Crystal Reports
  • Opening And Viewing Different Crystal Report Types
  • Tour Of The Crystal Reports Interface
  • Crystal Reports Toolbars
  • What Will I Be Able To Do?
  • What To Expect From Crystal Reports
  • Opening And Viewing Different Crystal Report Types
  • Tour Of The Crystal Reports Interface
  • Crystal Reports Toolbars
  • What Will I Be Able To Do?
  • 02. Crystal Reports 2008 Fundamentals - Setting Up A New Report
    • Starting The Report Creation Process
    • Setting The Page Size/Orientation For The Report
    • Making A Connection To An Access Database
    • Making A Connection To An Excel File
    • Making A Connection To A SQL Server Database
    • Selecting The Correct Tables/Views
    • The Sections Of A Report
    • Adding Fields To The Report
    • Removing Fields From A Report
    • Field Masks And Column Header Control
    • Browsing The Data Before Insertion
    • Previewing The Report For The First Time
    • Refreshing The Data
    • Saving The Report
    • Saving The Report With The Data
    • Creating A New Report - The Whole Process
    • Setting Up A User DSN
    • Changing A Reports Data Source
  • 03. Crystal Reports 2008 Fundamentals - Report Navigation
    • Paging Through The Report
    • Searching For Text Within The Report
    • Group Navigation
    • Changing The Zoom In Preview And Design Mode
  • 04. Crystal Reports 2008 Fundamentals - Formatting The Report
    • Selecting Objects For Formatting Or Resizing
    • Moving Objects
    • Resizing Objects
    • Using The Guides
    • Using The Grid
    • Changing The Font Style, Size And Colour Part 1
    • Changing The Font Style, Size And Colour Part 2
    • Adding A Colour Border Or Background To Controls
    • Adding A Hyperlink To A Control
    • Changing The Paragraph Settings
    • Number Formatting For Numerical Data Fields
    • Currency Formatting For Money Data Fields
    • Date Formatting For Date Data Fields
    • Using The Format Painter
    • Aligning And Resizing Multiple Controls On A Report
    • Setting Default Formatting For Reports
    • Editing The Layout Default Options
  • 05. Crystal Reports 2008 Fundamentals - Using The Special Data Fields
    • Adding Data Date And Data Time Fields
    • Using The Print Date And Print Time Fields
    • Inserting Page Numbering
    • Adding The File Path To The Page Footer
    • Overview Of The Remaining Special Fields
  • 06. Crystal Reports 2008 Fundamentals - Adding Non Data Items To A Report
    • Inserting And Editing Text Objects
    • Format Options For A Text Box
    • Adding Labels To Special Fields
    • Adding A Horizontal Line
    • Adding A Vertical Line
    • Formatting A Line
    • Controlling A Lines Behaviour
    • Controlling A Lines Position
    • Adding A Box
    • Adding A Box That Crosses Section Boundaries
    • Formatting A Box
    • Controlling A Box's Behaviour
    • Controlling The Size And Position Of A Box
    • Adding A Company Logo Or Other Image
    • Removing A Non Data Item
  • 07. Crystal Reports 2008 Fundamentals - Sorting Data In A Report
    • How To Sort By A Field On The Report
    • Sorting By More Than One Field
    • Sorting By Data Fields Not Visible On The Report
    • Removing Or Changing The Sort Criteria
  • 08. Crystal Reports 2008 Fundamentals - Filtering The Data That A Report Is Using
    • The Basics Of Filtering The Data
    • Filtering A Field By Existing Values
    • Filtering A Field By More Than One Value
    • Filtering The Data By Dates
    • Filtering Numeric Fields
    • Filtering Field Criteria Using And
    • Filtering Field Criteria Using Or
    • Editing Filters With The Select Expert
    • Removing Filters From The Report
    • Other Text Data Field Filter Options
    • Filtering For Nulls
    • Using A Wildcard In Filter Criteria
  • 09. Crystal Reports 2008 Fundamentals - Reporting By Groups
    • Understanding Grouping
    • How To Add A Group
    • Group Labels And Headings
    • Creating A Multiple Level Group
    • Removing A Group
    • Changing The Group Sort Order
    • Changing The Group Name That Is Displayed
    • Group Preview Options
    • Utilizing The Group Tree Navigation Panel
    • Specifying Your Own Groups
    • Swapping The Data Field For A Group
  • 10. Crystal Reports 2008 Fundamentals - Summarizing Data
    • Insert A Grand Total Field
    • Insert A Sub Total Field
    • Moving Summary Fields Within The Report
    • Displaying Sub Totals As A Percentage Of Grand Totals
    • Summary Fields Using Average, Min Or Max
    • Creating A Summary Report By Hiding Details
    • Creating A Drilldown Report
    • Refreshing A Drilldown Report
    • Sorting A Group With Summary Fields
    • Using Top N To Filter Summary Data
    • Creating A Top 10 List Of Products
  • 11. Crystal Reports 2008 Fundamentals - Using Parameters In Reports
    • The Benefits Of Using Parameters
    • How To Add A Free Text Parameter Field
    • Using A String Parameter To Filter Data Records
    • Using A Numeric Parameter To Filter Data Records
    • Using A Date Parameter To Filter Data Records
    • Using A Parameter Field With Wildcards
    • Creating And Using A Pick List Parameter Field
    • Creating A Dynamic Pick List
    • Deleting A Parameter Field
    • Controlling The Request Order For Parameters
    • The Parameter View Panel
  • 12. Crystal Reports 2008 Fundamentals - Formula Fields
    • How To Create Your Own Fields
    • A Basic Formula To Enhance The Report
    • Altering Or Renaming A Formula Field
    • Deleting A Formula
    • Creating A Formula To Concatenate Part 1
    • Creating A Formula To Concatenate Part 2
    • String Manipulation Formulas In Action
    • Date Formulas At Their Best
    • Calculating Age With Crystal Reports
    • Using Formula Fields In The Sort Expert And The Select Expert
    • Using Formula Fields While Grouping
    • Making The Formula Field Work With If And Else
    • Converting Datetime To Date Format To Improve Parameters
    • Creating An Address Formula With Carriage Returns
  • 13. Crystal Reports 2008 Fundamentals - Section Formatting
    • The Report Header And Report Footer Options
    • Exploring The Formatting Options Of The Page Header And Footer
    • The Details Section Expert
    • How To Add A Watermark To A Report
    • Improving Headings In Drilldowns Using The Section Expert
  • 14. Crystal Reports 2008 Fundamentals - The Standard Report Wizard
    • The Steps Involved In The Standard Report Wizard
    • The Report Template Expert
  • 15. Crystal Reports 2008 Fundamentals - Data Table Linking
    • Quick Overview Of Relational Databases
    • Visual Linking In Crystal Reports
    • How To Identify Key Fields
    • Link Types And Their Effects When Used
    • Removing Links And Tables From The Report
  • 16. Crystal Reports 2008 Fundamentals - Distributing The Report
    • Choosing Your Export Format
    • Export Directly To An Email
    • Export Directly To Microsoft Excel
    • Other Export Destinations
  • 17. Crystal Reports 2008 Fundamentals - The Workbench
    • Opening The Workbench
    • Adding Projects To The Workbench
    • Managing Your Reports Using The Workbench
    • Removing Reports From The Workbench
  • 18. Crystal Reports 2008 Fundamentals - Credits And Beyond
    • About The Author
    • Using The Files Included With This Course
    • Further Practice Part 1
    • Further Practice Part 2
    • What's Next?
  • 01. Crystal Reports 2008 Advanced - Before We Start
    • What Will I Be Able To Do At The End Of This Course
    • 0102 Using The Files Included With This Course
    • 0103 Installing The SQL Server Sample Databases
    • 0104 About The Author
  • 02. Crystal Reports 2008 Advanced - Getting Up To Speed
    • Creating A Report From Scratch
    • Adding And Linking Additional Database Tables
    • Creating A Formula Field
    • Sorting Data Within A Report
    • Grouping Reports
    • Adding Summary Functions
    • Filtering Data In The Report
    • Swapping The Data-source Of A Report
  • 03. Crystal Reports 2008 Advanced - Conditional Formatting
    • Using The Highlighting Expert
    • Changing The Order That Conditions Are Met
    • Removing Highlighting Expert Conditions
    • Applying ON/OFF Conditional Formatting
    • Removing Conditional ON/OFF Formatting
    • Font Color Controlled By A Condition
    • Font Style Controlled By A Condition
    • Removing Or Disabling Conditional Formatting
    • Clever Conditional Formatting Alternating Page Numbers
    • Clever Conditional Formatting Banded Report
  • 04. Crystal Reports 2008 Advanced - Advanced Formulas Using Variables
    • 0401 Declaring Variables To Use In Reports
    • 0402 Understanding The Multiple Pass Report Generation
    • 0403 Making Use Of Multi-Pass In A Report
    • 0404 Using And Outputting Multiple Variables At Once
    • 0405 Using Variables In Multiple Formulas And Locations
    • 0406 Creating And Using User Defined Functions
  • 05. Crystal Reports 2008 Advanced - SQL And Commands
    • 0501 Standard Query Language (SQL)
    • 0502 Defining Your Own SQL As The Data Source
    • 0503 Adding Parameters To Your Own SQL Statement
  • 06. Crystal Reports 2008 Advanced - Parameter Fields
    • 0601 Creating A Parameter Field And Using It To Filter Data
    • 0602 Parameter Fields To Customize Formatting
    • 0603 Letting The User Change The Color Of Banded Reports
    • 0604 Parameter Controlled Sort Order
    • 0605 Making Use Of Masks In Parameters
  • 07. Crystal Reports 2008 Advanced - Report Alerts
    • 0701 Adding An Alert To A Report
    • 0702 Triggering A Report Alert
    • 0703 Viewing Record Sets Created By Alerts
    • 0704 Add A Formula To Generate The Alert Message
    • 0705 Using A Parameter Value With A Report Alert
  • 08. Crystal Reports 2008 Advanced - Multiple Sections
    • 0801 Inserting Extra Sections By Dividing Existing Sections
    • 0802 Deleting And Merging Sections
    • 0803 Splitting Existing Content Between Sections
    • 0804 Moving A Sections Position In A Report
    • 0805 Uses For Multiple Page Header Footer Sections
    • 0806 Multiple Sections Can Provide Column Headings In Drilldown Reports
    • 0807 Adding Continued To Page Heading When Required
  • 09. Crystal Reports 2008 Advanced - Sub Reports
    • 0901 What Is A Sub Report
    • 0902 Creating And Importing An Unlinked Sub Report
    • 0903 Create And Insert A Linked Sub Report
    • 0904 On Demand Sub Reports
    • 0905 Hiding Sub Reports That Contain No Data
    • 0906 Dealing With Overlapping Sub Reports
    • 0907 Methods For Updating Changes Made To The Sub Report
    • 0908 Pass Data Between Sub And Main Report Using Variables
  • 10. Crystal Reports 2008 Advanced - Cross Tabs
    • 1001 Adding A Cross Tab To A Report
    • 1002 Cross Tabs Within Group Headers Or Footers
    • 1003 Generating A Month Name Instead Of A Number
    • 1004 Making Use Of Formulas In Cross Tabs
    • 1005 Utilizing A Parameter Field To Control A Cross Tab
    • 1006 Formatting A Cross Tab And Its Components
    • 1007 Turning On And Off Totals
    • 1008 Change The Calculation Between The Rows And Columns
    • 1009 Placing More Than One Cross Tab On A Report
    • 1010 Sorting A Crosstab By The Summarized Data
    • 1011 Insert Multiple Rows And Or Columns
    • 1012 Use The Step By Step Crosstab Wizard
  • 11. Crystal Reports 2008 Advanced - Charting
    • 1101 Creating A Chart
    • 1102 Changing The Chart Type
    • 1103 Formatting And Renaming The Chart Labels
    • 1104 Customize The Appearance Of A Given Chart
    • 1105 Sorting And Top N In Charts
    • 1106 Placing Charts Within Group Headers Or Footers
    • 1107 Managing Multiple Charts In A Report
    • 1108 A Special Case The Pie Chart
    • 1109 Charts Based On Cross Tabs
  • 12. Crystal Reports 2008 Advanced - Crystal Reports Reader And Automated Report Distributor
    • 1201 Downloading The Reader And The Automated Report Distributor
    • 1202 Installing The Reader And The Distributor (CRD)
    • 1203 Report Viewer File Management
    • 1204 Running Reports In The Viewer
    • 1205 Exporting Data From The Reader
    • 1206 Filtering Data With The Reader
    • 1207 Setup And Configure CRD
    • 1208 Create A Simple Single Report Daily Schedule

Additional information

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download purchase?

Once you complete your purchase, you will receive an email with an Access Key, and instructions on how to download your purchase. You will enter that Access Key...

See related categories

Crystal Reports 2008 Training Bundle Training Video

£ 114.42 + VAT

*Indicative price

Original amount in AUD:

$ 219

The best SQL Server courses

See all

See all