Course Details
Course Outline
1 - Creating Running Totals
Topic A: Create a Running Total FieldTopic B: Modify a Running Total FieldTopic C: Create a Manual Running Total
2 - Working with Cross-Tabs
Topic A: Create a Cross-Tab ReportTopic B: Format a Cross-Tab ReportTopic C: Create Groups in Cross-Tab Reports
3 - Adding Subreports
Topic A: Insert a SubreportTopic B: Edit a SubreportTopic C: Share Variables
4 - Creating Drill-Downs in a Report
Topic A: Create a Drill-DownTopic B: Create Headings for Drill-Down Data
5 - Using SQL Statements in Report Processing
Topic A: Create a Report Using SQL QueriesTopic B: Summarize Report DataTopic C: Create Joins Using SQLTopic D: Create SubqueriesTopic E: Create an SQL Expression Field
6 - Creating Complex Formulas
Topic A: Work with LoopsTopic B: Work with Arrays
7 - Adding Charts to Reports
Topic A: Create ChartsTopic B: Create a Chart with Drill-DownTopic C: Create a Top N ChartTopic D: Create a Cross-Tab ChartTopic E: Create Charts for Grouped DataTopic F: Format a ChartTopic G: Create a Chart Template
8 - Enhancing Report Functionality
Topic A: Organize Data Based on a HierarchyTopic B: Create a Dynamic ImageTopic C: Create a Report AlertTopic D: Create a Geographic Map
9 - Appendix
Appendix A: Managing ReportsAppendix B: Processing Data on the ServerAppendix C: Detecting and Fixing Problems
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience.
Prerequisites