AdvancedReporting-LaserficheSupport.ppt

Agenda -Introduction -Reporting Capabilities in Laserfiche -Third Party Tool: SQL Reporting Services -Lab Purpose To extract useful data out of the Laserfiche database in real-time To utilize statistics on productivity of users in Laserfiche to help your organization To take advantage of the power and flexibility of SQL Reporting Services Basic Laserfiche Reports Reporting in Audit Trail 8 New Architecture – distinct from LF Server Standard tabular reports New Bar and Line Charts Why use a Third Party Tool? Utility as an extension of Laserfiche to provide more custom reporting capabilities Report on Additional LF Tables Predefined Reports in Real-time Audit Trail requires access to Audit data, which might be restricted Enhanced Laserfiche Reports SQL Reporting Services Licensed with SQL 2005, so many of you are already licensed Easy to use with trademark Microsoft applications look feel Works with Oracle and other ODBC databases as well Report generation accessible to anyone in organization through Web Browser Prerequisites Laserfiche 7 or 8, Windows 2003, and SQL 2005. Visual Studio 2005 “Lite” included with SQL 2005 to develop reports templates Good handle on SQL queries – do not make updates to tables!!! Knowledge of a few key Laserfiche tables/views: TOC, TSTR, TD tables, AUDITS (Version 7) Objectives of Exercises Learn how to create SQL queries using Laserfiche tables Learn how to generate graphical reports such as bar graphs, line graphs, and pie charts Learn how to publish reports to Reports Server Exercises Background Accounts Payables Workflow using Invoices Exercise Report 1 Exercise Report 2 Exercise Report 3 Exercise Report 4 Exercise Report 5 Lab The heading should be in bold in 28pt font. The content should be in regular Arial in 24pt. The heading should be in bold in 28pt font. The content should be in regular Arial in 24pt. The heading should be in bold in 28pt font. The content should be in regular Arial in 24pt. Use this page