Reporting utility

Posted by ezequielmontoya on 25-May-2016 14:06

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?

All Replies

Posted by Marco Mendoza on 25-May-2016 14:36

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.

Posted by Thomas Mercer-Hursh on 25-May-2016 15:45

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

Very rich

Posted by smat-consulting on 25-May-2016 16:11

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)

Posted by danielStafford on 25-May-2016 16:54

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

Posted by pauldownie on 25-May-2016 17:09

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.

Posted by Mike Fechner on 25-May-2016 17:16

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

Posted by smat-consulting on 25-May-2016 17:24

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... :|

Posted by ke@iap.de on 26-May-2016 02:40

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.

Posted by marian.edu on 26-May-2016 03:02

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:
- DataPA (https://datapa.com)
- Cyberscience (https://www.cyberscience.com)
- IAP Viper (http://www.tools4progress.com/viper)
- Combit List & Labels (https://www.combit.net & http://www.taste-consulting.de/openedgelistlabeldataprovider/)

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

Posted by Alon Blich on 26-May-2016 07:50

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...

Posted by goo on 06-Jun-2016 11:50

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.

 

Posted by marian.edu on 07-Jun-2016 01:50

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.


This thread is closed