Reports & Discoverer :: Using Parameter For Maximum Rows To Fetch To Be A Number

Dec 15, 2010

In Report it is possible to set the maximum rows to fetch to be a number e.g. 1+.Is it possible to use a number that is selected from another query? When I try to do this i.e. I put in the field num_lines or :num_lines I just get invalid number

View 10 Replies


ADVERTISEMENT

Reports & Discoverer :: Generate Excel Report Output With Maximum No Of Rows?

Nov 24, 2011

I created an xml report of output type 'xsl'. When the report output is generated for more than 65,536 rows then the report out put is not opening. generate excel report output with maximum no of rows.

View 1 Replies View Related

RMAN Error Maximum Number Of 128 Rows Exceeded

Nov 2, 2010

I read the error description. In my case there is only one full backup at a time running, hence it does not make any sense.

RMAN>
connected to target database: OTATEST (DBID=3130218754)
RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT row
s
ORACLE error from target database:
ORA-19921: maximum number of 128 rows exceeded

SQL> select count(*) from V$RMAN_STATUS;

COUNT(*)
----------
560

SQL> select count(*) from V$RMAN_OUTPUT;

COUNT(*)
----------
32834

View 1 Replies View Related

Forms :: ORA-01422 / Exact Fetch Returns More Than Requested Number Of Rows

Aug 18, 2010

ORA-01422: exact fetch returns more than requested number of rows.

I receive this error because i tried to introduce the below coding in a post query of the block.

begin
select supplier_cd into :fin_ex_rev_head.vendor_code
from fin_ex_rev_receipts
where receipt_date
between :keyblock.receipt_date

[code].....

View 10 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 :: How To Find Page Number And Total Number Of Pages

Jan 26, 2010

i am using oracle developer 6i report builder i required this type of query

example

if (:page number LIKE '1')
then
srw.set_text_color('darkred');
end if;

return (TRUE);
end;

but page number is not my table database item how can i use builtan page &<pagenumber> use for conditional format.

View 34 Replies View Related

Reports & Discoverer :: How To Use System Parameter As Currency

Jun 8, 2010

How the use the system parameter as currency, decimal and thousand.

View 2 Replies View Related

Reports & Discoverer :: 10g Parameter Form Error?

Sep 26, 2012

While calling a report I am getting the following error.

REP-546: Warning: The value of restricted LOV parameter TOPROFIT is not among the selectable values.

When I call the same report through another PC it displays parameter form.

I am using Report Builder 10g.

View 3 Replies View Related

Reports & Discoverer :: How To Accept Parameter Between Two Report

Jul 20, 2012

I am running rep_1, and before executing second rep_2 the user should enter department number, after accepting department no, the second rep_2 should be executed. But after accepting parameter the second rep_2 is not displaying any record.

View 1 Replies View Related

Reports & Discoverer :: Parameter Passing Through Report

Feb 2, 2012

I had created drill down reports. rep_1 dispalying various Location_cd. by clicking location_cd The parameter form of rep_2 is displayed in which location_cd is displayed which is already selected and accept dept_cd from user. While running the rep_2 the parameter location_cd is passing null value.

View 1 Replies View Related

Reports & Discoverer :: Destype Parameter Attributes

Oct 21, 2011

Attributes required on the destype parameter list. This attributes are like PRINTER

EXAMPLE:
ADD_PARAMETER(listap,'DESTYPE',text_parameter,'PRINTER');

View 1 Replies View Related

Reports & Discoverer :: 10g - Parameter Form - Desname

Sep 3, 2010

In the parameter form in my report I want to give user the facility of browsing the location where he/she wants to store the report. how can I accomodate the same?

View 1 Replies View Related

Reports & Discoverer :: Pass Parameter From Forms To Report

Oct 5, 2013

I can not Pass parameter from forms to Report.

I use three parameter for report. I want to show the employee who has been hired between from_date to_date,it work well in report builder. but I want to pass parameter from forms to report and pdf format. I upload my work (this is actually a zip File, change file type txt to zip just before open).

View 5 Replies View Related

Reports & Discoverer :: How To Create Report Using Lexical Parameter

Feb 17, 2011

I know lexical parameter concept..but i want a demo report which will use lexical parameter...

View 1 Replies View Related

Reports & Discoverer :: Script To Find Report Parameter

Dec 9, 2011

I just have a requirement.Is there any way to write any script which can find the report parameters which are used for its execution so that manual checking for many reports is avoidable as there are about hundreds of reports in our environment.

View 2 Replies View Related

Reports & Discoverer :: Parameter Wise Report Content

Jan 10, 2012

I developed a report for bar code and it is running well.the contents in one bar code are Item name,code,price.I designed 4 pieces in a page and generate also 4 pieces in a page.

But Now I want to generate the report with a parameter where I can mention how many copies of bar code will generate in a page for this specific item.

If I put 3 pieces in parameter then bar code will generate 3 pieces. or so and so.

View 1 Replies View Related

Reports & Discoverer :: Discover Parameter Default SYSDATE?

Oct 26, 2012

