210 likes | 379 Views
Going Mainstream. Data Access Europe Nick Nikijuluw. Reporting & DataFlex. DFQuery Report Intelligent Query MReport FlexQL. WinQL Winprint Crystal Reports VDFQuery List & Label Virtual Print Engine Visual Report Writer Dynamic AI. Reporting, the Future. Dynamic AI
E N D
Going Mainstream Data Access Europe Nick Nikijuluw
Reporting & DataFlex DFQuery Report Intelligent Query MReport FlexQL WinQL Winprint Crystal Reports VDFQuery List & Label Virtual Print Engine Visual Report Writer Dynamic AI
Reporting, the Future • Dynamic AI • Visual Report Writer
Visual Report Writer • Release points • Version 1.2 - July 2010 • Version 1.3 - September 2010 • Version 1.4 - February 2011 • Version 1.5 - May 2011 • Version 2.0 - April 2012 • Version 2.1 - August 2012
What is in V2.1 • DataFlex and SQL Data • Full drag & drop design capabilities • Filter Expert & Function • Grouping, Sorting • Function Editor • VB-Like Syntax, Expressions, Statements, Built-in Functions • External Library Functions, Parameters
What is in V2.1 • Stored Procedures • Sub reports • Integration • Column, Data Source, Export • Filter, Function, Language • Parameter, Preview, Print • Progress, Report, Sort • Runtime Data Source • Create Report on RDS • Integrate with Visual DataFlex, sample
What’s next? • Visual Report Writer version 3.0 • Scheduled: 2nd quarter 2013 • Standard & Developer Edition • Enterprise Edition (New!)
What’s Next? • April 2013 • 2.1+ Library for V2.1 • 3.0 Alpha I – Developer (English/No Lib) • Q2 2013 • 3.0 Standard • 3.0 Developer • Q3 2013 • 3.0 Enterprise
Enterprise Edition • Security • Authorized access to reports • Viewer vs. Author • Productivity • Facilitate Centralization • Enhance re-usability • Reduce duplicity • Compliance • Activity Logging and Statistics • Versioning
Enterprise Edition • Centralized storage • Reports stored • Connections • Functions • Users/roles/rights • XML in/out
V3 project - Overview • Re-factoring • Performance, caching strategy • Allow for new functionality • General Maintainability • Usability – Enhancements, YAFR’s • New Features, New Edition • Fix Bugs • Web Framework Readiness
V3 New Features • Previous() and Next() functions • Size to font • Align to baseline • Printer-tray selection • Arrange Objects • Copy formatting • Distinct Count • Average summary type • New locking method • Suppress if zero • Change Data source • Interactive preview • Web Framework Preview • HTML, XLS/XLSX export • Gradients • Embed image in report • Function Editor improvements • Report Fields/summaries in editor • Status bar • Ellipses on clipped objects • Sum() functions
Interactive preview • New layout engine • Performance, caching • Page formatting (format once, cache) • More efficient execution of functions • Interactive Preview • Search in Preview • Events • Previewer, Integration
Version 3, New features • Export type • PDF (not new) • XLS Export, Data Only, Formatted • HTML based • Export (Single file, Multi file) • Web Preview (no file) • Web Forms • See Live demo’s here!
V3 – YAFR’s • Show ellipses • Suppress if zero • Size to font • Function Editor improvements • Align to baseline • Arrange Objects. • Copy formatting • Previous() and Next() functions • Sum() functions
V3 – New Features • Gradients • Embed image in report • Printer-tray selection. • Average (summary type) • New locking method. • Numeric masks (formatting functions). • Change Data source
Deployment • Reduce the number of components • No more dfapi30.dll • No more dynapdf.dll
Deployment • What you need • The Visual Report Writer OCX • VRW.db • Optional (if non English) • Df_collate.cfg • Language.db
Deployment • Setup.exe • Copy files • Set location • Registry free (?) • Web Deployment License
So… When? • April 2013 • 2.1+ Library for V2.1 • 3.0 Alpha I – Developer (English/No Lib) • Q2 2013 • 3.0 Standard • 3.0 Developer • Q3 2013 • 3.0 Enterprise
Questions/Comments? Thank you!