Oracle Fusion Middleware Oracle Reports Tutorial

Oracle Fusion Middleware Oracle Reports Tutorial-Free PDF

  • Date:15 May 2020
  • Views:18
  • Downloads:0
  • Pages:45
  • Size:758.89 KB

Share Pdf : Oracle Fusion Middleware Oracle Reports Tutorial

Download and Preview : Oracle Fusion Middleware Oracle Reports Tutorial


Report CopyRight/DMCA Form For : Oracle Fusion Middleware Oracle Reports Tutorial


Transcription:

Oracle Fusion Middleware Oracle Reports Tutorial 12c 12 2 1 3 0. Copyright 2016 2017 Oracle and or its affiliates All rights reserved. Primary Author Arup Roy, Contributor Igor Polyakov Rajiv Malhotra Ratheesh Pai Vidya Viswanathan Hariharan Srinivasan. This software and related documentation are provided under a license agreement containing restrictions on. use and disclosure and are protected by intellectual property laws Except as expressly permitted in your. license agreement or allowed by law you may not use copy reproduce translate broadcast modify license. transmit distribute exhibit perform publish or display any part in any form or by any means Reverse. engineering disassembly or decompilation of this software unless required by law for interoperability is. prohibited, The information contained herein is subject to change without notice and is not warranted to be error free If. you find any errors please report them to us in writing. If this is software or related documentation that is delivered to the U S Government or anyone licensing it. on behalf of the U S Government then the following notice is applicable. U S GOVERNMENT END USERS Oracle programs including any operating system integrated software. any programs installed on the hardware and or documentation delivered to U S Government end users. are commercial computer software pursuant to the applicable Federal Acquisition Regulation and. agency specific supplemental regulations As such use duplication disclosure modification and. adaptation of the programs including any operating system integrated software any programs installed on. the hardware and or documentation shall be subject to license terms and license restrictions applicable to. the programs No other rights are granted to the U S Government. This software or hardware is developed for general use in a variety of information management. applications It is not developed or intended for use in any inherently dangerous applications including. applications that may create a risk of personal injury If you use this software or hardware in dangerous. applications then you shall be responsible to take all appropriate fail safe backup redundancy and other. measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages. caused by use of this software or hardware in dangerous applications. Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of. their respective owners, Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation All SPARC trademarks. are used under license and are trademarks or registered trademarks of SPARC International Inc AMD. Opteron the AMD logo and the AMD Opteron logo are trademarks or registered trademarks of Advanced. Micro Devices UNIX is a registered trademark of The Open Group. This software or hardware and documentation may provide access to or information about content. products and services from third parties Oracle Corporation and its affiliates are not responsible for and. expressly disclaim all warranties of any kind with respect to third party content products and services. unless otherwise set forth in an applicable agreement between you and Oracle Oracle Corporation and its. affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of. third party content products or services except as set forth in an applicable agreement between you and. Audience v,Documentation Accessibility v,Related Documentation v. Conventions v,Prerequisites vi,1 Tutorial Overview.
1 1 Tutorial Scenario 1 1,1 2 Summary 1 3,2 Adding Data to a Report. 2 1 Opening the Web Page 2 1, 2 2 Using the Data Wizard to Add Data to a Sample Web Page 2 2. 2 3 Saving your Report as a JSP File 2 5,2 4 Summary 2 6. 3 Reviewing the Source Code of the Web Report,3 1 Viewing the Web Source in Reports Builder 3 1. 3 2 Verifying Your JSP Code 3 2,3 3 Summary 3 2,4 Reviewing the Source Code for the Report Block.
4 1 Viewing the Web Source in Reports Builder 4 1,4 1 1 Reviewing the Header Tag and Body 4 1. 4 1 2 Reviewing the rw foreach Tag and Body 4 1,4 2 Verifying Your JSP Code 4 2. 4 3 Summary 4 2,5 Creating a Report Block for the Web Report. 5 1 Adding a Report Block to Your Web Page 5 1,5 2 Summary 5 3. 6 Creating a Graph for the Web Report, 6 1 Opening the Source for the Report in Reports Builder 6 1.
6 2 Creating a Graph Using the Graph Wizard 6 2,6 3 Saving Your Report with the New Graph 6 4. 6 4 Summary 6 4,7 Reviewing the Source Code for the Graph. 7 1 Viewing the Source in Reports Builder 7 1,7 2 Reviewing the rw graph Tag 7 1. 7 3 Summary 7 3,8 Generating a Paper Report, 8 1 Generate a Paper Report Based on Your Data Model 8 1. 8 2 Modifying a Report in the Paper Design View 8 3. 8 3 Summary 8 4,A Quick Reference Guide,A 1 Entries for the Data Wizard A 1.
A 2 Entries for the Report Block A 1,A 3 Entries for the Graph Wizard A 2. A 4 Entries for the Report Wizard A 2,A 5 Reference Material A 2. B Tool Palette and Toolbar Reference,B 1 Main Toolbar B 1. B 2 Data Model View Tool Palette B 2,B 3 Paper Layout View Tool Palette B 3. This manual will help you get started using Oracle Reports and also introduce you to. publishing data to the Web and paper, This tutorial is intended for users new to Oracle Reports or for users familiar with.
Oracle Reports who would like to learn more about building JSP based Web reports. Documentation Accessibility, For information about Oracle s commitment to accessibility visit the Oracle. Accessibility Program website at, http www oracle com pls topic lookup ctx acc id docacc. Access to Oracle Support, Oracle customers that have purchased support have access to electronic support. through My Oracle Support For information visit, http www oracle com pls topic lookup ctx acc id info or visit. http www oracle com pls topic lookup ctx acc id trs if you are hearing. Related Documentation,For more information see the following documents.
Release Notes for Oracle Forms and Reports,Installation Guide for Oracle Forms and Reports. Oracle Fusion Middleware Publishing Reports to the Web with Oracle Reports Services. Oracle Reports Building Reports,Oracle Reports online Help. Conventions, The following text conventions are used in this document. Convention Meaning, boldface Boldface type indicates graphical user interface elements associated. with an action or terms defined in text or the glossary. Convention Meaning, italic Italic type indicates book titles emphasis or placeholder variables for.
which you supply particular values, monospace Monospace type indicates commands within a paragraph URLs code. in examples text that appears on the screen or text that you enter. monospce italic Monospace italic type indicates variables or user supplied names. Brackets enclose optional clauses from which you can choose one or. Prerequisites, The exercises in the tutorial use the Human Resources sample schema provided with. the Oracle database and an HTML template, You must download the supporting files for the report that you will build You can. download the sample tutorial zip folder called tutorial examples zip available on. Oracle Technology Network OTN located at, http www oracle com technetwork middleware reports tutorial examples 131. 273 zip This zip file contains a text file containing the SQL you will enter and the. JSPs you will create in every chapter Extract this zip file into ORACLE HOME examples. for example D orawin examples,Sample Schema, This tutorial relies on the data contained in the Human Resources section of the.
sample schema This sample schema is provided with the Oracle database. Viewing Web Reports, To produce the Web based report you must have a Web browser installed on your. computer The minimum and recommended requirements are. Microsoft Internet Explorer 6 x or higher,Mozilla Firefox 3 x or higher. Viewing the Web Source, Although you can view the Web source for your JSP report in Reports Builder this. tutorial also shows you how to analyze your Web source in a text editor It is. recommended that you use a text editor such as NotePad or UltraEdit. 1 Tutorial Overview, In this tutorial it is assumed that you are a developer for a company called My. Company You have been asked to publish some content on the company intranet. Human resource managers for each branch should be able to view this content from. any location You must use the company s template which is an HTML file to make. the data look good on the Web At the same time managers must be able to print a. paper version of the report, In this tutorial you will build a report for the Web using JavaServer Pages JSP that.
displays the required information about employee salaries in each department You. will also create a graph so that managers can see an overview of the data At the end of. the tutorial you will learn to generate a paper report based on the same data model. Figure 1 1 shows an overview of the first part of the tutorial. Figure 1 1 Tutorial Overview Creating the Web Report. 1 1 Tutorial Scenario,In the chapters of this tutorial. 1 You will open the Web page that have been provided for you which contains. some simple HTML then create a data model for the report which will pull data. from a sample data source into the report Chapter 2 Adding Data to a Report. This Web page contains the template for My Company s look and feel. Tutorial Overview 1 1,Tutorial Scenario,Figure 1 2 Adding Data to an HTML Page. 2 In Chapter 3 Reviewing the Source Code of the Web Report you will review the. resulting report to analyze what the steps you completed in Chapter 2 Adding. Data to a Report did to the sample Web page to help you understand what. Reports Builder did to the sample Web page You can compare the sample Web. page that have been provided with the resulting JSP based Web page Here you. will be able to examine how the data model looks in Reports Builder and how it. looks in XML, 3 In Chapter 5 Creating a Report Block for the Web Report you will use the. Report wizard to add a report block to the JSP and generate a simple JSP based. Web report to your Web browser, Figure 1 3 Creating a Report Block for your JSP based Web Report. 4 In Chapter 4 Reviewing the Source Code for the Report Block you will analyze. the Web source of your report to review how the report block was inserted into. your JSP based Web report Again you will examine the XML code to see how the. source code has changed, 5 In Chapter 6 Creating a Graph for the Web Report you will use the Graph.
wizard to add a graph to the JSP then generate the completed JSP report to your. Web browser, 1 2 Oracle Fusion Middleware Oracle Reports Tutorial. Figure 1 4 Adding a Graph to a JSP based Web Report. 6 In Chapter 7 Reviewing the Source Code for the Graph you will review the new. code that Reports Builder added to your Web source to produce the graph. 7 In Chapter 8 Generating a Paper Report you will generate a paper report based. on the same data model and layout that you created for the JSP based Web report. Figure 1 5 Generating a Paper Report from a JSP based Web Report Data Model. 1 2 Summary, Now that you know what this tutorial covers you can go on to Chapter 2 Adding. Data to a Report to learn how to create a data model for your report using the Data. Tutorial Overview 1 3, 1 4 Oracle Fusion Middleware Oracle Reports Tutorial. 2 Adding Data to a Report,Estimated completion time 15 minutes. Consider the scenario where you must create a Web report for your company s human. resources managers This Web report must display salary information about each. employee in a department You already have an HTML page that matches the. company s logo and colors You need to add the necessary information to this page. This chapter shows you how to use the Data Wizard in Reports Builder to add data to. an existing HTML page as depicted in Figure 2 1 At the end of the chapter you will. have created a data model to make data available for use in a Web report. Figure 2 1 Adding Data to an HTML Page,2 1 Opening the Web Page.
The steps in this section show you how to open the Web page template that have been. provided called emprev htm First you will open the Web page in your Web browser. so that you can see what our template looks like, Note If you do not have this file refer to the Prerequisites section. in the Preface,To open the sample HTML page in your Web browser. In your Web browser for example Netscape or Internet Explorer choose File. Open and navigate to emprev htm The emprev htm file is the sample file that have. been provided in this Tutorial,Adding Data to a Report 2 1. Using the Data Wizard to Add Data to a Sample Web Page. To open an existing HTML page in Reports Builder,1 Open Reports Builder. Note If you are using UNIX navigate to the directory where Reports. Builder is installed and then execute rwbuilder sh. 2 In the Welcome dialog box click Open an existing report then click OK. 3 In the Open dialog box navigate to the folder where the tutorial sample files are. located For example d Reports Tutorial,4 Find the emprev htm file and click Open.
The EMPREV report is displayed in the Object Navigator. In Chapter 4 Reviewing the Source Code for the Report Block you will analyze the Web source of your report to review how the report block was inserted into your JSP based Web report Again you will examine the XML code to see how the source code has changed 5 In Chapter 6 Creating a Graph for the Web Report you will use the Graph

Related Books