Reports & Discoverer :: Execute RDF File Automatically
Jan 17, 2012I 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
ADVERTISEMENT
Reports & Discoverer :: How To Call Report Automatically
Sep 3, 2012Is it possible to automate the execution of some reports build with Oracle report builder? Like I want to run such and such report to run daily at 2:00pm or at the end of every month/year.
View 5 Replies View RelatedReports & Discoverer :: How To Execute Oracle Reports On A Developer Machine
Mar 25, 2013I 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.
Reports & Discoverer :: How To Close Window Automatically Without Manual Intervention
Oct 20, 2010I am running a report which is called for a set of employees picked up in the cursor. For each employee the report is run in a different window. However, the report runs fine and the output gets saved in the local machine but the window doesn't get closed automatically.
How to close the reports window automatically without manual intervention?
Reports & Discoverer :: How To Execute Query 2 If 1 Doesn't Retrieve Anything
Dec 3, 2010In oracle report how do we execute query2 if query1 doesn't retrieved any records.
View 4 Replies View RelatedReports & Discoverer :: Value In Table Column Based On Some Existing Column Value Automatically Without User Intervention
May 15, 2011i have two questions.
(1) how can i fill some value in a table column based on some existing column value automatically without user intervention. my actual problem is i have 'expiry date' column and 'status'. the 'status' column should get filled automatically based on the current system date. ex: if expiry date is '25-Apr-2011' and current date is '14-May-2011', then status should be filled as 'EXPIRED'
(2)hOw can i build 'select' query in a report (report 6i) so that it will show me list of items 'EXPIRED' or 'NOT EXPIRED' or both expired and not expired separately in a single report based on user choice. 'EXPIRED' & 'NOT EXPIRED' can be taken from the above question no. 1.
Reports & Discoverer :: REP-50127 / Cannot Write To File When Trying To Save A Report To A File
Sep 17, 2010I 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?
Reports & Discoverer :: Modify REP File
Oct 19, 2010I 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);
Reports & Discoverer :: How To Create Directly PDF File In 6i
Jul 27, 2012How to create directly pdf file in reports 6i and what type of parameter use and how to use?
View 3 Replies View RelatedReports & Discoverer :: REP-1219 With Text File
Sep 4, 2012I 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.
Reports & Discoverer :: RDF File Run Without Data Using Forms
Jun 30, 2011I 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.
Reports & Discoverer :: From Report To Text File
Dec 24, 2010I'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.
Reports & Discoverer :: Error On Creating PDF File From A Form?
Oct 14, 2010When 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 RelatedReports & Discoverer :: Location Of BMP (image File) In Report?
Jul 14, 2011I 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 RelatedReports & Discoverer :: Convert Report To Excel File
Sep 23, 2006How can i convert reports to excel file,in DELIMITED Format ,the report headings also coming in rows .
View 25 Replies View RelatedReports & Discoverer :: Generate PDF File With Password Protection?
Aug 18, 2010Is it possible to generate .pdf file with password protection.
View 2 Replies View RelatedReports & Discoverer :: Bitmap Is Not Exporting To Excel File
Jan 24, 2012I 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.
Reports & Discoverer :: Suppress Duplicate In Output File
Feb 16, 2010In 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 RelatedReports & Discoverer :: How To Create Text File Of Report In 10g
Mar 18, 2013How 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 RelatedReports & Discoverer :: Rename Report Output File
May 10, 2012I'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 RelatedReports & Discoverer :: PDF File Turkish Characters Are Not Good
Aug 25, 2010i 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 RelatedReports & Discoverer :: Export Report 2 Into Excel File?
Oct 15, 2013I 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 RelatedReports & Discoverer :: Possible To Convert Small Application To EXE File
Mar 15, 2011I 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 RelatedReports & Discoverer :: How To Attach Excel File As Last Page Of RDF Report
Aug 3, 2012I 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 RelatedReports & Discoverer :: Unable To Generate To File XML In Character Mode
Feb 17, 2012I 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?
Reports & Discoverer :: How To Create Link File Dynamically In Oracle 6i
Oct 27, 2012how to create link file dynamically in oracle reports 6i
View 3 Replies View RelatedReports & Discoverer :: How To Generate Matrix Report To Excel File
Aug 22, 2007how 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 RelatedReports & Discoverer :: How To Create Link For Uploading File From Report
Feb 4, 2012how to create link for uploading file from report
View 2 Replies View RelatedReports & Discoverer :: How To Create Password Protected Report File In Oracle 11g
Dec 21, 2011I 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 RelatedReports & Discoverer :: Oracle Report Builder 11g Stops When Destype Is File
Jul 9, 2013In Oracle Report Builder 11g whenever i set destype to file report Builder Stops.
View 15 Replies View Related