Crystal Reports Part 1 (Live Online)

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports® enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation.Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports helps you build advanced reports with ease, presenting complex information in an understandable way.Version NoteThis course is taught using Crystal Reports 2016 software. However, there are very, very few differences between the 2016 and the 2013 and 2011 versions. Our instructors have used all 3 versions and will be able to quickly highlight the several small changes to the user interface. Users of any of the 3 versions of Crystal Reports will have no problem learning in the 2016 software environment.Course ObjectivesIn this course, you will connect to a database to extract data and present it as a report.You will:Identify the elements of the Crystal Reports interface.Create and modify a basic report.Use formulas to calculate and filter data.Build a parameterized report.Group report data.Enhance a report.Create a report using data from an Excel workbook.Distribute data.Target StudentThis course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience.PrerequisitesBefore taking this course, learners should be familiar with basic computer functions, such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files in Microsoft® Windows®. In addition, learners should have taken the Microsoft® Office Access® 2016: Level 1 course or have equivalent experience with basic database concepts.Course ContentLesson 1: Exploring the Crystal Reports InterfaceTopic A: Explore Crystal ReportsTopic B: Use Crystal Reports HelpTopic C: Customize Report SettingsLesson 2: Working with ReportsTopic A: Create a ReportTopic B: Modify a ReportTopic C: Display Specific Report DataTopic D: Work with Report SectionsLesson 3: Using Formulas in ReportsTopic A: Create a FormulaTopic B: Edit a FormulaTopic C: Filter Data by Using a FormulaTopic D: Work with Advanced Formulas and FunctionsTopic E: Handle Null ValuesLesson 4: Building Parameterized ReportsTopic A: Create a Parameter FieldTopic B: Use a Range Parameter in a ReportTopic C: Create a PromptLesson 5: Grouping Report DataTopic A: Group Report DataTopic B: Modify a Group ReportTopic C: Group by Using ParametersTopic D: Create a Parameterized Top N ReportLesson 6: Enhancing a ReportTopic A: Format a ReportTopic B: Insert Objects in a ReportTopic C: Suppress Report SectionsTopic D: Use Report TemplatesLesson 7: Creating a Report from Excel DataTopic A: Create a Report Based on Excel DataTopic B: Modify a Report Generated from Excel DataTopic C: Update Data in a Report Based on Excel DataLesson 8: Distributing DataTopic A: Export DataTopic B: Create Mailing Labels