Reports & Discoverer :: Exclude 1 Group In Report?
Nov 29, 2010I want to show all the data except 1 organization, Report is grouped on organization.
View 2 Replies
ADVERTISEMENT
Reports & Discoverer :: Building Across / Down Group Report?
Nov 25, 2012I have an Across Group Report, but can't create a design / layout what i want (explained more detail as shown on the images).
Current report when it's running:
[URL]
The final layout that what i want:
[URL]
Environments:
- Oracle Developer Reports 10g R2
- Oracle Database 10gR2
Reports & Discoverer :: Selective Sorting On Report Group?
Dec 11, 2010I have a Group report based on one group.For eg..there is machine (Group) and it has detail records .The problem is there are certain specific machine on which i want sorting to be done the rest will be not sorted.
machine WX
Details not be sorted
machine sh4
Details to be sorted
machine sh5
Details to be sorted
machine AN1
Details not to be sorted
Reports & Discoverer :: Group Report From View Sort Differently?
May 20, 2011I encountering while giving ORDER BY CLASS at report query.
View was created from Master and Detail table with simple join after this i created group above report with order by ID (Varchar2 , Values like 0010101001) but in report it order ruffly( not ascending or descending but randomly) .
Reports & Discoverer :: Reference Fields In Detail Group At Report Level
Mar 29, 2012I have a report w/ master group and detail group and at the report level I would like to display a text based on a value of a field in the detail group. I created a column placeholder at the report level and then assigned it a field value in the detail group. I wanted to show my text based on this value, but it did not work.
View 5 Replies View RelatedReports & Discoverer :: PDF Group Wise?
Aug 11, 2010Report have one parameter para name depatwhen i go to generate pdf it will ask me which dept if i pick 10 then they generate one pdf if i pick All Dept then they generate again one pdf i need seperate pdf like 10,20,30,40 generate four pdf files
View 8 Replies View RelatedReports & Discoverer :: Page Break On A Group?
Jun 5, 2003I have a report with 4 groups one above the other and there is data such that each group has certain number of records for a particular value. Now what I want is, to have a page break after each set of data for all the groups. Can this be achieved using format triggers ?
View 3 Replies View RelatedReports & Discoverer :: How To Spill The Group To Next Page
Oct 28, 2010what i need to do so that the Group shown by the RED arrow spills over to next page ?
The image shows that my report is grouped into 4 Levels. Do i simple create a Page Break on Last Group ?
Reports & Discoverer :: How To Print A Report Name With Full Path At Left Bottom On Report
Sep 20, 2012How can i print a report name with full path at left bottom on report.
View 3 Replies View RelatedReports & Discoverer :: Can Create Drill Down Report With Parameter Form Of Report
Nov 29, 2011I am trying to open report in parameter form in drill down report.
View 7 Replies View RelatedReports & Discoverer :: Can Create Drill Down Report With Parameter Form For Report
Dec 19, 2011I 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?
View 1 Replies View RelatedReports & Discoverer :: During Open Report The Discoverer Application Frozen?
Jun 23, 2010When I try to manage the report the Discoverer application frozen.
View 5 Replies View RelatedReports & Discoverer :: Anyway To Stop Report In Before-Report Trigger
Jul 24, 2011Is 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.
Reports & Discoverer :: How To Create Aging Report In Discoverer
May 28, 2010[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.
Reports & Discoverer :: How To Merge Multiple Reports In One Report In 6i
Aug 23, 2011How to merge multiple reports in one report in reports 6i.
View 1 Replies View RelatedReports & Discoverer :: Creating Data Link Using A Column Only Selected In One Group
Dec 14, 2010I have a report with 2 groups Gheader and Glines.The report looks at PO headers and lines. I want to create a data link from the the 2 queries based on the line id in po_lines_all.However I only want to select this in the lines query so I do not get repeating records at the header query.
View 11 Replies View RelatedReports & Discoverer :: Calling Report From Another Report
Aug 31, 2010I created two reports separately.
1.pub.jsp
2.serc.jsp
what i need is i want to call the report serc.jsp from pub.jsp .
Reports & Discoverer :: How To Call A Report From A Report
Aug 17, 2012How to Call a Report from a Report?
Not from a form but a Report from a Report?
Reports & Discoverer :: Single Data Group Should Work For Multiple Type Of Conditions?
Jan 8, 2011Actually I have one query which contains two parameters from_Date and To_date.
if user pass the values for the parameter like 1-dec-2010 to 30-dec-2010 query will works fine and it fetches the values according to the query selected. but now I am going to add one more parameter, the value is 01-apr-2010 now my query should run for 01-apr-2010 to 30-dec-2010.
Here my question is how should I make this scenario with only one query and at the same time the query should work for to scenarios.
Reports & Discoverer :: Report Printing In 11g
Sep 25, 2012I am facing problem while printing from the Oracle Report.. Web.show_document does not print the output of RDF file directly on the printer.
View 1 Replies View RelatedReports & Discoverer :: Unable To Run The Report In 10g
Dec 6, 2012The 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)
Reports & Discoverer :: How To Run Report In Menu
Oct 19, 2011How can I run my report in my main menu or fort page for example I want to run my report when user click a button. What will process?
View 5 Replies View RelatedReports & Discoverer :: Report In Arabic PDF?
Oct 6, 2010 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"
[code]...
Reports & Discoverer :: How To Create Report
Apr 30, 2013I want to create report using this query, is there any option?
declare
cursor c2 is
select epi_id, epi_code, epi_name
[Code].....
Reports & Discoverer :: Report Key Not Found
Nov 4, 2010Have there any limitation on report key(Number of report key) on cgicmd.dat file?
REP-52005: The specified key mrr does not exist in key map file.
But this key 'mrr' exists on cgicmd.dat.
Reports & Discoverer :: One Report Two Pages
Oct 3, 2011i'd like to fit two pages in one report. i.e i'd like to divide A4 paper into 2 pages. How to do that in report 10g . like in the PS
View 2 Replies View RelatedReports & Discoverer :: How To Format A Report
Apr 12, 2011I 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?
View 1 Replies View RelatedReports & Discoverer :: How To Kill A Report Job ID
Jul 6, 2011i used below code to call Report from Form
Function to call procedure to run report:
DECLARE
report_id Report_Object;
v_report_other VARCHAR2(4000);
vc_connect varchar2(50);
BEGIN
--Call run_report_object
[code]......
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?
Reports & Discoverer :: AWR Report On SQL Developer
May 14, 2013How can I run an AWR report through SQL Developer? I do not have EM installed on my Oracle 11g database.
View 1 Replies View RelatedReports & Discoverer :: Hyperlink In PDF Report
Sep 14, 2010when 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