Reports & Discoverer :: Order The List Of Value?

Aug 21, 2010

I am using oracle 6i and i have parameter. I want the value of parameter to be sorted i use the following query

SELECT DISTINCT To_Char(LD_TASK.TASK_ID) DISPLAY_COL1
FROM LD_TASK
UNION
SELECT '%' DISPLAY_COL1
FROM DUAL
order by display_Col1

In the output i get the value sorted but according to just the first number how i could make it according to the hole number

example of the output
1
11
12
13
14
6
7
8
9

View 2 Replies


ADVERTISEMENT

Reports & Discoverer :: ORDER BY Item Must Be Number Of A SELECT-list Expression

Sep 18, 2009

When i'm sorting on a calculated field i'm getting the following error:

ORDER BY item must be the number of a SELECT-list expression

View 3 Replies View Related

Reports & Discoverer :: Order By?

Jan 28, 2011

One of my columns consists of room numbers ie: room 1, room 2, these can range from 1 - 99. Now, it is very important that I am able to order these rooms, howver when i try to order them, as you may imagine it goes like just take these following data examples. The way I have wrote them is the current way in which they are displayed:

conference room 1
conference room 11
conference room 2
dinning room 1

[code]...

But I want them to be displayed as the following when i decide to order by room:
conference room 1
conference room 2
conference room 11
dinning room 1

[code]...

The data output will vary depending on parameters passed into it so it may not always be the above data.

View 7 Replies View Related

Reports & Discoverer :: Sorting Order

May 18, 2011

1) eno list values ASC , DESC
priority Column : 2

2) DNO List Values ASC , DESC
priority column : 1

3) DTNO List Values ASC , DESC
priority column : 3

So i need the sorting order output like this
LIST VALUES ASC (OR) DESC USER SELECT AT RUN TIME ANY VALUE.

ORDER BY DNO DESC , ENO ASC , DTNO ASC

* The Priority is user will enter at run time based on the number the column should be sorting.

View 6 Replies View Related

Reports & Discoverer :: Order In Matrix Report Column

May 20, 2010

I have to set a matrix report as follow:

- in the rows the machine_id.
- in the column the material_lib.

Table material ( material_id,material_lib,ordre)
- in the cells quantity.

I get successfully my matrix through the wizard of report, but i should display the columns sorted with the field ordre.

how to get the columns of the matrix sorted.

View 5 Replies View Related

Reports & Discoverer :: Order Matrix By Cell Content?

May 30, 2013

I have a matrix report that shows production per year(horizontal) and per country(vertical). The customer's willing to see the data ordered by production, and not per country. I tried to add a CF containing the production in the country group and order by that one, but I'm getting a message saying that the field object cannot be contained into the frame. Both the field and the containing frame are set to Variable. how to get rid of the error or how to achieve the main goal of ordering by the cell content?

View 11 Replies View Related

Reports & Discoverer :: Not Giving Output In Sorted Order

Aug 18, 2010

i hav create a report and use order by in the query of the report when i run my query on sql prompt it gives output in a sorted manner but when i am using it in report builder then it is not giving the output in sorted order.

View 2 Replies View Related

Reports & Discoverer :: Oracle Report 10g - Sorting In Break Order

Nov 30, 2010

Is there a way to short a Matrix report? The query shorts correctly in PLSQL but not in the generated report file.

There are columns like Date,Device,Operator Id etc and the report should be able to short depending on the requirement. For example,

it should be able to short by device, or by Date or both. I tried sorting in the 'Break order' but doesn't come out as required.

View 6 Replies View Related

Reports & Discoverer :: Output Not Appearing In Order When Running In Concurrent Program?

Jan 23, 2013

I have a problem. I have created a report that will list out details of checks using Report Builder. I use XML Publisher to register a template for the report. When running the program through concurrent request, the output will come in pdf format but are not in order.I have add 'Order By' statement in my sql scripts in report builder. Its working fine if test in report builder but not in concurrent program.

View 4 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

SQL & PL/SQL :: Display All Values In Same Order As In IN List

Mar 29, 2010

I had a table main with 2 fields. please see the contents below.

seq name
a aaa
b bbb
c ccc
d ddd

1. My query is as below

select seq,name from main where seq in ('a','b','c','b','d','d') output of query is

a aaa
b bbb
c ccc
d ddd

but I need the output to be as shown below.

a aaa
b bbb
c ccc
b bbb
d ddd
d ddd

I need to display all the values in the same order as in the "IN" list.

View 18 Replies View Related

RMAN :: List Backup In Order To Get SEQUENCE?

Feb 26, 2013

