This topic is locked

Reporting services

1/4/2022 8:04:23 PM
ASPRunner.NET General questions
Pete K author

I'm at my wits end. I have a need for reporting features beyond what is available with the ASPR built-in Reports module. But everything I'm finding is complex and very expensive. Isn't there some open-source or low-cost solution for doing reporting in a webapp? I've looked at Crystal Reports, Jasper, and a few others but can't find anything affordable and easy to intergate into my webapps.

Any suggestions?

Sergey Kornilov admin 1/5/2022

I see some customers having success using Crystal Reports:
https://asprunner.com/forums/topic/28660-Crystal-Report

Pete K author 1/11/2022

Thanks for the reply. We looked at CR, and it is prohibitively expensive for our budget. I guess there aren't any inexpensive solutions.

Dalkeith 1/13/2022

If you can connect directly to the database Microsoft Access could be an option.. It has an extremely good report builder.

Microsoft also allows for distribution of a free runtime client. So you could buy one full version of ms access - design all the reports using that and then publish the database as a "executable" database and then distribute it to users who would open that using runtime clients installed on each of their machines..

Quite a bit of work but would be doable and probably would cost you the amount of a single ms access database licence.

Note there are some gotchas with MS Access and database backends.
Its sometimes not great with big int field types and also it doesn't like computed columns. It can throw a wobbly at some non standard date field types as well and that's with Microsoft's own SQL Server!!
If you were designing the application then you could head off those issues before distributing the reporting client.

Link to MS Access Runtime

When you can get it working the report writer is really flexible..

I would add not sure how you would integrate with Xlinesoft I'm sure with talent would be possible!