Requirement with Oracle report builder


Hi All,,
I had a requirement like this...i am very new to Oracle report builder tool and Oracle APPS
i need to develop a sample report in this format.......please help me
which tables i need to use??
i know how to create user parameters,field columns...etc i have 50% knowledge on Oracle report builder


You can make start with
Oracle Reports Tutorial...
Here few link...
1. Tutorial 1
2. Basic--[2] Oracle Reports 10g Tutorials
3. About Oracle Report 10g: Triggers in Report Data Source and Report Style
Hope this helps

November 30, -0001

Requirement with Oracle report builder

Hi All,, I had a requirement like this...i am very new to Oracle report builder tool and Oracle APPS i need to develop a sample report in this format.......please help me which tables i need to use?? i know how to create user parameters,field columns

ORACLE reports Build 10g - Data Model - query - If statement in Alias ?

I have the following select statement. It has the alias Survivors, Deaths and "All With the ORACLE reports Build 10g - Data Model - I have the following query statement. I require the alias to change. Can the following be done. Cases". Is it pos

Using CLOBs in oracle Report Builder

I want to select all the data in a CLOB column using SQL Navigator by just doing select entry_note from chartentries; just as you say in your example by it just gives me back a result of (ORACLOB). If I do select to_char(entry_note) from chartentries

How to start Oracle Report Builder in Linux

Hi all Can someone please help by telling how can i start Oracle Report Builder in Linux???? Thank you and best regards to allHello, there should be a script in ORACLE_HOME/bin for 10.1.2. in ORACLE_INSTANCE/config/reports/bin for 11g Of

Exception while opening a JSP file created using oracle report builder

I have created a JSP page which contains embedded Oracle reports build using Oracle Report Builder. I have deployed the JSP created above to the Oracle Application Server but when i try to open the JSP file it gives the following error: 500 Internal

Running Web Layout Of JDBC Query in Oracle Report Builder 11g.

javax.servlet.jsp.JspException: REP-4100: An attempt to execute data source failed. JDBCPDS-62008:A SQL error occurred: {0}. S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt javax.servlet.jsp.JspException: RE

How to install oracle report builder in windows 7

Hi Team, Could you guide me to install oracle report 11g in my PC . Previously i was using 10g . OS : win 7 DATABASE : 11gFollow How to install forms builder? | Oracle Community Hope read all and give a try. HamidRead other 2 answers

How to Invoke Oracle report builder installed on a server from a client

Hi, I am using rwrun60 command to invoke report builder through a shell script. In this case the report builder is installed on the same machine where the shell script exists. But now i have shell script which is on different server (say, Server1) an

Error when open Oracle Report Builder 10g (Windows 7 Ultimate 32-bit)

Hi all, I installed Oracle Developer 10g on windows 7 ultimate 32bit. Form builder running well, but the report got problem when i opened. This is the error message: Problem signature: Problem Event Name: APPCRASH Application Name: rwbuilder.exe Appl

SQR with Oracle Reports

Hi, Can you use SQR code within Oracle reports Is there a way to convert SQR to Oracle ReportsIn some of our applications we are using Reports 6.0 and we have no problems with 9.2 DB.Read other 2 answers

Help required with oracle user management

My requirement is to hide the developer toolbar that shows at the bottom of all the pages in the application. This happens when I log into the application as an administrator or a developer. When I try logging in as an end user, who does not have dev

Call Report Builder from Jdeveloper 10g with parameters

hello , how are you i am in oracle forms for long , today i am work in jdeveloper 10g, i want some questions 1- how call oracle report builder from oracle jdeveloper 10g with parameters 2- if there aren't call from jdeveloper 10g, what is good report

Sql Server Reporting  services with ORACLE

We are thinking of using Sql Server Reporting servicesvwith an ORACLE DB. I will like to know the pros and cons. Any advice would be appreciated.. Thanks alot.Hello, You'll find many doc, examples, demos ... on OTN :

Is Oracle Forms builder version certified with Windows 7 ?

Hello I need to change my old PC that is running 32 bit XP. On this PC , I have installed Oracle Forms builder I need to keep this version of forms as my customer is running the same version on linux. I wish to upgrade my PC and install Wi

Problem with Report Builder 10g

Dear Members, I am using Oracle Report Builder for developing reports. I see that the option "Find and Replace in PL/SQL" in the EDIT Menu is Greyed out completely. This is a great feature which enables me to find the pl/sql code in v

Report builder not printing

HI all, we were using Oracle Report 6i on windows XP Service pack 2, Oracle Database On AIX 5.2 and SEDCO Magina L2200c printer was being used to print the reports from report Builder 6i and it was working fine. but now just we change the

Images in Report Builder 6i

I am using the Oracle Report Builder version 6i . I am unable to display images in the generated reports in RTF (Rich Text Format) . I was suggested by someone to download a patch to ugrade the reports builder to version which is reports 6

Report Builder Crashes on opening a rdf file

Hi, I am trying to do a customization on an oracle standard report (sales order acknoledgement),when i try to open the rdf file from the Reports builder it crashes immedietly. Also i noticed the builder is crashing if i open rdf file having size more

Oracle Reports - Distributing Multiple Reports in a Management Report

Hi, I am new to Oracle Reports and would sincerely appreciate some guidance. Requirement. I plan on using Oracle Reports to write multiple reports containing Text, Graphs, Crosstabs, Tables etc. There are 3 developers and each will be developing a nu

Hanging Report Builder and Runtime-6i

Hi The Reports 6i Builder and Runtime screens are taking 15-20 minutes to open in Win NT Environment.Earlier they used to work just fine.In this 'vaccum' time the task list shows Program not responding but eventually after 10-15 minutes ,the window o