Reports & Discoverer :: How To Handle No Data Found In Rdf Query

Aug 15, 2012

Here is my req - There are 2 columns C1, C2 - both of which capture a different set of values in 2 seperate custom oracle apps forms.

I have a RDF query to get the result set of C1,C2.

When this query does not return any values I need to look in form 2 and handle each value of C1 separately. I do not know how to achieve this with formula column - since I can perform checks/validations on the data returned by the query using a formula column.

View 3 Replies


ADVERTISEMENT

Reports & Discoverer :: Handle Duplex Printing In XML?

Nov 11, 2010

how to handle Duplex Printing in XML? I have a Oracle XML report (rft and xsl) that needs to be duplex.

View 1 Replies View Related

Reports & Discoverer :: Excluding SQL Query Data When Linked With XML Query?

Apr 26, 2013

I have data in a table and another in XML file,I used SQL query to retrive the data placed on the table, and link this query with XML query that retrieves the data stored in the xml file. The data stored in the table and xml file sharing a key field, but the xml contents are less than what in the table.I want to show only the data shared between the two queries, how can I do that?

e.g.:

Table emp:

e_id | e_name | e_sal
023 | John | 6000
143 | Tom | 9000
876 | Chi | 4000
987 | Alen | 7800

XML File

<e_id>
143
876

So, I want the output to be:

e_id | e_name | e_sal | e_fee
143 | Tom | 9000 | 300
876 | Chi | 4000 | 100

View 2 Replies View Related

Reports & Discoverer :: Report Key Not Found

Nov 4, 2010

Have there any limitation on report key(Number of report key) on cgicmd.dat file?

REP-52005: The specified key mrr does not exist in key map file.

But this key 'mrr' exists on cgicmd.dat.

View 1 Replies View Related

Reports & Discoverer :: How To Make A Query In Data Model

Jul 6, 2013

I have one report consist of two user parameters like FROMDATAE and TODATE and two queries in data model..

The 1st query is..

SELECT WONO,MCV_DATE,QTY FROM MCSHOP1 WHERE MCV_DATE BETWEEN :FROMDATE AND :TODATE;

It created two user parameters.ie FROMDATE and TODATE.

And 2nd query like this

SELECT MCVN FROM MCSHOP1 WHERE WONO=:WONO OR WONO LIKE 'RW%'||:WONO;

I dont know how to make 2nd query in data model. becoz the WONO will come from 1st query and LIKE command is there..But I tried in formula Column....but it returns more than one row...

View 4 Replies View Related

Reports & Discoverer :: REP-50503 No Server Found In The Network

May 21, 2010

I'm receiving the error REP-52266, while running a simple script from Forms 10g:

web.show_document('/reports/rwservlet/showjobs?server=rep_fsprod', '_blank');

I previously received REP-51002; searched over the forums,& made changed to the rwservlet properties file by setting my Server,setting the trace on,& changing my host file in windows.

Errors received now: REP-52266: The in-process Reports Server rep_fsprod failed to start.oracle.reports.RWException: IDL:oracle/reports/RWException:1.0

I also tried these commands:

rwclient server=rep_CC-BA0C7240E38E report=test destype=cache desformat=html
GIVES ERROR:-
REP-0178: can not connect to reports server

rwdiag -findall
Broadcast mechanism used to locate servers
Channel address: 228.5.6.7
Channel port: 14021
REP-50503 No server found in the network.

View 1 Replies View Related

Reports & Discoverer :: Building Reports In Dev - 10g With Ref Cursor Query?

Dec 27, 2011

i was searching for the example of subject mentioned and visited the following website

[URL]...

here is a tutorial to create such report, but i am confused as here in Report's Data Model they created 3 Ref Cursor Queries and did not Close the opened cursor, is there no need of this or any mistake or if it necessary, where have to Close the cursor?First, they have created following Packages

