As many of you may know, KReport was once a part of older versions of SuiteCRM but has since been removed. I’m reaching out to discuss the potential of reviving and enhancing KReport as an add-on plugin for SuiteCRM 7.x and 8.x versions.
The goal is to build an advanced, feature-rich KReport plugin that integrates seamlessly into SuiteCRM, offering users powerful reporting capabilities. Our vision includes:
Enhanced reporting features: Improving the overall user interface and experience for generating and customizing reports.
Advanced Charts & Maps: Integrating interactive and visually appealing charts and maps, powered by Google APIs for better data visualization.
Backend improvements: Strengthening the integration of data sources, report generation, and the handling of large datasets.
We are looking for collaborators to help develop this add-on, enhance its features, and ensure it is fully compatible with both SuiteCRM 7.x and 8.x versions. If you have experience with SuiteCRM, reporting tools, or working with Google APIs for charts and maps, your contributions will be invaluable.
Would anyone be interested in collaborating on this exciting project and contributing to the development of the KReport add-on for SuiteCRM? I look forward to hearing from you!
KReport was great. I still run Version 3.x in my Suite 7.14.x with minimal compatibility changes. I could give you theses small changes, but they are really not that big.
Yes. I am running PHP8.2. Are you on github? I could invite you to my private Repo. Do not want to make it public because of course I do not want to distribute KReports.
can you share some screenshots of the best parts of Kreport?
Other folks here suggest that Google Charts can be a better route to reporting - but I personally have not tried that.
My company did use Kreports on Suite - maybe 5 years back, but I can’t remember how useful the reports were.
The Google Chart option under the “Visualize” section in Kreport is a great feature, allowing you to create various chart types such as Area, Stepped Area, Bar, Column, Line, and Pie. However, there are additional chart types that it could support, like the Sankey chart, which still need to be implemented.
For the Google Maps option, you need to select the longitude and latitude fields. Additionally, there are options for pin info, as well as color settings for markers and clusters on the map. These features still need to be implemented.
The Kreport developer has added many of these features, but they have integrated them into their own CRM, SpiceCRM, which includes the Kreport tool. You can find more details by watching the following videos:
If KReports is troublesome to use because it is not being actively maintained, wouldn’t it be better to use some generic reporting tool that allows SQL database access?
Something as simple as Excel, or as evolved as you need. If it can connect to our database and consume the data (it’s all there to use, that’s why we’re not going for hosted cloud-based CRM’s, right?)…
@pgr I totally agree with you.
Plugins are easy to install, but a lot of work to maintain.
Since access to the DB is basically one of SuiteCRM “SuperPower”, we should make full use of it.
I usually use Metabase, Redash or a custom DWH / CDP.
Thank you for it. I have question. How can I run from/host on ubuntu 22.04? I want to host it on the server and then all users can access it within local network. Is it possible?
