Custom Report Writer Workshop

1
Custom Report Writer Workshop

• Fusion 08
• Steve Mannion

2
Creating Custom Reports

• Crystal Clear Designer
• ePace Object Model
• Report Folder Structure
• Create Custom Report
• Modify Standard Report
• Lab Exercise

3
Crystal Clear Designer

• Report Writer Tool
• Similar to Crystal Reports
• Written in Java
• Multi Platform

4
ePace Object Model

• Table Objects
• Field Objects
• Relationships (hand out)
• Object Model Browser

5
Report File Structure

• Standard Reports
• http//localhost/config/webapp/reports/
• Read only
• Good place to start
• User Defined Reports
• http//localhost/config/reports/
• Set up Network Place

6
Create Custom Report

• Install CC Designer
• Database Connection (linking tables)
• Sections
• Field Objects
• Headings
• Special Fields
• Groups
• Totals

7
Limiting Data on a Report

• Parameters
• Record Selection Formula

8
Deploying Reports

• User Defined Reports Folder
• ePace Report Front End

9
Modify Standard Report

• Get Copy of Standard Report
• Modify Report
• Deploy to Custom Folder

10
Questions and Answers