Suppose we need to run the following: DB is single instance. DB Version 10.2.0.5

run {
SET UNTIL SEQUENCE ##;
duplicate target database to QA;
}

Can we use “list backup of archivelog all” or “list backup" in order to get SEQUENCE?

View 2 Replies View Related

Reports & Discoverer :: How To Run Discoverer Reports In A Forms Menu

Jul 5, 2010

how to Run a Discoverer Reports in a Forms Menu.

View 2 Replies View Related

Reports & Discoverer :: Launching Discoverer Viewer From Forms Menu

Dec 6, 2011

Is it possible to link to Discoverer Viewer from Forms without requiring the user to log in again. If so, can I then link to a specific Workbook within Discoverer?

View 2 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 :: Discoverer Admin - How To Copy Folder From One Instance To Another

Nov 9, 2011

I need to copy my discoverer report from dev to prod. How should I do this? Are the items created using calculation in the report can also be copied? These items are not present in the folder in discoverer admin.

View 1 Replies View Related

Reports & Discoverer :: During Open Report The Discoverer Application Frozen?

Jun 23, 2010

When I try to manage the report the Discoverer application frozen.

View 5 Replies View Related

Reports & Discoverer :: Provide Download Link To Blob In Database On Oracle Reports?

Aug 8, 2013

My user would like to have a way to attach files to database records. For simplicity, we'll say that each employee in the database could have 0-many file attachments associated with them. I know how to make this part work using Oracle Forms.

So that's the easy part for me. The tough part is that they want to be able to run an Oracle Report on our application server (displays as a PDF, also downloadable as a PDF) and have links on this report to the attachments that they uploaded using the forms process above.

For the idea of storing the files on a folder somewhere, I simply created a text object on the report that had it's hyperlink property pointing to the file location. Done.. opens fine.

However, I want to be able to have the option of storing these files in the database instead, just in case we can't go with the shared folder idea. I'm not sure how to make this work. I can store a blob in the database.. but how do I link to that blob on the report for them to be able to download it? Is this even possible?

how to create a download link on the Oracle Report that let's them download a file out of the database.

View 5 Replies View Related

Reports & Discoverer :: Text Bold - Format Particular Word In Oracle Reports At Runtime?

Nov 2, 2010

I have a doubt; can we format a particular word in oracle reports at runtime..?

Ex:-

A text filed contains data Quote:We request #BANK# to finance the same Bill as per agreed interest rate and other terms and conditions agreed on the above addendum and immediately remit the proceeds to our account A/c no. #ACCOUNTNO#, held with your Bank.

We need to make #BANK#, #ACCOUNTNO# are bold at runtime, Is there any method to format characters at runtime..?

View 10 Replies View Related

Reports & Discoverer :: How To Call Oracle Reports Inside A Stored Procedure

Oct 14, 2010

Currently some jobs created in WBT scripting need to converted into oracle,plsql.There is one job in WBT scripting, which will invoke the oracle reports inside and generate the PDF files in the destination path as follows:

a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?USERID=%LOGONINFO%+server=rep_pscm9722+destype=file+desname=D:ORACLE10G\%CCALLRptName%+desformat=PDF+PARAMFORM=no+report=PCCALL.RDF")
a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?

[code]...

Now, i want to convert this into oracle,plsql? Is it possible or not?

View 3 Replies View Related

Reports & Discoverer :: How To Create Aging Report In Discoverer

May 28, 2010

