Velocity Report Real time reporting made easy Tired

Velocity. Report { Real time reporting made easy }

Tired of slow reporting solutions? � Slow to setup � Slow to build � Slow to run Patrick Talbot / Servoy Stuff Velocity. Report

Want to outgrow the competition? Patrick Talbot / Servoy Stuff Velocity. Report

Have you tried Velocity. Report yet? Patrick Talbot / Servoy Stuff Velocity. Report

Velocity. Report { Why is it better? }

Based on standards � XHTML, � CSS XML 2. 1 + CSS 3 @Page extensions � Servoy Java. Script � PDF � Google charts Patrick Talbot / Servoy Stuff Velocity. Report

Best of breed Open Source Java libraries � Powerful and EASY templates with Velocity � Preview and PDF rendering with xhtml. Renderer � Charting with Google charts or Eastwood/JFree. Chart � Barcode with Barcode 4 J � And a lot more… Patrick Talbot / Servoy Stuff Velocity. Report

The advantages of HTML � Easy to edit � Easy to style with CSS � Easy to add images/charts/barcodes � No need for specialized report designers � Can use any HTML editor � Flexible � The layout with tables and divs templates can be generated on the fly � Less memory overhead (lightweight text/xml) Patrick Talbot / Servoy Stuff Velocity. Report

Velocity. Report { The technology }

Velocity in 10 seconds �$ = any variables � ! = silent exceptions �. = object notation � #if � #elseif � #end � #foreach � #set � #include � #parse � #macro Patrick Talbot / Servoy Stuff Velocity. Report

Servoy Objects that can be used � In the Velocity context used to render a template, you can put: Foundsets � Records � Datasets � Arrays � Javascript Objects � Functions � Strings � Dates � media: /// images � Blob images (byte[]) � Primitives (integer, float, boolean) � Charts � Barcodes � Patrick Talbot / Servoy Stuff Velocity. Report

Helper objects � Helper objects (think Ro. R) are also auto-injected in the context and available in your templates: � $globals � $i 18 n � $date � $math � $number � $alternator � $plugin � $base. HREF � $htmlize. get() Patrick Talbot / Servoy Stuff or #h() macro Velocity. Report

Google charts vs Eastwood � Google charts � http: //chart. googleapis. com/chart? cht=bvg&chs=250 x 150&chd=s : Monkeys&chxt=x, y&chxs=0, ff 0000, 12, 0, lt|1, 0000 ff, 10, 1, lt � Web service API located on Google servers � Low DPI � Limited size for images (300, 000 total pixels) � Limited GET URL size � Now accept POST but with 16 k limit � Eastwood – uses JFree. Chart � Web service installed on Servoy server � No limit on images size � No limit on URL size (tomcat have 64 k limit for GET though) Patrick Talbot / Servoy Stuff Velocity. Report

Velocity. Report charts � var barcode = plugins. Velocity. Report. get. Chart( CHART. PIE, get. Pie. Chart. Def, true, REPORT. RESOLUTION_HIGH) ; function get. Pie. Chart. Def() { var chart. Def = {}; chart. Def. title = "i 18 n: piechart. title"; chart. Def. three. D = false; chart. Def. slices = [ {percent: 30, color: {percent: 25, color: {percent: 10, color: {percent: 20, color: ]; '#FF 0000', '#00 FF 00', '#0000 FF', '#FF 00 FF', '#00 FFFF', label: label: 'Thirty', legend: 'Thirty'}, 'Twenty-Five', legend: 'Twenty-Five'}, 'Fifteen', legend: 'Fifteen'}, 'Five', legend: 'Five'}, 'Twenty', legend: 'Twenty'} chart. Def. orientation = 45; chart. Def. margins = [10, 10, 30]; chart. Def. legend. Margins = [50, 10 ]; return chart. Def; } Patrick Talbot / Servoy Stuff Velocity. Report

Velocity. Report barcodes � var barcode = plugins. Velocity. Report. get. Barcode(barcode. Def); var barcode. Def = { data: "Servoy. Stuff", gray: true, type: BARCODE 128, height: 60, pattern: "______-_____!", module. Width: "0. 18 mm", wide. Factor: 3, format: "png", font. Size: 8, forced. Width: 225, forced. Height: 90, id: "barcode 1", font: 'Courier+New', resolution: REPORT. RESOLUTION_HIGH } Patrick Talbot / Servoy Stuff Velocity. Report

Demo time! Let’s have a look! Patrick Talbot / Servoy Stuff Velocity. Report

Velocity. Report on Servoy. Forge � � https: //www. servoyforge. net/projects/velocity-report � Version � Free 1. 3. 15 BSD License � svn: //svn. servoyforge. net/velocity-report/ Patrick Talbot / Servoy Stuff Velocity. Report

Velocity. Report editor { How to create/edit templates }

Velocity Report editors � Any HTML editor capable of XHTML output � Wysiwyg or text based. Patrick Talbot / Servoy Stuff Velocity. Report

A Servoy Velocity editor? � How about the Servoy. Html. Browser from the Browser. Suite right inside Servoy? Patrick Talbot / Servoy Stuff Velocity. Report

At runtime? � Patrick Talbot / Servoy Stuff Velocity. Report

Servoy. Html. Editor new capabilities � Adding custom buttons with browser-side Java. Script or callbacks to Servoy methods � In progress � Adding custom lists (dropdown) filled from Servoy values to insert variables � In progress � Adding � To come � Finding � pre-defined custom templates from Servoy a way to add and edit loops List of enhanced macros build up from Servoy callbacks? Patrick Talbot / Servoy Stuff Velocity. Report

Servoy. Html. Editor new capabilities � Custom buttons and lists in Tiny. MCE: Patrick Talbot / Servoy Stuff Velocity. Report

Servoy. Html. Editor new capabilities � Custom templates: Patrick Talbot / Servoy Stuff Velocity. Report

Servoy. Html. Editor new capabilities � Loops (wysiwyg edition? ) Patrick Talbot / Servoy Stuff Velocity. Report

Velocity. Report editor � If you are interested in a runtime report editor, I need your help! � Contact me: admin@servoy-stuff. net � Discuss on the Velocity. Report forum on Servoy. Forge: � https: //www. servoyforge. net/projects/velocity- report/boards Patrick Talbot / Servoy Stuff Velocity. Report