QAD Explore 2012 QAD Reporting Framework Jeffrey Steele

  • Slides: 15
Download presentation
QAD Explore 2012 QAD Reporting Framework Jeffrey Steele Software Engineer, QAD Inc.

QAD Explore 2012 QAD Reporting Framework Jeffrey Steele Software Engineer, QAD Inc.

QAD Reporting Framework Safe Harbor Statement The following is intended to outline QAD’s general

QAD Reporting Framework Safe Harbor Statement The following is intended to outline QAD’s general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, functional capabilities, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functional capabilities described for QAD’s products remains at the sole discretion of QAD. 2

QAD Reporting Framework What Do You Get With Reporting Framework? 3

QAD Reporting Framework What Do You Get With Reporting Framework? 3

QAD Reporting Framework Gorgeous Reports 4

QAD Reporting Framework Gorgeous Reports 4

QAD Reporting Framework Availability • Enterprise Edition - 2009 and later - 300 reports

QAD Reporting Framework Availability • Enterprise Edition - 2009 and later - 300 reports available with 2012 EE • These are now also available at the Store • store. qad. com – “report bundles” • Standard Edition - 2009 and later • Earlier releases available via a services engagement 5

QAD Reporting Framework What’s New • Additional bar codes (including 2 D) • Layouts

QAD Reporting Framework What’s New • Additional bar codes (including 2 D) • Layouts defined dynamically • Additional functions in designer - Currency rounding • Immediate service report server mode • Support for launching a QAD report from a character mode program • Configurable output file name and location • Report bursting and dynamic output routing • API enhancements 6

QAD Reporting Framework Architecture Report Layout Definition Pre. Render Engine Applies template Translates labels

QAD Reporting Framework Architecture Report Layout Definition Pre. Render Engine Applies template Translates labels Data Source Generic proxy (Progress program) Browses Financials API Report Render Engine Report Document viewer PDF EXCEL Printer 7

QAD Reporting Framework Architecture 8

QAD Reporting Framework Architecture 8

QAD Reporting Framework Report Server Architecture Document Service Windows Task Scheduler Fires at time

QAD Reporting Framework Report Server Architecture Document Service Windows Task Scheduler Fires at time intervals for each batch queue, daily, weekly, monthly Report Batch Processor Runs report in batch queue. For each report, queries data source and renders report Printer Document Service 9

QAD Reporting Framework Basic Workflow for Creating a Report Choose a report data source

QAD Reporting Framework Basic Workflow for Creating a Report Choose a report data source Create a report resource Create a report definition 10

QAD Reporting Framework What You’ll See • Running a report • Creation of a

QAD Reporting Framework What You’ll See • Running a report • Creation of a report - Elements available (bar codes) - VBscript examples - Script object (number to word) • • • Modification of a report Use of templates How to import / export a report Reporting service Some bursting examples 11

QAD Reporting Framework Demonstration 12

QAD Reporting Framework Demonstration 12

QAD Reporting Framework Questions & Answers Jeffrey Steele Software Engineer, QAD Inc. jqs@qad. com

QAD Reporting Framework Questions & Answers Jeffrey Steele Software Engineer, QAD Inc. jqs@qad. com 13

QAD Reporting Framework Next Steps • Get the Reporting Framework Source and Samples -

QAD Reporting Framework Next Steps • Get the Reporting Framework Source and Samples - http: //store. qad. com/content/reporting-frameworksource-samples 14

www. qad. com © QAD Inc 2012 15

www. qad. com © QAD Inc 2012 15