| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 993 |
| Technical Name |
ks_custom_report |
| License | OPL-1 |
| Website | https://store.ksolves.com/ |
| Versions | 17.0 16.0 10.0 12.0 15.0 13.0 14.0 11.0 |
Overview
ReportMate extracts all the needed information for all the fields of any Odoo Model and displays complex data in a single view. Customers can create powerful, richly formatted, dynamic reports in the Tree, List, Graph, and Pivot format. This app allows to display the data in a flat data structure meaning, no more multiple clicks to arrive at your needed results. Increase your business productivity and save your developer's time by using 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
Key Features
-
Create Custom View/Report based on Selected Model and by Selecting Fields/Relations on their own.
-
Reports can be displayed in Pivot and Graph View.
-
User Can Alter values of fields.
-
Created Reports can only be viewed by Groups that have access to view created reports/views.
-
Users can customize which fields to show in Search Filter/Group Filter.
-
ReportMate View
-
- Sale Report View Example :
-
Sale Report Tree/List View
-
Sale Report Pivot View
-
Sale Report Graph View
Free 90 Days Support
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
Ideally we have only made our module compatible with standard Odoo Community and Enterprise Editions UI.
Key Features
-
User Can Write Query and Create Custom View/Report based on Custom Query.
-
Reports can be displayed in Pivot and Graph View.
-
Created Reports can only be viewed by Groups that have access to view created reports/views.
-
Users can customize which fields to show in Search Filter/Group Filter.
-
ReportMate View
-
- Sale Report View Example :
-
Sale Report Tree/List View
-
Sale Report Pivot View
-
Sale Report Graph View
Free 90 Days Support
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
Ideally we have only made our module compatible with standard Odoo Community and Enterprise Editions UI.
Create/Configure Reports :
You can create Reports
from the ReportMate
menu as shown below:
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.
Employee Report View Example :
-
Employee Report Tree/List View
-
Employee Report Pivot View
-
Employee 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.
-
One of the first Odoo apps to display your complex data in a single view
Latest Release 2.0.1-
28th September 2021
Fix- Minor code changes related to the alter field chain values.
Release 2.0.0 -
1st September 2021
Feature- Custom Query.
Feature- Alter Field Chain Values.
1.1.6 -
26th March 2021
Minor code changes related to same relational fields.
Release 1.1.5 -
19th March 2021
Minor code changes related to view creation.
Release 1.1.4 -
15th March 2021
Minor Code changes related to the group by and sort by functionalities.
Release 1.1.3 -
17th February 2021
Fix - Minor bug fix for the table attribute
Release 1.1.1 -
30th November
Fix - Dropdown issue in wizard.
Release 1.1.0 -
17th January
Feature - Reordering of report fields using odoo handle widget .
Release 1.0.1 -
16th December 2019
Fix - Minor bug fix for Group Access on Amendment.
FREE 90 DAYS SUPPORT
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
+91 120-4299799
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!
Hi, Is it possible to re-order lines?
Re:
Hi Awais, thanks for your query and for showing interest in our app. We really appreciate the same. In response to your concern. Currently, our app doesn't support re-ordering in line. For now, the user can remove and add the lines again in the order he wishes. Please feel free to share your further concerns or queries with us on sales@ksolves.com We would love to assist you. Thanks!
Hi Sir, i'm interested to buy this module. is this module can be apply in Multi Company Environment? Can we make this for any model other than sales? Can we make custom report for any module from third party module/apps?
Re:
Hi Alexander, thanks for your query and for showing interest in our app. Yes, it can be applied in a multi-company environment, since it runs queries directly over the database, it will fetch data of all companies irrespective of the active company. That's why security feature is served in our app to control who can view the report. Now, coming to the next query. Yes, reports can be generated on any model as long as that model is stored (i.e. it is not Transient in nature). Furthermore, the user can make a report on third party modules/apps. Please feel free to share your further concerns or queries with us on sales@ksolves.com We would love to assist you. Thanks!