JasperSoft Studio 6.0.1 Parameters SQL syntax
To add string parameter in our report : String Parameter $P{P1} To add list parameter : $X{IN,sql_column_name,P1}
Merge documents to PDF from iPhone
Are you looking for a quick and easy way to combine multiple files into a single document? Look no further than MergePDF!. This powerful PDF merging tool offers a simple and intuitive, making it easy to add files and merge them into one document. With MergePDF!, you can also scan on-fly ,reorder documents. Get organized and save time with MergePDF – the ultimate PDF merging tool! Only available in Apple Store for iOS devices. Valid extension: docx, doc, xls, xlsx, pptx, ppt, pdf, image files. Camera scan Rectangular shape detection Edit PDF Re-order and remove page Edit Images Crop and select …
Additional measure in Odoo graph view
This article will help you to add measures in graph view, my exemple is based on sale order model, for all additional computed fields, attribute store must be set to True, otherwise you won’t be able to choose it from the dropdown list measure in graph view. When grouping, you might want to calculate on some fields the average instead of the sum, if so, you need to use group_operator = ‘avg’ directly in your model file, see margin_percent field bellow. Find the view_id of your graph view and inherit from it. then place your new field as measure …
Protect Odoo 11 database backup with a password
Database auto-backup backup process crashes with a database size > 200 MB and Odoo worker enabled. The module “Database auto-backup” will help you to backup Odoo database on your local disk or remotely on a FTP server through ftp our sftp protocol, however it doesn’t give us the possibility to secure a bit more the backup file generated, therefore I added 2 additional options (Enable password and password) to be able to protect by a password the compressed file by using directly Linux 7z command line and recompressing a 2nd time the file, we should use dump file instead of …
Flush DNS cache Mac OSX
Create a file flush_dns.sh edit and paste the code bellow:
Number of digits after comma QWEB PDF Odoo
This code bellow will display on the QWEB PDF 4 digits after comma of qty field, for 2 digits just replace by ‘%.2f’%
