1 - Creating Running Totals
Create a Running Total FieldModify a Running Total FieldCreate a Manual Running Total
2 - Working with Cross-Tabs
Create a Cross-Tab ReportFormat a Cross-Tab ReportCreate Groups in Cross-Tab Reports
3 - Adding Subreports
Insert a SubreportEdit a SubreportShare Variables
4 - Creating Drill-Downs in a Repor
Create a Drill-DownCreate Headings for Drill-Down Data
5 - Using SQL Statements in Report Processing
Create a Report Using SQL QueriesSummarize Report DataCreate Joins Using SQLCreate SubqueriesCreate an SQL Expression Field
6 - Creating Complex Formulas
Work with LoopsWork with Arrays
7 - Adding Charts to Reports
Create ChartsDrill Down to Chart DataCreate a Top N ChartCreate a Cross-Tab ChartCreate Charts for Grouped DataFormat a ChartCreate a Chart Template
8 - Enhancing Report Functionality
Organize Data Based on a HierarchyCreate a Dynamic ImageCreate a Report AlertCreate a Geographic Map
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
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.
To ensure your success, a knowledge of programming and/or SQL would also be helpful