PACKAGE concl_cv IS
type conclass_rec is RECORD
(EMPLOYEE_ID NUMBER(6),
FIRST_NAME VARCHAR2(20),
LAST_NAME VARCHAR2(25),

[code]...

then, created Functions which created in Ref Cursor Query in Data Model
function q_portdescRefCurDS return port_cv.portdesc_refcur is
temp_portdesc port_cv.portdesc_refcur;
begin
open temp_portdesc for select department_id, department_name from departments;

[code]...

nothing here any Close cursor statement.i am trying to explore this area of the development.

View 2 Replies View Related

Reports & Discoverer :: Getting Query Text From Reports?

Aug 4, 2010

Am looking for some stuff that allows me to get the query text of a query in Oracle Reports. Something like : get_query_text(query_name IN VARCHAR2);

View 5 Replies View Related

Reports & Discoverer :: Oracle Apps Data Does Not Show In Discoverer

Mar 19, 2012

When running my query in sql developer, I have to execute the command apps.fnd_global.apps_initialize(user_id, resp_id, resp_appl_id) in order to show the result of my query. Without this, the query returns nothing. The problem is I am using this query as a custom query for my Discoverer report and my report does not show any record.

View 3 Replies View Related

Reports & Discoverer :: Reports Based On Data

Apr 30, 2013

I have a doubt that can we make a report on sum of the salary record wise and grouped by dept number?

like as shown BELOW

Dept No Dept Name
10 Accounting
Employee ID Name Salary Sum Salary
7782 CLARK 2450 2450
7934 MILLER 1300 3750
7839 KING 5000 8750
Dept No Dept Name
20 Research
Employee ID Name Salary Sum Salary
7369 SMITH 800 800
7788 SCOTT 3000 3800
7902 FORD 3000 6800
Dept No Dept Name
30 Sales
Employee ID Name Salary Sum Salary
7844 TUNER 1500 1500
7499 ALLEN 1600 3100
7521 WARD 1250 4350
7900 JAMES 950 5300

emp table
Name Null? Type
----------------------------------------- -------- ------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)

dept table

Name Null? Type
----------------------------------------- -------- --------------------------
DEPTNO NOT NULL NUMBER
DNAME VARCHAR2(15)
LOC VARCHAR2(15)

View 4 Replies View Related

Reports & Discoverer :: Query For Report

Sep 9, 2013

i have a table named actual_qty,

in that table i have data store in the following columns:

MaterialCode Location Qty
------------ -------- ---
1111 vizag 2
2222 vizag 1
3333 vizag 4
1111 hyd 4
2222 hyd 6
3333 hyd 2
1111 sec 9
2222 sec 1
3333 sec 0

i want query to display data data in the following form

MaterialCode vizag hyd sec
------------ ----- --- ---
1111 2 4 9
2222 1 6 1
3333 4 2 0

View 5 Replies View Related

Reports & Discoverer :: How To Add Union To Report Query

Feb 16, 2012

I am making a report in hrd regarding gross, deduction and there difference. I hv an attribute in the table as indicator whose value is addition and deduction. i want the sum of both in two diff column in a single rep. i want the report dept wise.

but i m getting fatal error at run time. which i don't understand.

View 3 Replies View Related

Application Express :: Display Not-found.png For Image Type When Data Not Found?

May 22, 2013

I have an Image Type on a forum page. I want a default "not-found" image to display if the BLOB column value is null or if there is no data for that search value. The image is stored with the app: #APP_IMAGES#not-found.png

APEX 4.2 (with listener) on Oracle 11gR2

View 10 Replies View Related

Reports & Discoverer :: Select Query With Minimum Values

May 30, 2013

The prob is i want to display minimum intime and max outtime in idate against employee,report keep displaying multi inout records of an employees!

SELECT div.division,
DEP.department,
E.employeecode,
E.name empname,
DES.designation,
i.idate,
To_char (Min(i.intime), 'HH:MI:SS AM'),
To_char (Max(I.outtime), 'HH:MI:SS AM'),
Round(i.btime / 60),
e.shift
[code]....

View 7 Replies View Related

Reports & Discoverer :: How To Execute Query 2 If 1 Doesn't Retrieve Anything

