| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 945 |
| Technical Name |
ks_custom_report |
| License | OPL-1 |
| Website | https://store.ksolves.com/ |
| Versions | 17.0 16.0 11.0 12.0 10.0 14.0 13.0 15.0 |
ReportMate
PROBLEM:
In Odoo, there is no option available for users to create custom reports on their own from the view.
SOLUTION:
The app ReportMate allows users to display all their records in a flat data structure. The company can now easily group several data sets to be displayed.
Hot Features
-
Create Custom View
Create Custom View/Report based on Selected Model and by Selecting Fields/Relations on their own
-
Different Views
Reports can be displayed in Pivot and Graph View
-
Report Security
Created Reports can only be viewed by Groups that have access to view created reports/views
-
Customisable Filter/Group Filter
Users can customize which fields to show in Search Filter/Group Filter
-
Custom Query
User Can Write Query and Create Custom View/Report based on Custom Query
-
Alter Values
User Can Alter values of fields.
Features
Tree/List View
Pivot View
Graph View
Create/Configure Reports :
While creating the Report, the user needs to select "Query Type = Field Chain" and the model on which they wish to create their report.
After selecting the model, the user will be able to see the list view at the bottom where they can add the Report Field line one by one. While creating the Report Field line, users can:
Set the name of the field (display name)
Select the field / field chain of the selected Model. Users can also set up the field chain as deep and long as they need to
Set the field to be shown in Search and Group Filters
User Can Alter Values Of field(Integer,float,Monetary, date, datetime Type)
After adding all Report Field Lines, users can fill in other Report related information. While creating the Report user can :
Set the Menu Name (Report Menu Name) and select under which menu it will be shown
Set Menu Priority to decide the position ordering of Menu
Set Menu as active or inactive by ticking the checkbox to enable/disable menu at any time
Set Groups on Report through Group Access to control who will be allowed to view the created Report
Set Pivot and Graph options to enable Pivot and Graph views for Reports
After saving the report Users will have to refresh their browser to see the Menu for the report.
Sale Report View Example :
-
Sale Report Tree/List View
-
Sale Report Pivot View
-
Sale Report Graph View
Create/Configure Reports :
Set the Menu Name (Report Menu Name) and select under which menu it will be shown
Select "Query Type = Custom Query" and Wtite Your Query in Custom Query Text field
Set Menu Priority to decide the position ordering of Menu
Set Menu as active or inactive by ticking the checkbox to enable/disable menu at any time
Set Groups on Report through Group Access to control who will be allowed to view the created Report
After executing the Query, the user will be able to see the all the columns in list view at the bottom :
Set the name of the field (display name)
Set the field to be shown in Search and Group Filters
Set Pivot and Graph options to enable Pivot and Graph views for Reports
After saving the report Users will have to refresh their browser to see the Menu for the report.
-
Since ReportMate create reports using database queries, it can bypass all model securities to show the report data. Therefore there is security group for ReportMate.
-
ReportMate Manager role control who can Read/Create/Edit/Delete the ReportMate Records (Reports).
-
Admin is by default assigned as ReportMate Manager. They can give this role to other users by going into the User form page and setting up ReportMate Manager as True.
Why Us?
One of the first Odoo apps to display your
complex data in a single view
Our Releases
Latest Release 1.0.1
■ Fix- Fixed the issue of wrong data showing in the delivery address in the Report Mate module.
Frequently Asked Question
Please drop email at sales@ksolves.com or raise a ticket through Odoo store itself.
Yes, we do provide free support for 90 days for any queries or any bug/issue fixing.
ReportMate extracts all the needed information for all the fields of any Odoo Model and displays complex data in a single view.
Reportmate is useful for all the Odoo module where reports are required. For example, Inventory Management, Sales and Team Reporting etc.
Pivot and Graph view
Yes, our app works with Odoo Enterprise as well as Community.
Ksolves will provide FREE 90 days support for any doubt, queries, and bug fixing (excluding data recovery) or any type of issues related to this module. This is applicable from the date of purchase.
Note:
Extensively Tested on Odoo Vanilla with Ubuntu OS
Ksolves Odoo Services
Odoo Implementation
Odoo Community Apps
Odoo Support & Maintenance
Odoo Customization
Odoo Integration Services
Odoo Developer Outsourcing
sales@ksolves.com
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedThere are no ratings yet!
Does it Work on Analytic Account Level?
I need reports splitting for example, sales by Analytic Account.
Does it Work on that Level but displaying parallel view on AAs? (nos just filtering or grouping)
And for more complex reports like P&L or margins?
Re: Does it Work on Analytic Account Level?
Hello Jlarrain,
Thanks for reaching out to us,
We have checked the concern that you have shared with us and In the ReportMate we are providing a feature to write the custom SQL query. So by writing the custom query
you can achieve the same. And currently in the ReportMate application you can showing your data in List and Pivot view only.
Yes you can generate a P&L and Margins report by writing a custom query and show it in the List and Pivot view, but not to maintain any hierarchy.
If you have any other concerns or queries please feel free to reach out to us at odoo.helpdesk@ksolves.in.
Thanks,
Team Ksolves!
Can we save the reports as a pdf?
Re: Can we save the reports as a pdf?
Hello Muhammad Ibrahim,
Thanks for reaching out to us,
The purpose of reportmate is to create a custom view and show your stored data on that custom view.
And using the Odoo default feature you can export all the custom reports in the "xlsx sheet". But currently there is no any such option to export or save the custom reports in "pdf" format.
If you have any other concerns or queries please feel free to reach out to us at odoo.helpdesk@ksolves.in.
Thanks,
Team Ksolves !