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
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
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
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
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
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
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
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
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
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
Aug 18, 2010
Is it possible to generate .pdf file with password protection.
View 2 Replies
View Related
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
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
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
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
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
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
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
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
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
Oct 27, 2012
how to create link file dynamically in oracle reports 6i
View 3 Replies
View Related
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
Feb 4, 2012
how to create link for uploading file from report
View 2 Replies
View Related
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
Jul 9, 2013
In Oracle Report Builder 11g whenever i set destype to file report Builder Stops.
View 15 Replies
View Related
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
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
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
Jul 5, 2010
how to Run a Discoverer Reports in a Forms Menu.
View 2 Replies
View Related
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