{"id":458,"date":"2017-09-25T12:15:08","date_gmt":"2017-09-25T12:15:08","guid":{"rendered":"https:\/\/max-drake.cc\/?p=458"},"modified":"2020-07-10T21:07:21","modified_gmt":"2020-07-10T21:07:21","slug":"create-openmaint-report-using-jaspersoft-studio-report-creation","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=458","title":{"rendered":"How to create OpenMAINT report using Jaspersoft Studio"},"content":{"rendered":"

OpenMAINT uses reports created in iReport from Jaspersoft, but this has been superseded by Jaspersoft Studio. I did initially` try and use iReport but found that the download file did not just fire up but needs a bit of work done to it, setting up a NetBean environment.<\/p>\n

I am a bit wary of the Reporting tool as I had previous experience with Report Designer where I was drying to do Room Data Sheets and for lots of effort got very little in return.<\/p>\n

So the first thing I did was extract the reports in openMAINT to JasperSoft Studio (which can be downloaded HERE<\/a>)<\/p>\n

The current Spaces Inventory report looks like this, which tells me very little, I would like some data about the rooms, rather than their code and name:<\/p>\n

\"\"1.5<\/p>\n

Extracting Report from OpenMAINT<\/h3>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

So there is a logic to the data structure in the report.<\/p>\n

We will now load it up into JasperSoft Studio.<\/p>\n

Now, lets look at the zip file, there are 2 files an jrxml file and a jpg image file. \"\"<\/p>\n

Ok, I have decided to follow some of the basic JasperSoft\u00a0 Studio (JS) Tutorials on YouTube.<\/p>\n

I am going to setup a new project in JS, link to my database, select a table\u00a0 (will have to learn about multiple tables later) and display the data from the “Room” table to display the information in a report, it needs to be similar and the same amount roughly as what is shown in the openMaint Spsace & Asset\/Location\/Room layout<\/p>\n

I tried, once in JS , to edit the tables to only show relevant rows (there are a lot of legacy rows in the database that do not show up in openMAINT,) so you need to filter them out. I used SQL query to do this at the front end (only after trying the alternative, so it may seem backward, but I am more comfortable with SQL than the JS process, that is why I am using this method at the moment)<\/p>\n

Basically, you create a new project and a connection to database at the same time in the setup, Then arrange your form and test it, then send it back to openMAINT into the Data Management Module Report Tab.<\/p>\n

First. What the database has for “Room” Table<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Setting up a new Jasper Report<\/h3>\n

Note, you may need to setup the database connection before making a new Jasper Report. Just so you can link the report to the Data Adapter (see 4 images down).<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"\"\"<\/p>\n

\"\"<\/p>\n

\"\"\"\"<\/p>\n

At this point we have blank Report template and database connection.<\/p>\n

Setting up the report view<\/h3>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"\u00a0 \"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Not a pretty report but the essentials of getting a report to display in openMAINT via JasperSoft Studio.<\/p>\n

The refinements can be added later.<\/p>\n

Also a few tests are in order to see that correct data is coming from reports.<\/p>\n

I need to explore why the difference between openMAINT room Display and database, most probably one field filtered will limit the list. Actually its Status<\/strong>, filter for ‘A’ (active<\/em>)- This will show rooms that are current.<\/p>\n","protected":false},"excerpt":{"rendered":"

OpenMAINT uses reports created in iReport from Jaspersoft, but this has been superseded by Jaspersoft Studio. I did initially` try and use iReport but found that the download file did not just fire up but needs a bit of work done to it, setting up a NetBean environment. I am a bit wary of the […]<\/p>\n","protected":false},"author":1,"featured_media":505,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,8],"tags":[16,112,113,53,54,114],"class_list":["post-458","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-openmaint-assettiger","category-openmaint-configuring","tag-amfm-data-management","tag-cafm","tag-cmms","tag-facility-management","tag-facility-operations","tag-iwms"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/09\/js26.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/09\/js26.jpg","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=458"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/458\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/505"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}