Hands-On Crystal Reports

Frequently Asked Questions

What is this course about? In this course, you learn how to develop sophisticated reports using Crystal Reports, an industry-leading report-writing tool. You learn to connect to various corporate data sources, such as SQL Server, Oracle, Microsoft Access and XML files. You navigate these data storage systems, learn to find the information you need, and extract the data to produce sophisticated reports. You learn to publish these reports via the Internet and intranets. You also learn to integrate reports into custom applications. You return to your organization with a detailed checklist to help you connect to data sources and begin creating useful reports. Who will benefit from this course? This course is valuable for anyone involved in creating reports from stored data, including systems analysts, business analysts, data analysts, project managers who want custom reports, systems administrators who need to report on system logs, programmer analysts who need to integrate reports into custom applications, and Webmasters who want to publish reports to the Internet or intranets. What is Crystal Reports? Crystal Reports is a widespread, industry-leading report writer. It has an easy-to-use interface that allows users to build reports quickly, yet has enough depth to produce complex reports to satisfy advanced reporting needs. What if my organization is not using the latest version of Crystal Reports? This course uses Crystal Reports 2008 (also known as version 12). Crystal Reports 2008 provides several new and enhanced features; however, it is largely unchanged from previous versions. If you use versions 11, 10, 9 or 8 within your organization, this course will still be applicable. If you use Crystal Reports 7 or an earlier version, you will notice a greater change with version 12, but much of what you learn in this course will still apply. What are some of the new features in Crystal Reports 2008? New features within Crystal Reports 2008 include enhanced report parameters, a multilingual interface, CrystalReports.com integration, Flash integration, improved graphs and added calculation fields in the tabular report format. What background do I need? While no formal background is required, you should be comfortable using Windows and working with a spreadsheet or word processor. Experience working with formulas in a spreadsheet program is also helpful. How is this course beneficial for power users? As a power user, you learn how to access data and improve your ability to communicate with database experts. I am a systems administrator. Will this course be beneficial to me? Yes. Crystal Reports allows you to connect to non-traditional data sources, such as blogs and XML files, so you benefit from the ability to report on systems data. I am a Visual Basic programmer. How will this course benefit me? Crystal Reports is the most popular report writer used to display reports in Visual Basic applications. In this course, we show you how to display reports via Visual Basic 2005. Do I need to know about the databases I am working with before I take this course? No. In this course, you learn to read, navigate and create reports from a variety of databases. This knowledge enables you to create effective reports to display database information. What can I do with the reports I create? This course provides the knowledge and skills to deploy your report statically or dynamically in your environment. You learn how to deploy a report to a Web server, Crystal Enterprise (previously known as Report Application Server (RAS), and export the report to various formats such as PDF, Word and Excel. How much time is devoted to each topic? Content Hours Crystal Reports overview 0.5 Crystal Report Writer 8.0 Linking Crystal Reports to data 1.5 Interpreting structures and retrieving data 1.5 Combining powerful report techniques 3.0 Programming data functionality 4.0 Deploying reports to the Internet, intranets, Visual Basic and .NET 2.5 Times, including the workshops, are estimates; exact times may vary according to the needs of each class. What kinds of hands-on exercises are included in the course? The exercises you perform in class include: Developing a variety of reports Adding design and readability features Exploring data sources Establishing connections to databases Deploying reports to the Internet, intranets and custom applications Using formulas in a report What platform and software are used? You use Windows XP at your workstation. However, the course does not feature any specific operating system. The techniques learned in the course are applicable to any Windows platform. Throughout the exercises, you connect to SQL Server, Oracle, Microsoft Access, and blogs to report on data that you retrieve from these data sources. Will I learn to write formula language? Yes. Crystal formula language is a core topic in this course. You learn how to write formulas to add custom business logic to your reports. This course covers Crystal Decisions formula syntax and its new Basic syntax. What data sources can I report from using Crystal Reports? You can use Crystal Reports with relational databases (e.g., SQL Server, Oracle, Access), text files, Lotus Notes and Domino, blog files, and system administration log files. Does this course cover other Business Object (formerly Crystal Decisions) software products? Yes, this course explores the Crystal Reports Server (formally known as Crystal Enterprise) as a way of deploying reports. How does this course relate to other Learning Tree courses? If you would like to add reports to custom applications, you may be interested in Course 502, Programming with .NET: A Comprehensive Hands-On Introduction, which provides a comprehensive introduction to developing Windows applications with Visual Basic. If you would like to learn more about databases, you may be interested in these courses: 382, Relational Database Design, Tools and Techniques: Hands-On provides a comprehensive foundation for designing, building and working with relational databases, enabling you to understand and use commercially available relational DBMS products effectively 131, SQL Server 2005 Comprehensive Introduction: Hands-On provides a solid foundation and the practical skills needed to exploit the essential development and administrative tools of SQL Server 2005 534, Developing SQL Queries for SQL Server: Hands-On provides the skills to write robust, reliable and efficient SQL queries 532, SQL Server Transact-SQL® Programming: Hands-On teaches participants how to use the power of Transact-SQL to develop high-performance database applications 493, Oracle® PL/SQL Programming: Hands-On provides the skills to write PL/SQL programs to solve realistic business problems using Oracle's most strategic language 593, Oracle® Database 10g: A Comprehensive Hands-On Introduction provides a thorough introduction to the relational features of Oracle Database 10g used to create robust database applications

Crystal Reports is a registered trademark of Business Objects SA.