1 / 16

SYSPRO Reporting Services

SYSPRO Reporting Services. Presenter : Kevin Dherman. Agenda. Enterprise Reporting Why did we do it? Architectural considerations A little deeper Features Benefits Deployment Prerequisites. Enterprise Reporting. SYSPRO Analytics. SYSPRO Reporting Services. SYSPRO Executive View.

iorwen
Download Presentation

SYSPRO Reporting Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. SYSPRO Reporting Services Presenter : Kevin Dherman

  2. Agenda • Enterprise Reporting • Why did we do it? • Architectural considerations • A little deeper • Features • Benefits • Deployment • Prerequisites

  3. Enterprise Reporting SYSPRO Analytics SYSPRO Reporting Services SYSPRO Executive View Out of the box solution Enterprise Reporting Data origin SYSPRO Database SQL Servers ODBC Compliant data sources Database SQL C-ISAM SQL Server Disparate Application SQL Server Disparate Application

  4. SYSPRO Reporting Services SYSPRO Reporting Services (SRS) is the next-generation reporting system planned to replace all standard reports within the SYSPRO ERP business solution Next Generation World Class

  5. Crystal Reports • It’s a report writing tool • Available versions of Crystal:- • Crystal Reports Standard • Crystal Reports Professional • Crystal Reports Developer • Crystal Reports Server • What release of Crystal are we using? • Crystal Reports XI Developer.

  6. Why did we do it? • Three reasons…… • Current reports are very 80’s style • SYSPRO 7.0 field sizes • Customization • Also • Word Printing… limited potential.

  7. Architectural considerations • Must work on Windows and UNIX • Uses SYSPRO business objects to derive data – does not target database directly • Uses XML as data transfer mechanism SYSPRO Reporting Services provides future-proof report customization.

  8. A little deeper – Standard reports SYSPRO Reporting Services Server Engine Business Object Data Layer Client SYSPRO Reporting Services SYSPRO Reporting Services Client Engine Server Reports deployed from the server No Crystal runtime on the server XML Report Report

  9. Features • Customized run-time options • Complete control of run-time form • Simplify/remove/rename controls • Add new functionality/add controls • Output Options Tab • Themes • Email • Export – PDF, XLS, RTF, RPT, HTML • Preview • Save report options (very useful!) – Demo...

  10. Features • Customized report layout • Enhanced sorting • Exception highlighting • Calculations • Themes for corporate “look and feel” • Schedule reports • Archive reports • Paperless office.

  11. Features • Report Preview • Zoom, navigate etc as expected • Export to PDF, RPT, XML, HTML, XLS • Filters and Searches • Stationery documents • Can be used to output PDF, email etc • Classic format, Word and SRS formats.

  12. Benefits • Out of the box solution • Lower cost of ownership • Development • Reduce development time • Preserve development costs • 3rd party development tools • Boardroom quality • Increase productivity • Run reports while continuing to work.

  13. Prerequisites • Windows • XP Professional • 2000 Professional or Server • 2003 Server • .NET Framework 2.0 • Java Runtime • Windows Installer • Resources • Memory (recommendations soon).

  14. Deployment • Deployment managed by installation process • Each client machine has to be updated • An updated runtime will be deployed at the same time • Latest SYSPRO self healing components deployed • SYSPRO 6.0 Issue 010 • Initially between 50-100 reports use SRS • More during Issue 010 weekly ports • SYSPRO 7.0 • All reports use SYSPRO Reporting Services • Support larger field sizes • All Stationery documents (that have Word Printing).

  15. Note… • Browse05.XML • if modified base\settings must be done again • Uninstall prior versions of SRS or evaluation versions of Issue 010.

  16. SYSPRO Simplifying your success

More Related