Crystal Reports Training

Infoshare is the largest tech community in CEE and the organizer of the leading tech conference in Gdańsk. It connects startups, investors, corporations, and innovation enthusiasts. It promotes entrepreneurship, knowledge sharing, and networking. Through events, competitions, and programs, it supports the development of the tech ecosystem in Poland and the region.

Crystal Reports is an advanced programming tool that allows for creating complex queries directed at databases and presenting the obtained results in graphical form. The versatility and accuracy of reports generated using databases based on Crystal Reports are unmatched. With them, data analysis in your company will reach a whole new level. The Crystal Reports mechanism allows for comparing virtually all information by creating advanced queries to the database. With CR, you can easily analyze details regarding offered products, quantitative and qualitative changes in customer profiles, as well as conversion results resulting from individual advertising campaigns.

• For analysts, managers, and even board members.
• For accountants, logisticians, and freight forwarders.

• Acquire skills in using Crystal Reports, an advanced programming tool for creating complex queries to databases and presenting results in graphical form.
• Master the technique of formatting appearance, numbers, and dates, as well as filtering records and groups, and parameterizing queries, which includes creating and customizing parameters and parameter types.
• Familiarize with methods of sorting records, grouping data, creating custom groups, and aggregation, including report summary and group summary, as well as using aggregate functions.

• You will learn to configure the work environment, create reports, select data sources such as tables, views, and stored procedures, and work with fields from the database and text fields.
• You will start managing report sections. You will gain knowledge about creating formulas, numerical, text, date functions, and working with cross-tab tables and charts, including formatting cross-tab tables and charts.
• You will master the application of running totals, defining rules, and techniques for publishing reports, including printing and exporting reports.

1. INTRODUCTION
    • principle of operation
    • preview and design mode
    • environment configuration

2. CREATING A REPORT
    • data sources
    • tables, views, stored procedures
    • fields from the database
    • text fields

3. FORMATTING
    • formatting appearance
    • formatting numbers and dates
    • form

4. FILTERING
    • filtering records
    • filtering groups

5. PARAMETERIZATION
    • creating a parameter
    • filtering based on a parameter
    • parameter types
    • customizing parameters

6. SORTING
    • sorting records

7. GROUPING
    • inserting groups
    • sorting groups
    • customizing group names
    • creating custom groups

8. AGGREGATIONS
    • report summary
    • group summary
    • aggregate functions

9. SECTIONS
    • standard sections
    • formatting sections
    • hiding sections
    • creating a custom section

10. FORMULAS
     • creating a formula
     • numerical, text, date functions

11. CROSS-TAB TABLES
     • inserting a cross-tab table
     • formatting a cross-tab table
     • grouping in a cross-tab table

12. CHARTS
     • chart based on grouping
     • chart based on cross-tab table
     • advanced chart
     • chart formatting

13. RUNNING TOTALS
     • inserting a running total
     • defining rules
     • application of running totals

14. PUBLISHING
     • printing the report
     • exporting the report

16h/2 days