I think extraction is a good suggestion. Rather than trying to get the jBase environment to look relational to SQL-based tools there is some value to moving the data out to another near-line RDBMS data store simply for reporting purposes. There's no shame to using jBase as your OLTP / transactional server and another platform for OLAP reporting and BI. There's elegance in doing everything from the same platform but it's not a mandate and many companies use data repositories for reporting as a matter of course anyway for performance and to avoid anomalies which occur when reporting on a live environment.
In addition to this, Telerik has an Excellent reporting tool which allows end-users to design their own reports. For some time now I've had a commercial offering in the works built around this which operates directly on MultiValue (jBase) data, allowing for drag/drop adhoc reporting by end-users without involving IT staff. I simply haven't had the time to finish it. It works and it's very cool but it's still not quite ready for deployment as a finished product. (If anyone wants to discuss this for a large number of users I would be much more motivated to finish it...) Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD..com Nebula R&D sells mv.NET worldwide And provides related development services http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms https://bitbucket.org/foss4mv On Tuesday, January 14, 2014 9:59 AM, Lior yissar wrote: Hello, First of all I would consider extracting the data from jBase and store it in a RDBMS (SQL Server, Oracle, MySQL, etc.) There are many more tools that allow running report on these data-bases, plus it allows you all the advantages and features of a modern RDBMS. Secondly, there are many Data Warehouse / BI Tools as well as reporting out there. Microsoft has SSRS and Oracle has OBI (Oracle Business Intelligence). There are also free tools like BIRT & Jasper (both open source Java projects). Good luck :) On Sunday, January 12, 2014 10:25:21 PM UTC, Ken Brown wrote: Does anyone have experience of third party software for report writing from a jBase database? > >In particular, integration of Crystal reports on jBase? > > >Thanks > >Ken Brown > -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
