{"id":1077,"date":"2020-03-24T13:24:49","date_gmt":"2020-03-24T08:24:49","guid":{"rendered":"https:\/\/kics.edu.pk\/essl\/?p=1077"},"modified":"2020-04-01T17:08:51","modified_gmt":"2020-04-01T12:08:51","slug":"jassper-server-with-odoo","status":"publish","type":"post","link":"https:\/\/kics.edu.pk\/essl\/blog\/jassper-server-with-odoo\/","title":{"rendered":"How to configure Jasper Server with Odoo."},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"573\" src=\"https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/Jasper-1024x573.png\" alt=\"\" class=\"wp-image-1078\" srcset=\"https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/Jasper-1024x573.png 1024w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/Jasper-300x168.png 300w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/Jasper-768x430.png 768w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/Jasper-134x75.png 134w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/Jasper.png 1431w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>In this blog, we will be explaining the step by step and briefly explained procedure of configuring Jasper Server with Odoo.&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kics.edu.pk\/essl\/blog\/jassper-server-with-odoo\/#User\" >User:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kics.edu.pk\/essl\/blog\/jassper-server-with-odoo\/#Reports\" >Reports:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kics.edu.pk\/essl\/blog\/jassper-server-with-odoo\/#Technical_Settings\" >Technical Settings:<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"User\"><\/span><strong>User:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Create the user by clicking on \u201cadd user\u201d and fill the details.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1079 aligncenter\" src=\"https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/1-1-300x145.png\" alt=\"\" width=\"300\" height=\"145\" srcset=\"https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/1-1-300x145.png 300w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/1-1-1024x495.png 1024w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/1-1-768x371.png 768w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/1-1-820x400.png 820w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/1-1-155x75.png 155w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/1-1.png 1365w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>(Note: User name and user id can be same.)<\/p>\n<p><strong>Data Sources:<\/strong><\/p>\n<ul>\n<li>Download the jasper server using the link <a href=\"https:\/\/community.jaspersoft.com\/project\/jasperreports-server\/releases\">https:\/\/community.jaspersoft.com\/project\/jasperreports-server\/releases<\/a><\/li>\n<li>After installation, First, create data source for which you want to add resources for, by right clicking on the data source option located at left.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1080 aligncenter\" src=\"https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/2-1-300x144.png\" alt=\"\" width=\"300\" height=\"144\" srcset=\"https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/2-1-300x144.png 300w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/2-1-1024x491.png 1024w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/2-1-768x369.png 768w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/2-1-156x75.png 156w, https:\/\/kics.edu.pk\/essl\/wp-content\/uploads\/2020\/03\/2-1.png 1365w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul style=\"list-style-type: circle;\">\n<li style=\"text-align: left;\">Mention the port number, the name of the data base whose are intended, user name and password which is same as configured while setting up data base in Odoo.<\/li>\n<li style=\"text-align: left;\">In case of single db data sources, the user needs to mention the dbname as it is shown.<\/li>\n<li style=\"text-align: left;\">In case of multiple db data sources, the user needs to mention the db name in the following syntax: {attribute(\u2018dbname\u2019,\u2019user\u2019)}. The db name and user is written as generic example. It can be changed as per user\u2019s setting.<\/li>\n<\/ul>\n<ul>\n<li>When a new data source is added successfully, set the data source type and properties.<\/li>\n<li>Select the type of data source you wish to add and then enter the required property values.<\/li>\n<\/ul>\n<ul>\n<li>Set the required values for the report, then, optionally, proceed to other pages in the flow.<\/li>\n<\/ul>\n<ul>\n<li>You can test connection in order to check that all entered fields are valid or not and then save.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Reports\"><\/span><strong>Reports:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>Right click on reports to add a folder which will distinguish your existing database from other databases.<\/li>\n<li>Right click on the folder that you have created, then add resource-&gt; Jasper Report.<\/li>\n<li>Set the required values for the report, then, optionally, proceed to other pages in the flow.<\/li>\n<li>Upload a local jrxml file of report. Name of report and resource id should be same as local jrxml file.<\/li>\n<li>Click on data source and browse data source path (it can be found by right clicking on the report) from repository and then submit report.<\/li>\n<li><strong>Sub reports:<\/strong> If the submitted report has any sub report, it will automatically be loaded. Follow the number 4 and 5 steps to submit sub report.<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"Technical_Settings\"><\/span><strong>Technical Settings:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Open technical settings in Odoo and go to reports for reports settings.<\/li>\n<li>Edit the username, password, server IP address, server port, report path and data source path.<\/li>\n<li>If you have entered everything correct then all reports are ready to print.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":1110,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[13,105],"tags":[113,44,27,17,31,110],"class_list":["post-1077","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-technical-training","tag-configuration","tag-essl","tag-jasper","tag-kics","tag-odoo","tag-technical-training"],"_links":{"self":[{"href":"https:\/\/kics.edu.pk\/essl\/wp-json\/wp\/v2\/posts\/1077","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kics.edu.pk\/essl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kics.edu.pk\/essl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kics.edu.pk\/essl\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/kics.edu.pk\/essl\/wp-json\/wp\/v2\/comments?post=1077"}],"version-history":[{"count":2,"href":"https:\/\/kics.edu.pk\/essl\/wp-json\/wp\/v2\/posts\/1077\/revisions"}],"predecessor-version":[{"id":1111,"href":"https:\/\/kics.edu.pk\/essl\/wp-json\/wp\/v2\/posts\/1077\/revisions\/1111"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kics.edu.pk\/essl\/wp-json\/wp\/v2\/media\/1110"}],"wp:attachment":[{"href":"https:\/\/kics.edu.pk\/essl\/wp-json\/wp\/v2\/media?parent=1077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kics.edu.pk\/essl\/wp-json\/wp\/v2\/categories?post=1077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kics.edu.pk\/essl\/wp-json\/wp\/v2\/tags?post=1077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}