[et_pb_section bb_built=“1″ fullwidth=“on“ _builder_version=“3.0.74″ background_image=“https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2017\/08\/blog-2-header-v3-min.jpg“ next_background_color=“#000000″][et_pb_fullwidth_header title=“PITSS Tech Blog“ subhead=“News zu Java, PL\/SQL, Entwicklung & Technologiewechsel“ background_layout=“dark“ text_orientation=“center“ background_overlay_color=“rgba(0,0,0,0.53)“ _builder_version=“3.0.74″ title_font_size=“36px“ subhead_font_size=“22px“ max_width_tablet=“50px“]<\/p>\n
<\/p>\n
[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section bb_built=“1″ specialty=“on“ background_position_1=“top_left“ background_position_2=“top_left“ background_repeat_1=“no-repeat“ background_repeat_2=“no-repeat“ _builder_version=“3.0.69″ prev_background_color=“#000000″ next_background_color=“#000000″][et_pb_column type=“3_4″ specialty_columns=“3″][et_pb_row_inner admin_label=“Row“ custom_padding=“29.6833px|0px|0|0px“ _builder_version=“3.0.69″][et_pb_column_inner type=“4_4″ saved_specialty_column_type=“3_4″][et_pb_text _builder_version=“3.0.106″ module_alignment=“left“ background_layout=“light“]<\/p>\n
<\/p>\n
[\/et_pb_text][et_pb_team_member _builder_version=“3.0.106″ name=“by Daniel Kampf“ position=“Senior Consultant, PITSS GmbH“ twitter_url=“https:\/\/twitter.com\/kampfda“ image_url=“https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2018\/04\/daniel-kampf_.jpg.png“ background_layout=“light“ header_font_size=“16″ max_width=“50%“ \/][et_pb_text _builder_version=“3.0.106″ module_alignment=“left“ background_layout=“light“]<\/p>\n
In the last couple of months there has been a lot of information on how to migrate Oracle Reports to other modern reporting tools. For me, as I am dealing mostly with Jasper Reports, the question came up on how we actually can integrate Jasper Reports in Oracle Forms or other tools. So after a workshop together with TIBCO I started to look into the implementation options that the Community and Pro editions have. I had a look at two options: Visualize.js (part of the Jasper Reports Pro Edition) and the REST API (part of both editions).<\/p>\n
Visualize.js is a Javascript API framework that is part of the Pro edition of Jasper Reports. It gives you the possibility to embed Jasper Reports into web applications. Besides the possibility of integration of „simple reporting“, it is possible to „embed interactive HTML5 visualizations, dashboards or multi-element reports using standard JavaScript“.\u00a0 Oracle Forms in the latest version (currently 12.2.1.3) is able to integrate JavaScript also in environments that use the Webstart and Standalone Launcher<\/a>. With that information it should be possible to call visualize.js from Oracle Forms or any other web application supporting JavaScript, and integrate Jasper Reports from that. In my little test scenario I was able to integrate a Jasper report from the server really quick. My next try is going to be to integrate a report or even reporting dashboard from Oracle Forms via Jetty.<\/p>\n [\/et_pb_text][et_pb_image src=“https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2018\/04\/Unbenannt.gif“ _builder_version=“3.0.106″ show_in_lightbox=“on“ url_new_window=“off“ use_overlay=“off“ always_center_on_mobile=“on“ force_fullwidth=“off“ show_bottom_space=“on“]<\/p>\n <\/p>\n [\/et_pb_image][et_pb_text _builder_version=“3.0.106″ background_layout=“light“]<\/p>\nREST API<\/h2>\n
![\"xml\"](\"https:\/\/pitss.org\/de\/wp-content\/uploads\/sites\/9\/2018\/04\/xml.gif\")
With for instance extractvalue the IDs can be extracted and you can actually grab the finished report. In my scenario I used the synchronous call. If you would like to call the Report asynchronous, you first have to get the status information before you try to get the result. Anyway if you call the report synchronously, the first request will wait for the report to be finished and you will just have to get the final document with:<\/p>\n