Reports & Discoverer :: Migration From 6i To 10g - Report Not Generating In Web Layout?
Oct 5, 2010
Im using forms & reports 6i and 10g. I migrated a form from 6i to 10g.The form is working fine, But Im facing problem in report output.When i try to run the report in oracle 10g web layout. It shows error message.
Terminated with error: <br>REP-1247: There exist uncompiled program unit(s). REP-1247: Report contains uncompiled PL/SQL.
When i already compiled the report so many times.
ctrl+k
ctrl+shift+k
ctrl+s
I have made a report with the layout in report it self only.but its showing error
REP-1219: 'F_27' has no size -- length or width is zero. REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error: REP-1219: 'F_27' has no size -- length or width is zero.
if have tried to solve this but it showing error for other field a same error. i am sending a my rdf .
I created a report ...whcih i complied and run on paper layout form.. it shown me on correct dta..but i change change layout size and postion on that viewer..
is it avoidable....if yes, then how ?? I wantto lock these object while previewing...
I am actually having problems with a report that is generating wrong data in Windows 7 only. I have the same report working correctly on many Windows XP Computers.
I made a report that has a report wizard option 'Paper Layout only'. As I finished that, suddenly I realized that I must have to run it also in web. So I must have choose the options both 'paper layout and web layout'.
How can I do that or is it possible to do that without repeating everything that I have done?
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.
Currently am facing a strange issue with reports 10g.I modified the existing report in the server by removing all the exisitng layout fields(10) and adding only one field.
I deployed this in the server and tried to execute the report from UI(OTM). I can see the report is getting called(observed this by adding new SRW messages). but showing the old layout only with 10 fields in it.
I have test in the main section of the layout in forms. I want to print the footer on the first page only. If I go to properties and select print object on first page, it still prints the footer in all pages. How can I force the footer on the first page only.
I have Report in RB 10g , it is showing the logo in PRINT View but when I am running the report in the paper layout it does not showing the logo over there
I am working on modifying various existing reports that other developers have created in the past. I noticed that on some of the layouts I am able to move frames and other objects by very small increments.
Yet in other reports if I try to move something just a tiny but up or down for example, it moves it by a very large increment. Is there some way, or some setting I need to set, in order to be able to move objects by smaller increments?
When i am trying to compile the rdf's, the reps's are not generating. Also while compiling these reports everytime it is asking to add the libraries and it is successfully compiling but the rep's are not generating at all.
I understand when I decrease the width or height of the paper layout, it may cause this error if any of the objects in my report may not fit in the new layout.
But for me this error occurs even when I increase the size of my report paper layout!
I had report A which drill down to report B. While drilling down to report B, The parameter form of report B should be displayed which accept parameter code and then open the report B. My parameter form is displayed but not accepting the input. i am using the hyperlink to display the second report. Is there any cgimap.bat file to be configured for the parameter report? If yes then how to configure this file?
Is there any way of stopping the report from executing in Before-Report Trigger.
Actually what i am doing is to see whether some records are present there in the table in Before-Report Trigger on which the report is going to print. Because I am doing some updates in After-Report trigger. I want to stop if there is no records present in the table in Before-Report Trigger so the report will not go forward to After-Trigger of the report.
how to stop and by using which statement.the other way so that if report has no data then After-Report Trigger should not fired.
[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.
The code works great for few reports and for few reports it gives an error saying Unable to run the reports in 10g, When i checked the job status it says Terminated with error: <br>REP-163: Invalid value for keyword DESTYPE. Valid options are FILE, PRINTER, MAIL, INTEROFFICE, or CACHE.
I have kept the DESTYPE as CACHE. It is failing at Run_Report_Object(ReportId, Pl_Id)
We Implemented Unicode facility in our application, in forms its working fine. But, while running report in pdf arabicCharacters are not displaying Properly.
we did the following settings in uifont.ali [ PDF:Subset ] Arial..Italic.Bold.. = "Arialbi.ttf" Arial...Bold.. = "Arialbd.ttf" Arial..Italic... = "Ariali.ttf"