Dec 3, 2010

In oracle report how do we execute query2 if query1 doesn't retrieved any records.

View 4 Replies View Related

Reports & Discoverer :: Case Statement Inside Oracle Query - Missing Right Parenthesis

Jun 13, 2013

Can I use CASE statement Inside a Oracle Report Query. I'm using Oracle Reports Builder 10g.

My Report Query looks like this,

select invh_code, invh_number, invh_date, invh_cm_code, im_description
from invoice_head, invoice_det, unit_of_measurement, item_master
where invd_invh_code = invh_code and im_code = invd_item_code
AND
(case :p_flag when 1 then (substr(invd_item_number,0,(length(invd_item_number)-4)) BETWEEN :P_V_ITM_FRM AND :P_V_ITM_TO)
else 1
end)
order by invh_number

:p_flag is a parameter that i pass from oracle form and based on that value (:p_flag=1) i need to include this specific condition
else omit that condition.

But the CASE statement is throwing Error

ORA-00907 :Missing Right Paranthesis
(case :p_flag when 1 then (substr(invd_item_number,0,(length(invd_item_number)-4))
==> BETWEEN :P_V_ITM_FRM AND :P_V_ITM_TO)

View 6 Replies View Related

Reports & Discoverer :: SQL Union All - Query Block Has Incorrect Number Of Result Columns

Feb 1, 2012

I have the following Union All query. It throws the following error in SQL plus

ERROR at line 27: ORA-01789: query block has incorrect number of result columns

After doing some google for the above error it suggests there are incorrect number of columns in the Union All query.I could not figure out the exact location well SQl Plus says error is on line 27 at the first opening bracket like

(Select distinct c.contact_code

Following is the SQL query

Select
tbl_contact.contact_code,
contact_title
||'.'||contact_name contact_name,
contact_address,
[Code] ......

View 1 Replies View Related

Reports & Discoverer :: Data To Be Taken In Different Format

Dec 2, 2012

I have one table storing all the information about employye, i have to develop three different reports based on the same table with different groupings , is there a easy way to call each format differently using single interface ,something like ref cursor.I dont want to create two or 3 different reports , instead choose the format.

CREATE TABLE OT_JOB_DET
(
JT_TXN VARCHAR2(12 BYTE),
JT_NO NUMBER,
JT_DT DATE,

[Code].....

View 4 Replies View Related

Reports & Discoverer :: Export Data From RDF To Excel

May 28, 2009

I want to generate the excel output from a RDF.

If I am using the DESFORMAT=DELIMITED then I am getting unformated data and some time I am getting less data as per PDF output.

There are about 25 queries with interrelated way.

How can I get the output in excel from a RDF.

In Reports 6i Functionality was working while we were running reports because of reports were running in Previewer mode but in 10g reports output coming in PDF format.

View 8 Replies View Related

Reports & Discoverer :: RDF File Run Without Data Using Forms

Jun 30, 2011

I am running a report thru form....While i individually run my rdf file it will run successfully with data.When i tried same rdf by using form , it will run but without data..thats why i check PARAFORM ='YES' but all parameter goes perfectly...

my rdf run but without data.

View 1 Replies View Related

Reports & Discoverer :: View Not Showing All Data?

Nov 1, 2011

We have a view that shows the all the data that we expect, so we created a report to show that data, the report worked, then all of a sudden the report stopped showing all the data. (we did have a server move)I checked the view and the all the data is there....

I have created a new report based on the view but it does the same thing, it doesn't bring all the data up (i get very old data), there are no conditions or anything.

other tables and views seem fine. i have recreated the view and i still have the same problem.

View 2 Replies View Related

Reports & Discoverer :: Data Inserted Twice In Report?

May 10, 2010

I have a report for this report i want to insert a data into one table. when am inserting the data then two time its inserted. if i run the report its inserted the data and i have taken the pdf file then also inserted 2 time for this.

Note: This report having only one group. not necessary below method give any other solution if destype=pdf then no need to insert otherwise insert the data.

View 9 Replies View Related

Reports & Discoverer :: How To Display Data Using User Variable

May 27, 2010

following is my query model

SELECT INV.VENDOR_ID,inv.invoice_date,inv.po_header_id,
INV.INVOICE_ID,
INV.INVOICE_NUM,

[Code]....

WHAT i have to write in select field

View 3 Replies View Related

Reports & Discoverer :: Sorting Data And Hidden Frames

Dec 15, 2011

Jow can i sort field data getting from formula column. The filed that i want to sort have source of that formula column. When i use order by clause with :abc ---(formula column) then it doesn't not work.

View 3 Replies View Related

Reports & Discoverer :: Appending Data Fields To Text?

Jul 29, 2011

I know how to append fields to text, but how do I deal with the variable length? I want to place text on a report and inside the text I have data from two different fields. It works great except that my fields are 35 characters long. If the data fills the entire field it looks great, if the data is only 10 characters long, I have a huge gap between the end of the data and the text that follows. How do I fix this?

View 3 Replies View Related

Reports & Discoverer :: How To Convert Data From 6i To Oracle Table

Jul 10, 2011

How To Convert Data from Reports 6i to oracle Tables.

View 2 Replies View Related

Reports & Discoverer :: If Statement Defining Current Data To New Name

Jul 3, 2012

I would like to know if there is a way to define values in a field to a defined new data.

As an example:
If field A value is equals to May, then set field "Quarter" data value to "2nd Quarter".
If field A value is equals to January, then set field "Quarter" data value to 1st Quarter".

View 2 Replies View Related

Reports & Discoverer :: How To Fetch Data Based On Given Criteria

Sep 1, 2012

I need to design a report out of the below data:

1. bprf_no will be my primary field

2. report parameters will be the bill_month & no_of_months

Based on above 2 parameters I need to scan through the data for BILL_MONTH <= '20-Jun-2012' and NO_OF_MONTHS <= 6 the other criteria being the AVG_IND in (1,2).

In brief the criteria will be to pick all BPRF_NO having AVG_ID in (1, 2) consecutively till a break (AVG_IND not in (1, 2) starting from the given BILL_MONTH and going below this period, that is BILL_MONTH <= '30-Jun-2012'.

For the below data, if my parameters are: BILL_MONTH <= '30-Jun-2012' and NO_OF_MONTHS <= 3, only the underscore added data should be picked (as they fulfill the criteria) and the report output will be like:

BPRF_NO BILL_MONTH NO_OF_TIMES
-------------------------------------------------
BP05 30-Jun-2012 6
BP06 30-Jun-2012 6
BP07 30-Jun-2012 6
BP08 30-Jun-2012 6

Here the NO_OF_TIMES is the count, that is no of times the BPRF_NO falls into the above mentioned criteria consecutively starting from the provided BILL_MONTH.

BPRF_NOBILL_MONTH VOID_STATUS AVG_IND
------- ----------- ------------ --------
BP0130-Jun-1200
BP0230-Jun-1200
BP0330-Jun-1201
BP0430-Jun-1201
_BP0530-Jun-1201_
_BP0630-Jun-1202_

[code]....

My below query is fetching me wrong data:

----- Query -----
select bprf_no, no_of_month--count(*)
from
(
select a.bprf_no, count(*) no_of_month

[code]....

Here BP03 & BP04 should not come into the listing itself.

View 1 Replies View Related

Reports & Discoverer :: Report Generating Wrong Data In Windows 7

May 7, 2012

I am actually having problems with a report that is generating wrong data in Windows 7 only. I have the same report working correctly on many Windows XP Computers.

View 9 Replies View Related

Reports & Discoverer :: Showing The Number Sequence Of Displayed Data

Oct 21, 2010

I have query in that query i should display the number of row. I have tried to select the row num but when i use it the data will be duplicated. I have found something that related to use temporary table, or subquery but all of them will not work because the query depends on many tables and if i use temporary table filling the table and then reading from it will take too long time.

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved