RE: Any report writer suggestions?

The original, and still in use at dozens of my clients:

https://www.fortra.com/product-lines/sequel


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Troy Hyde
Sent: Thursday, July 25, 2024 4:04 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Any report writer suggestions?

For more than 40 years we've been using (mostly) RPG to create reports for our clients who have their data on the System 36, AS400, iSeries, and now IBM i midrange servers.

As the data becomes more accessible (via ODBC & etc), many of our clients are using various tools such as Microsoft's Power BI to create some of their own reports, charts, Internet dashboards & etc.

We are now hoping to find a tool (open source or otherwise) that will allow non-programmers to create reports that can be run against the IBM i data. It would need to be able to not only access the straight data but also utilize SQL procedures and functions we provide for complex calculations. We would want to be able to write reports that our clients can run but also allow them to write their own reports. A Wysiwyg editor would be the ideal.

I'm just beginning to look at this but two products that pique my interest are JasperReports and Crystal Reports. I'm sure there are myriad others.

Any recommendations based on experience from the group? Would either of the two meet the needs I've described? Are there better products available?

Vendors comments welcome.

Thanks, Troy
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.