I’m back to sharing tools I create for myself with the community.
I could not find a reporting module that was powerful enough for advanced SQL users that want to use any SQL to build reports, so I have started building one. If I may say so myself I think it is pretty powerful and yet very easy to use.
It also allows admins to link reports directly to modules or even records inside the CRM that make it super friendly for users that need to use the reports. It also uses caching to make pagination and exporting more lightweight and can export as PDF, CSV or HTML.
If you can write a SQL query to fetch the data you want, you can now add it as a report inside your CRM using this module.
I am attaching the full README file FYI. I would really appreciate it if you would give it a spin and let me have some feedback. You can download it from my SuiteCRM Tools page.
I disabled error reporting on my PHP configuration file ans was able to install and test your module. Now Don’t know what else is missing because when I try to display information on HTML I get this error:
Warning: file_put_contents(/tmp/f477e065601fdc3f3e671bcb2c91d44d.html): failed to open stream: No such file or directory in …\modules\adrep_report\adrep_report.php on line 613
Warning: require(/tmp/f477e065601fdc3f3e671bcb2c91d44d.html): failed to open stream: No such file or directory in …\modules\adrep_report\DownloadReport.php on line 22
Fatal error: require(): Failed opening required ‘/tmp/f477e065601fdc3f3e671bcb2c91d44d.html’ (include_path=’…;…\include/…;\xampp\php\PEAR’) in …\modules\adrep_report\DownloadReport.php on line 22
Then I tried to download CSV file and it contained a list of error similar to the above.
It seems that you are running your SugarCRM instance in Windoze.
You can try to change the temporary file path to something other than /tmp in modules/adrep_report/adrep_report.php on line 34, but unless you are using MySQL my modules will probably not work for you.
I have tested the most recent version of your module and was able to install it on Sutiecrm 7.10.10 with no errors. Now when creating reports if I want to modify a column, it is not saving the changes. For example I created a report and selected columns ID, Name and save it and when running all was fine. Then I tried to modify columns by removing column ID and save it. The problem is that when I run the report again It shows columns I just removed. In this case ID. Not sure if it has something to do with the way the module handles the cache.
First sorry for the delay. We have been testing your module and we noticed you uploaded a new version since our last post.
Here are our findings:
We added a chart and saved. The report didn’t worked because we didn’t created the chart properly. We tried to modify the chart but there is no edit option. In order to restore the report we modify the chart’s table and marked the record as deleted
We modified the chart panel view and were able to see the changes. Later we needed to run a Quick Repair and Rebuild on the system but it never completes. We needed to delete the vardefs files created under the custom folder to be able to complete the repair.
We’ll keep testing and will come back to you with our findings.
We have been using version 0.7.2 of your module and found it works fine on the query and columns. We have found some issues when trying to edit charts as we mentioned on our previous post. Today we found another issue. We are no longer able to modify permissions via the Role management. At this point only users with admin rights can see and use the reports. Normal users won’t have access to the created reports even when access has been granted to their role from the individual reports.