[Message #1] how to get a unapplied receipts for ageing report? and RMA(credit and debit note)columns ?

Which tables should be refered for Ageing reports.

[Message #2] How to create an ageing report in discoverer?

Which tables should be refered for a Ageing reports.

Ageing report colums customer name, customer id,location,segment, credit note and debit note in different column,unapplied amount and applied amount in a different colum.Already i got a due remaning date and total amount I want a linked table names.

View 1 Replies View Related

Reports & Discoverer :: Oracle Reports Text Formatting As Runtime?

Aug 26, 2013

I need the below output in oracle reports 6i.

this is a testing string retrieved from database.

now what i need is that to make bold the specific words in a string came from database.

View 2 Replies View Related

Reports & Discoverer :: How To Execute Oracle Reports On A Developer Machine

Mar 25, 2013

I migrated a Oracle 6i Report to Oracle Report 9i so I'm trying to execute a this report in the Run Web Layout, but this doesn't bring me any information, how can i run this reports in the Web layout?

When i run this report en the Paper Layout it's bring me data. When a run the report just bring me a blank web page.

View 1 Replies View Related

Reports & Discoverer :: How To Create Oracle Reports With Java Barcodes

May 24, 2010

how to create Oracle Reports with Java Barcodes.

View 8 Replies View Related

Reports & Discoverer :: Bind To Reports Server Rep_wwubh01ap45 Failed

Jun 9, 2006

While accessing the reports i am getting the following error

Rep - 51002 : Bind to Reports Server rep_wwubh01ap45 failed.

I have checked the file $ORACLE_HOME/reports/conf rwservelet.properties. The parameter SERVER=rep_wwubh01ap45 was present in that file.

View 1 Replies View Related

Reports & Discoverer :: Hiding Reports Server Window - Specify Cmdkey

Jul 19, 2011

We have a reports proces which we want to produce a report where the browser windows doest not display, or if it does, quickly closes after the report is completed.We are using Forms Version 10.1.2.0.2, Oracle Database 10g Release 10.2.0.4.0, OS is Windows XP Pro SP3

We have tried the below, but the primary application window closes, not the report server window.
- http - removed due to form message:You cannot use links until you have posted more than 5 messages.

WEB.SHOW_DOCUMENT(://'|| :global.Report_Server_Name ||
'/reports/rwservlet?cmdkey=ky10i&report='||v_rep_object||'.rdf' ||
'¶mform=no&desformat=pdf&destype=file&desname='||v_file_dir||
'&P_VOU_ID='||'883100000000000005565047129970'||

[code]...

We have modified the forms trigger to produce the report as shown below, but get the error:
FRM-41213: Unable to connect to the Report Server

Current theory is the connection to the database is lacking the user id and password since the cmdkey is not specified. How can we specify the cmdkey when using the run_report_object?

= = = = = = = = = = = = = = = = = = = = = =
DECLARE
v_rep_tx VARCHAR2(100);
v_RepStatus VARCHAR2(2000) := '';
v_rep_idREPORT_OBJECT;
v_repVARCHAR2(100);

[code]...

View 1 Replies View Related

Reports & Discoverer :: Column Headers Repeating In Oracle Reports 10g

Mar 19, 2013

I'm using Report Builder 9.0.4.0.33.

I am creating a report which generates the data to a PDF/CSV based on users Input.When I create the report using Report Builder and execute the report,Delimited data appears in a PDF layout.

But if I add the below code in After Parameter Form trigger,the column headers keeps repeating with the data.

function AfterPForm return boolean is
begin
IF :P_DESTYPE = 'CSV' THEN
:MODE :='DEFAULT';
:DESFORMAT:='DELIMITED';
Elsif :P_DESTYPE = 'PDF' THEN
:DESTYPE := 'CACHE';
:DESFORMAT:='PDF';
END IF;
return (TRUE);
end;
[code]....

But the PDF output seems fine where the header is shown only once.I could see many posts regarding this in Oracle reports 6i wherein delimited_hdr=no is used in Command Line but I would like to know the work around in Oracle reports 10g.

View 3 Replies View Related

Reports & Discoverer :: Calling Reports From Stored Procedures?

Feb 23, 2011

Is there a way to call an oracle report (version 9i) from a stored procedure?

View 2 Replies View Related

Reports & Discoverer :: Automate Oracle Reports Execution

Feb 10, 2012

Any way to automate a job to execute several Oracle Reports to run at the end of every month and either email them to a list of people or possibly save them to a location on a network drive.

At first, I started out with 2 avenues of thought:

1) The following link raised the option of an Oracle Scheduler, but from my research, the scheduler only runs database jobs, shell scripts, batch files, etc.:

[URL]......

2) I was thinking about possibly creating a database job of some sort to call the reports, but from the following link, I've determined that one cannot create+call a stored/database procedure to run Oracle Report files. So there goes my second hope.

[URL].......

So, it appears that the scheduler won't meet my requirements and now I think I'm almost out of options.

My last resort is creating a database job that queries required information and spooling the data + various formatting "stuff" into a txt file. Then, that txt file would be my report. This seems a little savage and I would like to think that there's a ay to automatically run an .REP against a database and save an electronic copy of the report somewhere.

Is it possible to automate the execution of Oracle Reports and then saving the report in a particular format (xls/pdf/rtf/etc.)?

View 1 Replies View Related

Reports & Discoverer :: How To Capture Runtime Reports In A Table

Jun 16, 2011

i have created a report in dis report i created bind parameters..how to capture these parameters into a table(for this i hav created a new table) means if i pass delivery_id at runtime

i need to insert this value into what ever i hav created table next time if i pass same value i need to update that record where should i write dis code in a report and can any one send script for this.

View 23 Replies View Related







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