I need to customize an oracle report and I am not able to find the header section when I click on the header section in the paper layout. The header info is not on the main section either. But when I run the oracle conc prog the header seciton gets printed. I verified the rdf file if it was correct- it is.
I just have a requirement.Is there any way to write any script which can find the report parameters which are used for its execution so that manual checking for many reports is avoidable as there are about hundreds of reports in our environment.
I've a 6 column report where col5 is set to expand vertically (based upon comments) and works wonderfully. Col6 is a single character column, therefore does not expand so the report looks rather messy.
I would like col6 to expand in accordance to col5. Is it possible?
I have a requirement like this, There is a temporary table with one number column. This column would be updated in between pages trigger. In the header I want to display the value from this temporary table on each page. I tried this by putting a frame and displaying the values, but it displays same value for all the column.
The table is properly getting updated in between pages trigger. I just want to know how to print the refreshed value in the header.
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.
I have set of few hundred reports in Oracle Reports 6i and we have to distinguish them in 3 classes as simple, medium and complex reports. I was wondering what are all the various criterias that should be evaluated to do this .. for example the query behind the report or the layout or graphs complexity etc.
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"
I am beginner to reports working on reports 10g..Actually i have to print addresses of customer on a report. Using one of the layout style i am trying that. But i have a requirement. i need to print only the city name. they should not be any town.. How can i format when town field is null then i should not show town in the report?
its showing report output in a new window, but problem is that if i copy the url, then close current report browser window, start new IE session and paste the copied url it showing the same report... but i don't want to allow this and want to Kill the current job id ( while it displaying the same report ), how i can do this?
when i open one pdf report hyperlink is attached in this report & we can open again a new report through this hyperlink when i click on this hyperlink & return back to main report then it is starting from first page
suppose i m in 4 page & use hyperlink & open new report after that when i return back to main report it starting from first page..is there any solution so that i will return back on same position from where i have click the hyperlink instead of first page
A drill-down report (B) is called from another drill-down report (A) which opens correctly, but when I close report (B) all reports including the master report are closed automatically.
I'm calling sub drill-down report (Report C) from a drill-down report (Report B) using buttons. Report opens correctly but when I tend to close the sub drill-down report (Report C), all reports in hierarchy including the main report (Report A) also close down after raising an exception "An un-handled win32 exception raised in RWRBE60.EXE [3300]"
Report Calling Sequence:- Main Report => Drill Down Report => Sub Drill Down Report