Crystal Reports Training

Nivå: Intermediate

Snittbetyg: 4,68/5 Based on 75 Reviews

In this hands-on Crystal Reports course, you will learn to create sophisticated reports from the ground up and transform raw data into meaningful information. You will gain the knowledge and skills to link multiple data sources and create effective presentations using Crystal Reports. After this training course, you will return to your organisation with a detailed process to help you retrieve and format data, create meaningful reports for widespread distribution, and integrate your reports with a website or application, such as .NET.

Page Sections

You Will Learn How To

Utbildningar

Innehåll och datum

FAQs

Relaterade kurser

Börja här

Nyckelfunktioner:

After-course instructor coaching benefit
Learning Tree end-of-course exam included

Du kommer lära dig att:

Develop reports to transform data into meaningful information
Create advanced graphical and crosstab reports
Add calculations and program logic with the Formula Workshop
Connect to data sources and extract data to meet reporting needs

Välj den utbildningsform som passar dig bäst

LIVE, LÄRARLEDD

I klass & Live, Online-utbildning

After-course instructor coaching benefit
Learning Tree end-of-course exam included

Klicka här för kursinnehåll och datum

27950 SEK

Reservera din plats

PRODUCT #126

FÖRETAGSINTERN UTBILDNING

Teamträning

Använd denna eller någon annan utbildning i ditt företag
Fullskalig programutveckling
Levereras när, var och hur du vill
Blandade utbildningsmodellerSkräddarsytt innehåll
Coaching av ett expertteam

Anpassa kurs och innehåll efter teamets behov

Kontakta oss

Utveckla dig och ditt team med anpassade eller öppna kurser alternativt e-learning

Learning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på www.learningtree.se/priser .

I klass & Live, Online-utbildning

Timezone

Location

Date

Note: This course runs for 2 dagar *

*Events with the Partial Day Event clock icon run longer than normal but provide the convenience of half-day sessions.

25 - 26 jan 9:00 - 4:30 EST Ottawa / Online (AnyWare) Boka Din Kursplats
Kurser i USA/Kanada, när du deltar online via AnyWare går kursen 15:00-22:30 CET (svensk tid)

31 mar - 1 apr 9:00 - 4:30 EDT Herndon, VA / Online (AnyWare) Boka Din Kursplats
19 - 20 jul 9:00 - 4:30 EDT Ottawa / Online (AnyWare) Boka Din Kursplats

Kurs med startgaranti

När du ser symbolen för “Guaranteed to Run” vid ett kurstillfälle vet du att kursen blir av. Garanterat.

Partial Day Event

Learning Tree offers a flexible schedule program. If you cannot attend full day sessions, this option consists of four-hour sessions per day instead of the full-day session.

Crystal Reports Course Information

Recommended Experience
- Should be comfortable using Windows and working with a spreadsheet or word processor
- Experience working with formulas in a spreadsheet program
Which software is being used?
- This course cover the latest version of Crystal Reports 2016 and backwards compatible to 2008. Any new changes or additions in later versions will be identified so students will know exactly what is included in their Crystal Reports version.

Crystal Reports Course Outline

Overview of Crystal Reports
- Formatting and summarising data
- Filtering, sorting and grouping data
- Customising reports with business logic
- Connecting to SQL Server, Oracle and Access databases
The Crystal Report Writer
Writing a basic report
- Selecting a format
- Adding text and fields
- Connecting to remote data sources
- Configuring the reporting environment
Formatting and styling
- Tailoring sections within a report
- Designing fields for quality presentations
- Highlighting data with Highlight Expert
Linking Crystal Reports to Data
Connecting to popular data sources
- SQL Server
- Oracle
- Access
- Web logs
- XML
- Reporting from stored procedures and views
Establishing data connections
- Creating a connectivity checklist
- Configuring ODBC and OLE DB
- Integrating SQL commands in a report
Interpreting Structures and Retrieving Data
Navigating complex data
- Deciphering data structures
- Identifying data relationships
Gathering the right data
- Merging data from multiple tables
- Building business queries
Combining Powerful Report Techniques
Organising and summarising reports
- Sorting user sort control and grouping
- Summary and Rolling Total fields
Building advanced reports
- Embedding linked and unlinked subreports into reports
- Creating crosstab and drill-down reports
- Designing dynamic and cascading prompts
- Hyperlinking Reports and Multilingual Reports
- Achieving reusability with templates
Visualising complex data
- Simplifying data with charts and graphs
- Organising fields into sections
- Adding, merging, suppressing sections
Programming Data Functionality
Coding in formula language
- Working with variables and operators
- Deciphering formula syntax
- Adding and modifying formulas
- Calling and working with functions
Writing effective formulas
- Building if/then/else statements
- Converting and comparing data
- Debugging the code
- Employing the Formula Workshop
Converting to Basic Syntax
- Writing formulas with Basic Syntax
- Laying a foundation for complex reporting logic

Teamträning