Reporting & Query - Technical
How to Register: Contact Amy Arra at aarra@pwrplan.com or (770) 937-3028.
When: August 22-23, 2012 (8:30 am Aug. 22 – Noon Aug. 23)
Where: PowerPlan Training Center (Atlanta Office) Atlanta, Georgia
Registration Fee: $900
CPE Credit: 12 hours in the Computer Science field of study
Intended Audience:
Technical Support and Technically Inclined Users.
Description:
This session will cover the PowerPlant Reporting system from a technical point of view, emphasizing the report maintenance functions, the development or modification of reports, and the resolution of reporting problems.
Topics include:
- Query Structure
- Standard Queries
- “Querying Any Table”
- PowerPlant Reports Maintenance
- PowerPlant Reports Table Fields
- How Reports are Controlled
- Modifying or Creating an Entry in the PowerPlant Reports Table
- Top Level Reports vs. Detail Level Reports
- Report Filtering
- Types of Filters
- Requirements for a Report to be able to be Filtered
- Input Arguments
- Dealing with Time Arguments, Subtotaling, etc.
- Other Report Features
- Dynamic Subtotaling
- Using Trees
- Reporting Window
- Usage Tips
- Dynamic SQL Modification
- Display of Report SQ
- Saving Reports in Different Formats
- Report Libraries
- Modifying Existing Reports
- Integrating a New Report into PowerPlant
- Finding Duplicate Reports
- Testing and Debugging the Report in the Development and Production Environments
- Deploying the Report in the PowerPlant Executable
- Efficiency Issues
- Security Issues
- Execution Options
- Online
- Double Threading
- Batch
Instructors: Luis Kramarz and Alex Pivoshenko
