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.
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.
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?
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..?
I know how to append fields to text, but how do I deal with the variable length? I want to place text on a report and inside the text I have data from two different fields. It works great except that my fields are 35 characters long. If the data fills the entire field it looks great, if the data is only 10 characters long, I have a huge gap between the end of the data and the text that follows. How do I fix this?
I have a text field on my layout with 3 lines of text and plenty of space before the end of the text box. When I run the report the second line is shortened and the last two words are moved to the third line. Because I have a carriage return behind those two words, this then moves the original third line to the fourth line. Why does Oracle Reports do this when there is plenty of room and it looks fine in the layout?
I have one report requirement like below diagrams, My report having one repeating frame and one dynamic LOGO field. My repeating frame have 2 field say item_no, and item_name. This repeating frame will grow based on the items say min 1 to max 8 items.
My dynamic logo has some min and max movement position, Say in the below diagram my dynamic logo min movement position is line no 6 and max movement position is 9.
Suppose i have only 1 or 2 or 3 or 4 or 5 items then LOGO should fit in the line no 6, if i have 6 items then logo should come in the 7th line, if i have 7 items then logo should come in the 8th line ect.,like that max 8 item will come in the report, if items are 8 then logo should fit in the 9th line number. ---------------- 1|*****ITEM1****| 2|**************| 3|**************| 4|**************| 5|**************| 6|*****LOGO*****|-- MIN LOGO POSITION 7|**************| [code]......
I have a Report With Group G_Emp, having Columns Eno, Ename etc. in a Repeating frame R_1 and I have put A frame below this repeating frame R_1 with a Text Item Just for Displaying Comments, so just i want to display this Text Item in the second page and the Employee details in the first page, the restriction is that the Text item should not print in the first page.
Well i like to display the Values in Boiler Plate/Text. For Example, i have Report with Address Columns. for Tin No: i have Hard coded as TIN: 34XXXXXX01 and i like to change this hard coded item as TIN: 34XXXXXX02 so during Runtime if the input is changed the above item to be changed.
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?
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);
I want to create a report by using one field and one text as columns name in layout but display the all the columns. I mention the 5 column names in query.how can I write function in summary column.
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...
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
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?
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'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?
