Hi guys, sorry for not paying attention on that when I was somehow involved with it but... what is Imo using for reporting, is there anything bundled in it or not really?
I've just fooled around with it a bit and made up something to start the engine from progress for a graphical report preview, and the data in of course coming through the abl jdbc driver ;)
It's not yet complete as it was more a proof of concept but I'll get there eventually.
True, we only did the same but using Crystal Reports. The only main difference in our approach is that we start from an XML as datasource for the report instead of a JDBC connection.
Using a XML as datasource gives us the opportunity to generate the report from on Thin-client (if this will be a requirement in the future). In our current application, we're using X-Print to generate our invoices.
Since there are some issues, we've decided that we need to look to other tools to generate reports.
Like Roland also suggested, maybe we can share our experiences in this area.
Well, as I've said even with Crystal Reports from version XI there is an option to use JDBC drivers and instead of having the business logic export the XML on which you design the report and at run-time you change the data source to get the xml through a appsrv call you can do it by simply exposing the business logic as a 'stored procedure' and you have the same data output at design-time and run-time only that data is passed as result-set, dataset instead of being serialized/deserialized using XML.
Hi Marian,
not really. There is a wrapper for Crystal, but that's from some time ago. At the moment we're creating a .Net Crystal wrapper for Intris as part of their imo extensions. Maybe they will share this with the imo community when finished.
But of course we're always open for suggestions!
just had a chat with Andrei and he mentioned Crystal which does make sense for a .net interface.
Well, I'm not really in a position to make suggestions but I wonder if reporting on XML output is the only solution (even when using Crystal)... I'm playing with a JDBC solution that expose business logic services as 'stored procedure', maybe something similar can be made for ODBC as well.
re: reporting
Hi Marian,
There is an imo/crystalreports directory but I can't say what its usage is. We (I mean the company where I am employed) are not using it.
True, you're more familiar
True,
you're more familiar with Jasper Report :)
I've just fooled around with it a bit and made up something to start the engine from progress for a graphical report preview, and the data in of course coming through the abl jdbc driver ;)
It's not yet complete as it was more a proof of concept but I'll get there eventually.
Hi Marian, True, we only did
Hi Marian,
True, we only did the same but using Crystal Reports. The only main difference in our approach is that we start from an XML as datasource for the report instead of a JDBC connection.
Using a XML as datasource gives us the opportunity to generate the report from on Thin-client (if this will be a requirement in the future). In our current application, we're using X-Print to generate our invoices.
Since there are some issues, we've decided that we need to look to other tools to generate reports.
Like Roland also suggested, maybe we can share our experiences in this area.
CR JDBC
Well, as I've said even with Crystal Reports from version XI there is an option to use JDBC drivers and instead of having the business logic export the XML on which you design the report and at run-time you change the data source to get the xml through a appsrv call you can do it by simply exposing the business logic as a 'stored procedure' and you have the same data output at design-time and run-time only that data is passed as result-set, dataset instead of being serialized/deserialized using XML.
Reporting
Hi Marian,
not really. There is a wrapper for Crystal, but that's from some time ago. At the moment we're creating a .Net Crystal wrapper for Intris as part of their imo extensions. Maybe they will share this with the imo community when finished.
But of course we're always open for suggestions!
business logic to xml?
Thanks Roland,
just had a chat with Andrei and he mentioned Crystal which does make sense for a .net interface.
Well, I'm not really in a position to make suggestions but I wonder if reporting on XML output is the only solution (even when using Crystal)... I'm playing with a JDBC solution that expose business logic services as 'stored procedure', maybe something similar can be made for ODBC as well.