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

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

Bangles and Bracelets

Bangles are one of the most attractive and beautiful jewellery that I have seen. Having born and brought up in South India, I have seen almost all women wearing bangles. Bangles and Bracelets are auspicious and also very trending in the fashion industry now. Bangles are enchanting and are worn with style by women for special ocassions these days. There are several types of bangles in India but the ones that I have come across in Mysore and Bangalore are the single cylindrical shaped bracelet called kadaga which is usually made of silver, Glass bangles usually in the colors red and green , Gold bangles with various designs ( my favorite is the pepper corn design) , Gold bangles studded with diamonds and wooden bangles which are painted with designs. The kadagas are now mostly worn in the village areas compared to the cities like Mysore and Bangalore. The wooden bangles made in channapatna is popular amongst young girls. All these bangles are round in shape whereas the modern ba...
4 comments
Read more

Vintage letters

Vintage letters are treasures for me. The art of writing letters was in practise since 300 A.D. After 16th century writing letters became an art. Letters were not just used for communication but it became an art also. The design of the letter took a uniform design when the British came to India and started ruling over. Even to this day in some villages of India, the post man or the teachers of the school should open the letter and read it. Today,some vintage letters are preserved in the families, in the Government offices, Parliaments and the collectors who fancy collecting vintage letters. I have preserved letters from Great grandfather and my GrandFather.  I feel that these vintage letters are some sort of treasure that I have. Funniest part is, it takes a long time to come to the matter itself because the starting two- three sentences is to be polite enquiries and whereabouts of each other and ending the letter used to be with elegant words. I will post some pictures of the ...
10 comments
Read more