Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Crystal Reports - Advanced Techniques

Home

distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services



PCDBS08

Crystal Reports - Advanced Techniques
DURATION: 3 days

FEE: $1,185

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Business Professional
  • Programmer
  • Web Developer
  • Database Administrator
  • IT Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. Viewer Interaction with Parameter Fields
      • Process and use parameters fields with the Viewer.
      • Create parameter fields for the Viewer and use the parameter fields in record selection.
    2. Exporting Reports
      • Export data and reports into different file formats.
      • Export data to MS Excel and MS Access applications and an XML file.
    3. Reporting from SQL Databases
      • Process data from an SQL database using stored procedures.
      • Invoke SQL stored procedures and process the return resulttable.
    4. Create and use Business Views
      • Learn how to use Business Views Objects and Business View Manager.
      • Use Data Connection and Dynamic Data Objectives.
      • Manage reporting across multiple data sources and applications by simplifying data access, change management, and data-level security processes.
      • Integrate data from disparate sources and handle the promotion and demotion between development and production environments.
      • Learn how to control security at both the row and column level.
      • Build connections to multiple data sources, join tables, and alias field names.
      • Create calculated fields and then present this simplified structure as a Business View in Crystal Enterprise.
    5. Database Changes and Field Mapping
      • Understand processing logic when a database changes.
    6. Reporting from OLAP Cubes
      • Utilize a cube for accessing a multidimensional representation of business facts required to efficiently present data.
    7. Reporting from Proprietary Datatypes
      • Using XML data as the database, input the XML, display the information, and export the information as a report.
    8. Crystal Reports with ASP and ASP.NET
      • Learn how to interface ASP.NET with Crystal Reports.
      • Use ASP.NET for coding a web application which will display multiple reports.
    9. Crystal Reports with Java
      • Interface Java applications or applets with Crystal Reports.
      • Use Java for coding a web application which displays multiple reports, including reports with parameters supplied by the user.
    10. Crystal Enterprise
      • Develop reports using multi-tier reporting methods.
      • Develop reports using the Crystal Enterprise Multitier Reporting Method.
    11. Crystal Launchpad and Web Desktop
      • Navigate the Crystal Enterprise Launchpad.
      • Connect to the web desktop, navigate to the appropriate location, and select a series of reports for viewing.
      • Organize the web desktop.
    12. Administering Crystal Enterprise
      • Learn how to configure Crystal Enterprise.
      • Configure the system for alert notification which will be sent to the user who has exceeded the threshold statistic.
    13. Report Designer Component
      • Learn how to use the RCD: Report Designer Component for creating reports in Visual Basic.
      • Use Visual Studio for invoking the RCD to create a detail listing, summary report, and chart for the supplied database.
    14. Subreports
      • Create linked sub reports and linking based on formula fields.
      • Create sub reports based on formulas and allow the Viewer to drill-down the reports.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.