Reports & Discoverer :: Output Is Blank

Jun 2, 2010

I am trying to run Cash receipt report in reports builder. But the output is always blank. It is not even giving any fields created in the layout. This report was developed by some other developer, and there is no documentation available.

I am able to run the query in TOAD and I am getting genuine rows.

View 5 Replies


ADVERTISEMENT

Oracle Reports Blank Line In Output

Feb 21, 2008

i have a problem with oracle reports 6i. the output has 1000s of lines. in my output first to 999th line is fine..bt then 1000th line is blank and again the data continues to be shown from 1001th line till 2000. and again i see a blank. how can i get rid of these blank lines very 1000th line.

View 3 Replies View Related

Reports & Discoverer :: How To See Output Of Reports In Textpad

Feb 5, 2012

I wanted to know the process , where the output of the Oracle reports instead of opening in the Internet Explorer, i wanted to get this output opened in Textpad.

Also, is there a possibility to pass page range dynamically to get printed in oracle reports For example , i wanted to get only 3-12 pages to be printed so if we can pass page range as parameters.

View 8 Replies View Related

Reports & Discoverer :: Report Output Directly Into PDF

Mar 19, 2012

i need to open the report directly into .pdf (adobe) format is there any option to do that.

View 6 Replies View Related

Reports & Discoverer :: REP-52251 - Cannot Get Output Of Job ID 69 Requested?

Dec 15, 2011

my reports were running fine a day ago and now its showing this error .wat could be the possible reason . as if i feel the error has sprung out of no where.

View 6 Replies View Related

Reports & Discoverer :: REP-52251 / Cannot Get Output Of Job ID 18980 Requested

Apr 11, 2011

when i run my form in oracle i got this error fist time

REP-52251: Cannot get output of job ID 18980 you requested on Mon Apr 11 13:26:55 GMT+05:30 2011.<P>REP-56033: Job 18980 does not exist..and again i run this my report its run successfully

View 5 Replies View Related

Reports & Discoverer :: How To Remove Empty Line In Output

Sep 16, 2011

I am getting an empty line after every 988 records in the output. There are no pagebreaks defined in the layout.

This is a "|" delimited report.

View 2 Replies View Related

Reports & Discoverer :: Output Exported To Excel Sheet

Apr 22, 2012

We are using reports 3.0 and I want the report output exported to a excel sheet.. I got package contains some procedures, they have the below line where my report writer throwing error

TYPE ExcelCells IS TABLE OF ExcelCell;

encountered the symbol ";" when expecting one of the following .[@% not null range index.I doubt whether Reports 3.0 support "TYPE".

View 4 Replies View Related

Reports & Discoverer :: Get Graph Output At Report Level?

Dec 24, 2010

get Graph output at report level.

View 1 Replies View Related

Reports & Discoverer :: Suppress Duplicate In Output File

Feb 16, 2010

In Oracle report, there is no duplicate rows I am seeing in the report output screen but getting duplicate rows in output file generated.

View 8 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 :: Rename Report Output File

May 10, 2012

I'm calling myreport.rdf from a form using the rwservlet and destype=mail and desformat=pdf. The report file is attached to the email as myreport.pdf. However, I want to have the output file named myfilename.pdf. Is there any way to accomplish this short of using destype=file and then renaming it and sending that file?

View 2 Replies View Related

Reports & Discoverer :: Output Saved On Client Machine Instead Of Server?

Dec 6, 2010

is it possible to put DESTYPE=LOCALFILE in run_report_object_list?

View 1 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 :: 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

Reports & Discoverer :: Special Characters Coming In Text Output Format Of Oracle?

Jan 27, 2012

I have developed one rdf in Text Output Format.In this some special characters is coming for Text Output format of rdf.Shall i do any adjustments in layout? How to remove these special characters?

View 3 Replies View Related

SQL & PL/SQL :: Remove Blank Spaces In The Query Output

May 6, 2010

I write a Query to get Deptno wise Employee Names as fallows..

SQL> select max(decode(d.deptno,10,e.ename)) dept10,
2 max(decode(d.deptno,20,e.ename)) dept20,
3 max(decode(d.deptno,30,e.ename)) dept30
4 from emp e,
5 dept d
6 where e.deptno = d.deptno

[code]....

But i don't want to include the blank(null) spaces in the query output.

The Required output should be like this..

DEPT10 DEPT20 DEPT30
------ ------ ------
CLARKADAMSALLEN
KINGFORDBLAKE
MILLERJONESJAMES
SCOTTMARTIN
SMITH TURNER
WARD

View 5 Replies View Related

Reports & Discoverer :: Create A Procedure In Program Unit And Assign Output To A Field In Report?

May 8, 2013

i just want to know how can i create a procedure in the program unit and assign the output to a field in the report.

View 7 Replies View Related

Client Tools :: How To Eliminate Blank Lines In Between Queries In Output

Apr 28, 2010

I am spooling to a text file some output for a client. The file has 4 queries in it, one creates a header row, another a comment row, another the data rows and finally a trailer.

Code looks something like this:

/*
Custom Extract
Project: Plan Data Extract
Product: EOWin 4.02 - Oracle db
Use: Script to create above extract and spool results to text file
Input Parameters: &1 Path and name of output file
*/

[code]....

and the output looks like this:

HDR,04272010,Plan Data

CMT,Plan Num,Plan ID,Plan Name,Shares Allocated

DAT,1,01,Plan 01,99999999
DAT,2,02,Plan 02,99999999
DAT,3,03,Plan 03,99999999
DAT,4,04,Plan 04,99999999
FTR,4

but the client and I want the output to look like this with no blank lines in between the queries:

HDR,04272010,Plan Data
CMT,Plan Num,Plan ID,Plan Name,Shares Allocated
DAT,1,01,Plan 01,99999999
DAT,2,02,Plan 02,99999999
DAT,3,03,Plan 03,99999999
DAT,4,04,Plan 04,99999999
FTR,4

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







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