Reports & Discoverer :: Modify REP File

Oct 19, 2010

I am working on Oracle reports 6i. Just for R&D purpose I have opened REP file in notepad. In the notepad file I could find the queries which are there in the data model.

I did a small addition to the query and saved it in the same location. I tried to open the modified REP file from RWRUN60, but it is throwing me error saying "REP-0110- Unable to open file".

Original Query in data model:
SELECT empno, sal, job, hiredate
FROM emp;

Modified Query:
SELECT empno, sal, job, hiredate
FROM emp
WHERE deptno in (10,30);

View 1 Replies


ADVERTISEMENT

Reports & Discoverer :: REP-50127 / Cannot Write To File When Trying To Save A Report To A File

Sep 17, 2010

I am receive the REP-50127 error, cannot write to file when trying to save a report to a file on the network via report parameters.

I am guessing the rwserver does not have permissions to the network drive.

Will the SERVER_IN_PROCESS=NO run the rwserver process as the user executing the report?

View 1 Replies View Related

Reports & Discoverer :: Execute RDF File Automatically

Jan 17, 2012

I have an rdf file of version 6i. I need to execute this rdf daily midnight , generate the output as a pdf and send as Mail attachment.

View 1 Replies View Related

Reports & Discoverer :: How To Create Directly PDF File In 6i

Jul 27, 2012

How to create directly pdf file in reports 6i and what type of parameter use and how to use?

View 3 Replies View Related

Reports & Discoverer :: REP-1219 With Text File

Sep 4, 2012

I have a report that runs fine if I run it from the developer whether to preview or to file. The users are running this report from an Oracle Forms app and have a drop down for the destination format. If they run it to PDF for example, the report runs fine. If they run it to TXT132, TXT180, or TXT they get a "REP-1219 'FIELD_NAME' has no size -- length or width is zero".

Of course I am unable to get into the test application right now and as I mentioned above, I am unable to duplicate the error when I run the report from the developer. I am not sure why I would get a REP-1219 only when running to a Text file.

View 9 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 :: From Report To Text File

Dec 24, 2010

I'm working on a report (written with Oracle report builder 6i) for the SMS system.I want the the report results (list of mobile numbers) to be outputted directly into a text file.I have accomplished that with the following parameters:

DESTYPE = File
DESNAME = C:file_name
MODE = character

this work well for the first time but in the subsequent runs, the report rewrite the same file deleting the result from the run before.can I manage to have each run result written in separate file with the name formatted in specific way like (sms_parametervalue_date) or something. or at least is it possible to change the system parameter DESNAME via user parameter at runtime, so I can input the new file name into the parameter form.

View 1 Replies View Related

Reports & Discoverer :: Error On Creating PDF File From A Form?

Oct 14, 2010

When a creating a pdf report in reports 6, under oracle 10g, the error message displayed is: The file is damaged and could not be repaired. If I change the report definition from a pdf to a txt file, the error does not display, but the output has the margings distorted.. It only happens when using reports 6

View 2 Replies View Related

Reports & Discoverer :: Location Of BMP (image File) In Report?

Jul 14, 2011

I just started working for a company and am modifying existing reports. This report has a logo in the layout in the form of an image. Is there a way to find out where this image is located? It cannot find the image when I open the layout or run the report so I assume I am not mapped to the drive/directory where the images are located? Is this information noted anywhere in the actual report?

View 7 Replies View Related

Reports & Discoverer :: Convert Report To Excel File

Sep 23, 2006

How can i convert reports to excel file,in DELIMITED Format ,the report headings also coming in rows .

View 25 Replies View Related

Reports & Discoverer :: Generate PDF File With Password Protection?

Aug 18, 2010

Is it possible to generate .pdf file with password protection.

View 2 Replies View Related

Reports & Discoverer :: Bitmap Is Not Exporting To Excel File

Jan 24, 2012

I have added a bitmap image in my workbook but when i am exporting it into excel or HTML ,only text part of the title is exporting into excel file . The bitmap is only visible in discoverer workbook ,after exporting to excel or HTML, it disappears,

