Reporting utility - Forum - OpenEdge General - Progress Community
 Forum

Reporting utility

  • Hello, we are looking for a reporting solution, an we have just found this page http://www.4gl.fr/products.html

    Does anyone know their "VPXPrint" (http://www.4gl.fr/vpxpage.html), or any of their products?

    Ezequiel Montoya
    Lima - Perú
  • I used vpxprint long time ago, +10years, and worked fine; was not expensive product and the support was good.

    Other options are Pdfinclude www.oehive.org/pdfinclude, docxfactory   www.oehive.org/.../docxfactory.

    Other options, with webspeed, directly to Html nice formatted.

  • Newer version of DocxFactory at http://docxfactory.com/

    Very rich

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com

  • Just am going through the same issue - for the last year or so! Horrible! There used to be Report Builder, and Actuate, and several others, as much as I remember. Now PSC basically leaves it up to us to fend for ourselves. :(

    pdf-include is a great tool to create pdf files. But it is cumbersome - there seems to be no right-adjusted output, for example. drawing and writing uses a different measurement (pixels vs. columns?), so if you want to draw a line you first have to try to figure out where the heck on the page you are to place it. However, for forms it is amazing how easy it still is to get something really nice-looking together. pdf-include is something for programmers - every document is an able program, which needs to be compiled.

    I haven't used docxfactory.

    Was just evaluating YellowFin. An amazing tool! Except, since it is all browser based, you can't really produce paper-printable reports or forms. If your users are ok with having the data only displayed (older folks tend to want to kill trees and print everything), YellowFin has some great features. The big disadvantage with that is, though, it's using SQL to get at the data. If you've ever done anything in SQL you'll know how retarded that approach is! Plus the constant problem of SQL widths needing to be re-calculated. YellowFin has a good idea by having the developer define "view"s of the data. That way you can plug together typical data-sets the end-users want, rather than requiring them to be able to read an ER digram and understand all the intricacies of your data-model.

    Crystal Reports used to have some way to get at it from within progress. That seems gone. They have a java-runtime and a vb runtime. VB is useless, as it means you can't deploy your app on unix. Java runtime package is so badly built (or was 1/2 year ago when I looked at it), that it ws not possible for me to get it to even simply start up! Missing jar files galore...

    Well, my friend, if you need printable reports, see if docxfactory does it. Otherwise, I wish you good luck!!!

    BTW, I'm in the process of getting a system together to allow users to define their reports, and have them generated dynamically. But, this is highly complex - not even sure if I'm going to be able to make it work reasonably well. Also, it might requires a really good data-model and consistency in naming your fields and tables. And, given that dynamic stuff takes significantly longer than static, I'm not sure if the performance would be sufficient for your situation (my application is browser based, and all reports and larger processes are executed by a batch-process, which sends an email with the result - so performance is not such a big issue for us)

    Thomas Hutegger

    tmh@smat-consulting.com

    SMAT-Tools - Web-Apps with RollBase simpleness, ABL flexibility and power

  • I recommend www.combit.net/.../

  • Didn't Progress bring back a reporting tool with Analytics360? I watched a pretty splashy demo that left me wondering if it actually did any of the more mundane stuff but apparently it does.

  • Especially with www.combit.net/.../

    Architect of the SmartComponent Library and WinKit

    Consultingwerk Ltd.

  • docxfactory and combit.net are ms based. Useless when you want your app to run on unix, and/or service apple users.

    I watched a demo presentation of Analytics360. Looks a lot like yellowFin. Didn't see how regular reports are done. Licensing seems geared towards sites that use all the fancy stuff. If you simply want printable reports, it seems too expensive... :|

    Thomas Hutegger

    tmh@smat-consulting.com

    SMAT-Tools - Web-Apps with RollBase simpleness, ABL flexibility and power

  • Would like to throw Viper in the auditorium :)

    www.tools4progress.com/.../

    To be honest it is from my company :)

    And for using Word as template editor DocxFactory from Alon Blich is great.

  • We will probably have a session dedicated to reporting solutions at EMEA PUG Challenge this year so make sure you book your place - http://www.pugchallenge.eu

    This is what we know so far:

    Progress Analytics 360 uses Logi Analytics for the reporting part (http://www.logianalytics.com) but that’s more a turn key solution for data warehouse with ETL, databases schema and predefined reports included.

    Other options in the SQL world: Crystal Reports, Business Objects, Tableau, YellowFin on commercial side and a bunch of Java based reporting engines on the open source side: Birt, Jasper Reports, Pentaho.

    MS$ solutions works with ODBC while Java based engines usually work with JDBC, Progress/Data Direct provides drivers for both ODBC/JDBC only those have to talk with the SQL engine not the regular 4GL database engine we use most of the time hence the pain with sql-width, update statistics… 

    (shameless plug follow) 
    Not a ms$ guy myself so can’t help on the ODBC side but for JDBC we have a full driver talking with the 4GL engine over the appserver, full crud data access with added benefit of being able to call business logic and pass back temp-table/dataset, full meta-data support so one can define views/stored procedures and implement those in good old 4GL - http://acorn.ro/products/abl-jdbc/ 
     
    Marian Edu

    Acorn IT 
    +40 740 036 212

  • docxfactory works on unix/linux/osx etc.

    let me know if you need a hand with the setup.

    disclosure: i wrote the project

    ps new version coming soon...

  • What about Telerik Reporting ?? I thought that we suddenly would have a new reportingtool within OpenEdge… or is that totally wrong?
     
    //Geir Otto
     
    Fra: marian.edu [mailto:bounce-marianedu@community.progress.com]
    Sendt: torsdag 26
    . mai 2016 10.04
    Til: TU.OE.General@community.progress.com
    Emne: RE: [Technical Users - OE General] Reporting utility
     
    Update from Progress Community
     

    We will probably have a session dedicated to reporting solutions at EMEA PUG Challenge this year so make sure you book your place - http://www.pugchallenge.eu

     
    This is what we know so far:
     
    Progress Analytics 360 uses Logi Analytics for the reporting part (http://www.logianalytics.com) but that’s more a turn key solution for data warehouse with ETL, databases schema and predefined reports included.
     
    Other options in the SQL world: Crystal Reports, Business Objects, Tableau, YellowFin on commercial side and a bunch of Java based reporting engines on the open source side: Birt, Jasper Reports, Pentaho.
     
    MS$ solutions works with ODBC while Java based engines usually work with JDBC, Progress/Data Direct provides drivers for both ODBC/JDBC only those have to talk with the SQL engine not the regular 4GL database engine we use most of the time hence the pain with sql-width, update statistics… 
     
    (shameless plug follow) 
    Not a ms$ guy myself so can’t help on the ODBC side but for JDBC we have a full driver talking with the 4GL engine over the appserver, full crud data access with added benefit of being able to call business logic and pass back temp-table/dataset, full meta-data support so one can define views/stored procedures and implement those in good old 4GL - http://acorn.ro/products/abl-jdbc/ 
     
    Marian Edu
     
    Acorn IT 
    +40 740 036 212
     

    View online

     

    You received this notification because you subscribed to the forum.  To unsubscribe from only this thread, go here.

    Flag this post as spam/abuse.

     
  • If Windows is your world that could be an option, it’s .Net based so should be easily integrated in OE.NET but the data source is still SQL/ODBC/ADO.NET.