I've hunted everywhere, and I'm beginning to think this is impossible, however I'll give it a shot...

I would like my Discoverer report start date/end date to default to YESTERDAY.

View 2 Replies View Related

Reports & Discoverer :: Bind Parameter Defined In Report

Oct 4, 2010

I Created a Bind parmeter in report .....but when i run report it show only loc bind parameter not fyyear bind parameter...

Code is :

SELECT distinct BPT_LOC Location, BPT_DOC_DT BNP_REF_DT, BPT_DOC_NO BNP_REF_NO,
BPT_VEN_NM Vendor_Name,
BPT_BIL_NO Bill_No, BPT_BIL_DT Bill_Date ,
E.BMDT_CNTRCT_CD CONTRACT_NO,
BPT_NET_VOU Total_Amount, BPT_SAL_RT VAT_AMOUNT,

[Code]...

View 2 Replies View Related

Reports & Discoverer :: Select List Of Values From Parameter Form?

Jun 9, 2012

I am trying to select multiple values from a parameter form based on a select statement.

I created the parameter and write the select statement under list-of-value property However what I want is to let users choose multiple values from the select statement not only one value.

View 1 Replies View Related

Reports & Discoverer :: How To Create Parameter Form In Descriptive Format

Jan 28, 2013

I have developed report in reports9i and executing this report at application server but the parameter form is not displaying as its displayed in report builder.

parameter form isn't in descriptive format like you can check the department field. how to create parameter form in descriptive format or I am doing any mistake?

View 3 Replies View Related

Reports & Discoverer :: Hide One Frame And Display Other Depending On Parameter Value

Aug 22, 2010

I want to hide one frame and display the other depending on the parameter value . How could i make that ?

View 1 Replies View Related

Reports & Discoverer :: Changing Lov Font Face To Parameter Form

Apr 11, 2012

I need to change the font face from following lov value for parameter form, How?

SELECT DISTINCT CODE_ENTRY.VILLAGE_NAME, CODE_ENTRY.UNIONN_NAME
FROM CODE_ENTRY

View 4 Replies View Related

PL/SQL :: How To Fetch A Row With Maximum Rownum

Jan 15, 2013

In my sql query, how can i fetch the row with max row count? the query has around 10 columns.

View 2 Replies View Related

Reports & Discoverer :: Error Message When Passing The Report Parameter From Command Line?

Jan 31, 2012

I prepared a report in Oracle reports and trying to run the report through command line by creating a batch file. but i am getting the following error message when i run the batch file

REP-0069: Internal error
REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output

the batch file is as follows

D:DevSuiteHome_1BINRWRUN p:spannawazeitspanna_wa_zeit.Rep userid=alrayatec/alrayatecprod@alraya.world
DESFORMAT=HTMLCSS DESTYPE='mail' DESNAME='sarfraz_it@hnd.com'

View 1 Replies View Related

Reports & Discoverer :: How To Compare Current Page Number With Total Page Number

Feb 19, 2013

I have a report created in Reports6i. I have two fields at the bottom

1.Page Total
2.Voucher Total

I do not want to print the Page Total if the total number of pages = 1.

How can I achieve this?

View 1 Replies View Related

Reports & Discoverer :: Number Format

Oct 20, 2011

I have a value 233560.66 but in report its showing 233560.67 using format NNNGNNNGNNNGNN0D00 but when i remove format it shows 233560.665 but i want result 233560.66

View 2 Replies View Related

Reports & Discoverer :: Page Number Change

Dec 3, 2011

During the Report Development for the Invoice Print the Page Number is required to display for the each Page like 1 of 3.The Report have the parameter of From Invoice Number and To Invoice Number. The Page display the Current page and Total Page. How to Split the Invoice Number wise page Number in the Report.

Presently

Invoice No Page No.
14001 1 of 4
14002 2 of 4
14002 3 of 4
14003 4 of 4

Requirement

Invoice No Page No.
14001 1 of 1
14002 1 of 2
14002 2 of 2
14003 1 of 1

View 2 Replies View Related

Reports & Discoverer :: Find Out Last Page Number?

Sep 29, 2011

I want to display a boilerplate item and their value only on the last page.

The item is under frame . So print object at last page doesn't work.

I could find the page number by the use of srw.get_page_num(n).

But not sure how to find the last page number.

View 2 Replies View Related

Reports & Discoverer :: Converting The Number To String

Dec 6, 2010

I wanna convert the amount of money from number to string such as 144.5 to be one hundred forty four point five is there any function or i have to write my function? How could i put new line in the string?

for example if i have 'SAB Bank' || 'Riyadh'

but i want SAB bank to be displayed in line and Riyadh in line.

View 2 Replies View Related

Reports & Discoverer :: Masking Number To Word

May 21, 2013

I just want to know whether we can mask salary column of number datatype into text ,like we used to_char(to_date(<column_name>,'j'),'jsp') in sql? for example

Name Salary
SMITH 800

to
Name Salary
SMITH EIGHT HUNDRED

View 5 Replies View Related







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