| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 1002 |
| Technical Name |
ks_custom_report |
| License | OPL-1 |
| Website | https://store.ksolves.com/ |
| Versions | 14.0 11.0 12.0 13.0 17.0 16.0 10.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
Create Sales Report
Tree/List View
Pivot View
Graph View
Create Sales Report
Tree View
Pivot View
Graph 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 Vlaues 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 2.0.3
■ Minor code changes related to the chart canvas click functionality.
Latest Release 2.0.2
■ Code compatibility with the latest Odoo changes.
Release 2.0.1
■ Fix- Minor code changes related to the alter field chain values.
Release 2.0.0
■ Feature- Custom Query.
■ Feature- Alter Field Chain Values.
Release 1.1.4
■ Fix- Minor code changes related to Report rendering
Release 1.1.3
■ Fix-Minor code change and added dependency module
Release 1.1.2
■ Fix- Minor Code changes related to the group by and sort by functionalities
Release 1.1.1
■ Fix- Dropdown issue in widget.
Release 1.1.0
■ Feature- Reordering of report fields using odoo handle widget.
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 penalizedMust needed app for handling the scattered data!
It helps me in assembling my scattered data on a single view. I personally recommend it!
Demo
Could you send me a demo .
Thanks
Re: Demo
Hi Hamid,
Surely, we can arrange a demo session for you to look at the different features of this Application.
Please reach out to us at sales@ksolves.com
Best,
Ksolves India Limited
print the report
hi, can I print the report PDF and Excel
Re: print the report
Hi Karim, thanks for your query and for showing interest in our app. For now, this feature is not supported in the current version of the app but Excel can be exported using Odoo default export feature. In case of any concern, please feel free to get in touch with us at sales@ksolves.com We would love to assist you on the same. Thanks!
Does it allow to show One2many fields inside a list view?
Is it possible to show One2many fields inside a list view of generated report?
Re: Does it allow to show One2many fields inside a list view?
Hi Michael, thanks for your query and for showing interest in our app. Yes, all types of relational fields (Many2one, One2many, and Many2many) can be shown in ListView. Report with One2many and Many2many relational field data will show report data by duplicating report records except for the relational data. For example, if report is created on the "Sale Order" and "Total Amount" field (Float field) and "Order Lines > Product Quantity", then the report generated will duplicate the records with "Total" except the "Order Lines > Product Quantity" in each row. In case of any concern, please feel free to get in touch with us at sales@ksolves.com We would love to assist you on the same. Thanks!
Can i create a field in report with a 3 level relation?
Can i create a field in report with a 3 level relation for example Relation_field > Relation_field > Relation_field > Non_relation_field ?
Re: Can i create a field in report with a 3 level relation?
Hi Jakol, thanks for your query and for showing interest in our app. Yes, the user can create a relation field chain as long as he wishes. For example, If he wish to create a report on "Project Model" then he can create field chain-like "Users > Company > Parent Company > Partner > Name". In case of any concern, please feel free to get in touch with us at sales@ksolves.com We would love to assist you on the same. Thanks!
Why should one use it?
Can you please let me know the need or purpose of the app?
Re: Why should one use it?
Hi Veronica, thanks for your query and for showing interest in our app. We really appreciate the same. This app provides the flexiblity to generate the report of any module present in Odoo. Moreover, it extracts all the needed information for all the fields of any Odoo Model and displays the scattered data in a single view. Hope your query has been addressed by the above explanation. In case of any concern, please feel free to get in touch with us at sales@ksolves.com We would love to assist you on the same. Thanks!
Version 11?
Version 11 is there?
Re: Version 11?
Hi Simon, thanks for your query and for showing interest in our app. Yes, we are working on the same and it will be launched in the upcoming week. In case of any further queries please drop us an email at sales@ksolves.com We would love to assist you. Thanks!
Re: Version 11?
Hi Simon, thanks for your query and for showing interest in our app. Yes, we are working on the same and it will be launched in the upcoming week. In case of any further queries please drop us an email at sales@ksolves.com We would love to assist you. Thanks!