i am using oracle 9i discoverer version 9.0.2.0.

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 :: How To Create Text File Of Report In 10g

Mar 18, 2013

How to create text file of report in 10g ? In reports 6i having default option in menu bar(mail). When clicking the mail option in reorts 6i it will attached to the outlook and we can sent. but in reports 10g not having that Option . It is possible in reports 10g?

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 :: PDF File Turkish Characters Are Not Good

Aug 25, 2010

i use oracle reports6i Report Builder 6.0.8.27.0i previewer reports File>>Generate to File>>PDF then i save the reports as pdf .When i open then pdf file Turkish characters are not good.For exp. (ş=þ ,İ=Ý)

View 2 Replies View Related

Reports & Discoverer :: Export Report 2 Into Excel File?

Oct 15, 2013

I have a report which i export into excel file,now i want --> i export my report into excel file then it (excel file) should automatically saved to my c drive.

View 6 Replies View Related

Reports & Discoverer :: Possible To Convert Small Application To EXE File

Mar 15, 2011

I have a small application with 5 forms and a small database. Is it possible to convert it into an exe file?

View 4 Replies View Related

Reports & Discoverer :: How To Attach Excel File As Last Page Of RDF Report

Aug 3, 2012

I have an .xls file which needs to be the last page of an rdf report. I would prefer to not type up the contents of the file and lay them out. Is there some way I can link this to the footer section or any other alternative?

View 2 Replies View Related

Reports & Discoverer :: Unable To Generate To File XML In Character Mode

Feb 17, 2012

I have a Report which run in character mode format, well i cannot convert or Generate to File as a XML File.

XML Conversion Error:

REP-1401: 'cf_1formula': Fatal PL/SQL error occurred. ORA-01403: no data found

PDF Conversion Error:

REP-1920: Character mode runtime incompatible with DESFORMAT of PDF, HTML, HTMLCSS, or RTF

But, when i change Character Mode to Bitmap or Default i can able to Generate to File.

So i Like to know is it possible to Generate to File in Character Mode?

View 1 Replies View Related

Reports & Discoverer :: How To Create Link File Dynamically In Oracle 6i

Oct 27, 2012

how to create link file dynamically in oracle reports 6i

View 3 Replies View Related

Reports & Discoverer :: How To Generate Matrix Report To Excel File

Aug 22, 2007

how to generate matrix report to excel file. i have done this . but the exact layout is not getting displayed in the excel file. I have attache the layout i ma trying to export to excel.

View 8 Replies View Related

Reports & Discoverer :: How To Create Link For Uploading File From Report

Feb 4, 2012

how to create link for uploading file from report

View 2 Replies View Related

Reports & Discoverer :: How To Create Password Protected Report File In Oracle 11g

Dec 21, 2011

I want to create pdf file of a report with password protection for security reason with. eg. Employee A is logged to run rep1. The pdf file created to his desk with his userid & password.

View 1 Replies View Related

Reports & Discoverer :: Oracle Report Builder 11g Stops When Destype Is File

Jul 9, 2013

In Oracle Report Builder 11g whenever i set destype to file report Builder Stops.

View 15 Replies View Related

Reports & Discoverer :: REP-0118 / Unable To Create A Temporary File In Windows 7

Mar 14, 2012

While Running a Report through form i am getting this below error.

REP-0118 Unable to create a temporary file

But while running the same report in a windows 98 or windowsXp PC i dont get this error.

View 1 Replies View Related

Reports & Discoverer :: When Printing Each Time User Have To Select File / Page Setup

Oct 21, 2011

I have a requirement while A4 printing..When printing each time user have to select file -> page setup -> size(A4)..THEN printing format become A4 Size. How to achieve this one without user have to go on setting.

View 1 Replies View Related

Reports & Discoverer :: Generate A PDF Or HTML File From A Report Previewer / REP-0999 Error

Sep 16, 2002

while trying to generate a PDF or HTML file from a report previewer, I came upon a REP-0999 error message and the previewer was closed!

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







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