Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Sunday, 17 April 2016

Create Oracle report Using Wizards



Report Builder has a Report Wizard, Data Wizard, and Web Wizard to automate the creation of reports. Most often, you can create a report by starting with one of the wizards, and then refining the report that the wizard creates using the data model view and the layout view.

To create a report using report wizard

1. If the Welcome dialog box appears (the following screen), click Use the Report Wizard and click OK.


If the Welcome dialog box does not appear, choose File->New->Report. Click Use the Report Wizard and click OK.

2.You will receive the following screen unless you selected not to display it in the future previously.    Click next




3. Choose the type of layout you would like to generate from following screen.
   Click next


4. Select Report type; this will affect report layout.  you can see the different layouts by clicking their corresponding buttons and looking at the sample layout on the left. After you select the type you want and give Tile of report

Click next


5. Choose a data source and Click next


6. you need to build the and placed your query as below and click Next


7.If you did not connect the database, connect database and click on Next


8. Select the fields you would like to display in the report in the order you want as shown in the next screen. Then click Next


9.Select the fields you would like to display in the report in the order you want as shown in the next screen. Then click Next


10.If you want change label of report columns you can change in following screen and click on Next

11.If you choose any template, fonts, colors, line widths and structure for your report and click Next and click finish you can find report out as below


You May Like:

Share this article :

0 comments:

Post a Comment