Crystal Reports XI: Beginner

Visuel non disponible

Crystal is a user-friendly database reporting tool that allows users to visually create reports and change them to virtually any format imaginable. This allows users with little to no knowlege of SQL or databases to quickly create, distribute, and analyze reports from virtually any data source. In addition, the multiple export formats can ensure that your data can get from point A to point B in almost any format needed. This hands-on Crystal Reports XI: Beginner course by expert instructor Kurt Dunlap will teach you what is needed to start creating reports in Crystal XI right away. The source reports and test database are also provided so that users can follow along with ease. To begin learning today, simply click on the movie links.

Formateur : Kurt Dunlap
Enregistré sur PC | Langue: Anglais
Durée : 6h5 | Leçons: 95

Compatible Mac, Windows & iPad (en VOD)
143,52 € En stock

Acheter sur CD
ou DVD
Acheter des Crédits
pour Consultation
En savoir plus >>


TVA incluse, Hors Livraison 143,52 €

Accès à l'unité

Cette formation nécessite crédits

10 Crédits 10,00 € TTC commander
35 Crédits 30,00 € TTC commander
60 Crédits 50,00 € TTC commander
130 Crédits 100,00 € TTC commander

  • Create a Report Beyond the Basics

    • (04:40) Report Wizard pt. 3 - Multiple Tables
    • (05:52) Report Wizard pt. 4 - Multiple Filtering
    • (06:06) Grouping Data pt. 1
    • (04:18) Grouping Data pt. 2
    • (05:39) Inserting Summaries
    • (03:13) Fields - Dimensions vs. Metrics
    • (04:29) Select Expert
    • (03:34) Export Options

  • Design a Report Beyond the Basics 1

    • (02:33) Report Options
    • (04:48) Crystal Options pt. 1
    • (04:33) Crystal Options pt. 2
    • (05:52) Grids & Layout Options
    • (04:35) Section Expert
    • (06:39) Colors/Fonts/Borders

  • Design a Report Beyond the Basics 2

    • (05:46) Graphs & Charts pt. 1
    • (04:42) Graphs & Charts pt. 2
    • (06:25) Graphic Files
    • (05:35) Drawing Lines
    • (03:33) Field Options
    • (05:19) Special Fields
    • (05:39) Design Tips pt. 1
    • (05:17) Design Tips pt. 2
    • (03:07) Report Exercise 1
    • (06:33) Report Solution 1

  • Fields/Dimensions/Metrics 1

    • (03:52) Database Fields
    • (03:21) User Defined Fields
    • (03:47) The Formula Editor
    • (06:50) String Functions
    • (06:58) Date Funtions
    • (05:37) Metric Functions
    • (04:07) Conversion Functions
    • (01:07) Formula Problem 1
    • (05:56) Formula Solution 1 pt. 1
    • (02:35) Formula Solution 1 pt. 2

  • Fields/Dimensions/Metrics 2

    • (05:30) Modifying Fields - Two Methods
    • (04:24) Working with Dates
    • (04:39) Working with Strings
    • (04:20) Working with Numbers
    • (03:44) Conditional Formula Pitfalls
    • (01:14) Conditional Formula Problem 1
    • (04:27) Conditional Formula Solution 1 pt. 1
    • (02:42) Conditional Formula Solution 1 pt. 2

  • Filtering Data

    • (03:43) Select Expert Reintroduction
    • (03:51) The Formula Editor for Select Expert
    • (02:38) Filter Formulas pt. 1 - AND
    • (04:20) Filter Formulas pt. 2 - OR
    • (03:30) Filter Formulas pt. 3 - AND & OR
    • (05:35) Filters - Database vs. User Fields
    • (02:35) Select Statement Considerations
    • (01:35) Filter Formula Problem 1
    • (04:47) Filter Formula Solution 1

  • Report Templates

    • (03:03) Template Expert
    • (02:55) Templates Review
    • (02:02) Template Limitations
    • (03:25) Modifing Templates
    • (05:20) Exporting Template Reports

  • Modifying a Report

    • (03:19) Changing Groups
    • (03:00) Changing Fields
    • (02:55) The Database Expert - Adding Tables
    • (02:43) Database Changes pt. 1
    • (04:26) Database Changes pt. 2
    • (03:58) Report Performance
    • (02:13) Database Change Problem 1
    • (03:47) Database Change Solution 1

  • The Cross Tab Report

    • (05:18) Cross Tab pt. 1 - Layout
    • (02:53) Cross Tab pt. 2 - Functions
    • (04:48) Cross Tab pt. 3 - Options
    • (03:43) Cross Tab Formatting
    • (03:15) Cross Tab Limitations
    • (01:21) Cross Tab Problem 1
    • (04:05) Cross Tab Solution 1

  • Excel Export

    • (06:30) Preparing Reports for Excel
    • (04:05) Field Layout & Design
    • (04:25) Cross Tabs & Excel
    • (05:12) Exporting to Excel Options

  • Wrap Up

    • (01:09) Crystal Resources
    • (01:04) About the Author
Formateur : Kurt Dunlap
Langue : Anglais
Durée : 6h5
Nombre de séquences vidéo : 95 		SKU : 33966
Réf :
ISBN : 1-935320-29-7

Descriptif :

Crystal is a user-friendly database reporting tool that allows users to visually create reports and change them to virtually any format imaginable. This allows users with little to no knowlege of SQL or databases to quickly create, distribute, and analyze reports from virtually any data source. In addition, the multiple export formats can ensure that your data can get from point A to point B in almost any format needed. This hands-on Crystal Reports XI: Beginner course by expert instructor Kurt Dunlap will teach you what is needed to start creating reports in Crystal XI right away. The source reports and test database are also provided so that users can follow along with ease. To begin learning today, simply click on the movie links.




Kurt Dunlap

Kurt Dunlap is a veteran of database systems, reporting, and business intelligence. He has supported hundreds of database systems and created thousands of reports in North and South America. His work has spanned insdustries from banking to broadcasting to trasportaion, providing services for companies such as XM Sirius Satellite Radio, Televisa, Coinstar, KeyCorp, and Encoda Systems. Kurt currently works as a contractor for various businesses, helping them get the most out of thier operations and accounting systems, as well as training end users in either english or spanish. In his spare time, he helps insomiacs fall asleep by telling them about his day and/or the best way to optimize SQL statements.

Vous souhaitez recevoir l'aide d'un formateur expérimenté pour parfaire votre apprentissage ? C'est possible grâce a notre centre de formation accompagnée a distance.

Nouveaux Parcours

Tous les parcours »
  • Profitez de conseils personnalisés grâce a des entretiens téléphoniques réguliers avec votre formateur.
  • Confrontez-vous a la réalité des entreprises grâce aux exercices proposés pendant la formation.
  • Obtenez une Attestation de Formation Professionnelle.
  • Contactez-nous pour le financement de votre formation par votre OPCA.