Skip to main content

Oracle Reports Builder 10g

Oracle Reports Builder is a tool used for report processing. You can create simple data reports using this tool. I found the installation of this tool a little tedious. Both design time and runtime components have to be installed. If they both are not installed you won't be able to run and test the reports.

After the installation of the Oracle Developer Suite, go to Oracle Database 10g Express Edition and start the database. When you open reports builder, there are three options to build a report: using the report wizard, build a new report manually and open an existing report.

For any of the options that is chosen, you can see tools such as Object Navigator, Object properties, Data model editor, Property Palette, Layout editor and Parameter form editor.In the Layout Editor there are three layout options available to generate reports: create both web and paper layout, create web layout and create paper layout. There are five report styles such as tabular, group above, group left, matrix, matrix with group.
The data source can be chosen from SQL query, text query, XML query, OLAP query, JDBC query.
I have used the SQL query and query builder to create simple reports using Oracle Reports Builder.
You can change the logo and the navigation area by making changes in the web source for web reports. You can make the same changes in paper design for paper reports.

I wrote some procedures with parameters in PL/SQL and compiled them under program units of Oracle reports Builder. However you cannot run the procedure and generate reports out of the procedures. Internet is the wealth of information but I couldn't find relevant information for executing procedures in Oracle Reports Builder 10g. But, simple data reports are very easy to be created using Oracle Reports Builder.
Jahnavi.K.J


Labels:

Comments

Post a Comment

Popular posts from this blog

Esha manohari raga

Esha manohari raga is the janma raga of 28th melakartha hari kamboji. This is a sampoorna, vakra sampoorna janya raga. Apart from shadja and panchama, chatushruthi rishabha, antara gandhara, shuddha madhyama, chatushruthi daivatha and kaishiki nishada are the swara sthanas. The beauty of this raga is indescribable. The popular kritis in this raga are manasa Sri Rama chandruni by Thyagaraja, Sri gananatham bhajare by muthuswami dikshit, himagirisha manonmani by muthiah bhagawathar, shambho gangadhara by Gopala Krishna Bharathi.
Post a Comment
Read more

Zodiac signs

Zodiac signs' dictionary meaning is: "an imaginary area of the sky containing the positions of the sun, the moon and the main planets, divided into 12 equal parts, named after 12 groups of stars. It is interesting to see how these stars effect the life of each individual living on Earth. This study of stars is an ancient science which rises curiosity in everyone. The study depends on the date of birth of the individual in the western countries and on the birth star in the Hindu astrology. The zodiac signs plays a vital role in match making and other aspects in Indian arranged marriage. Some people have strong beliefs in the forecast of these zodiac signs. However I do not believe in the predictions of the zodiac signs :) Jahnavi Participating in A to Z challenge
13 comments
Read more

She - A woman

Image source: http://lilliemcferrin.com/five-sentence-fiction-isolated/ She began a new life with a family in the name of marriage. A family where women were considered men if they had given birth to a male child. She received the portent and tried to impress them but, the only way to impress them was to starve and become lame. "I was not born for this" she thought. She was isolated for the rest of her life for she was a woman. Jahnavi.K.J written for Lillie McFerrin's five sentence fiction .
12 comments
Read more