Reports & Discoverer :: Tool For Version Control In PL/SQL
Dec 7, 2010Is there a free software or tool for oracle reports version control? I need to maintain versions for Oracle reports and PL/SQL codes but not sure how to proceed.
View 2 Replies
ADVERTISEMENT
Reports & Discoverer :: How To Run Version 10g Report In Builder 6i Version
Jun 3, 2010I have a report of version 10g . I want to run this report in oracle reports 6i version.
View 1 Replies View RelatedReports & Discoverer :: Warning / Opening Report Saved With Newer Version Of Builder
Jan 17, 2012In our office one of our pc was worn out and d2k source files in the server were not able to open in another system for that we need to install the below D2k6i Version of Report;
Report Builder 6.0.8.24.0
if we try to open the file it shows the below error
"Warning: Opening a report saved with a newer version of Report Builder. Functionality may be lost. Continue? "
Currently we are using "Report Builder 6.0.8.11.3" is it possible to download the 6.0.8.24 version?
Reports & Discoverer :: Control Pages Dynamically Before Printing?
May 23, 2011I just want to ask that can we code number of pages to be printed before printing the report?
Like if we use report builder software of oracle to print a report, this will ask that how many pages you want to print and no of copies you want to make for this report as normally asked with other software before printing.
Actually, I am stuck with a complex query report where every single page has different query to execute. The problem with my report is that when ever user prints the report, the last page comes empty with the page header, no data in it.
What I want is to code, if possible, to print the report avoiding the last page to print. So that every time I can able to control printing pages. For example if report has 10 pages and definitely has data on 9 pages then it can only print up to 9 pages rather than going to print 10 pages.
Reports & Discoverer :: Control Print Job From Oracle Report?
Sep 23, 2005How I control hte print job from Oracle Report. The problem is that If I do a report and print out, there should not be allowed to any user to print again. Here I also want to control the user list who can print a report.
[URL]
Forms :: 10g Version Control
Mar 17, 2010Oracle's Software Configuration Manager version 10.1.2.5 with forms version 10.1.2.3.0:
Is this what everybody is using to manage their forms development? If not, what are developers using for Forms 10g version control? I've installed this software. I'm using the Oracle XE database for this repository. At least for running through the tutorial to figure out how this is to work.
I have to say that I am frustrated that I cannot compare one version of a form to another version of the same fmb. I get a java null pointer exception. I have uninstalled the repository using RAU, then recreated it using the RAU. I'm using version control and defining a "large" repository type for more than 10 developers.
Reports & Discoverer :: How To Run Discoverer Reports In A Forms Menu
Jul 5, 2010how to Run a Discoverer Reports in a Forms Menu.
View 2 Replies View RelatedClient Tools :: Basic Tools For Oracle Version Control
Aug 26, 2011I'm looking for 3 simple things.
1) A reverse engineering tool that I can point to an Oracle schema and get a "baseline" script to re-create that schema from scratch, with decently formatted DDL files (1 per object) neatly organized in a directory tree (by object type) and called in the correct order. Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to populate (insert) those tables as part of the script.
2) a diff tool that I can point to a pair of Oracle instances (source and target) containing a given schema and get a "delta" script to alter the target schema so that it becomes identical to the source schema. If data loss occurs on the target instance (i.e. drop a column) I would like to find a warning comment inserted in the script (e.g. "-- Attention: data migration DML needed here?"). Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to update (delete, update and insert) the data in the target tables to become identical to the contents in the source tables *without* deleting and re-inserting all rows (or dropping, recreating and repopulating the table).
3) I would like the above two tools (that, as you will have recognized, are basic to putting your database design under version control) to be open-source, with a command-line interface and a vibrant community backing them.
Reports & Discoverer :: Launching Discoverer Viewer From Forms Menu
Dec 6, 2011Is it possible to link to Discoverer Viewer from Forms without requiring the user to log in again. If so, can I then link to a specific Workbook within Discoverer?
View 2 Replies View RelatedReports & Discoverer :: Oracle Apps Data Does Not Show In Discoverer
Mar 19, 2012When running my query in sql developer, I have to execute the command apps.fnd_global.apps_initialize(user_id, resp_id, resp_appl_id) in order to show the result of my query. Without this, the query returns nothing. The problem is I am using this query as a custom query for my Discoverer report and my report does not show any record.
View 3 Replies View RelatedReports & Discoverer :: Discoverer Admin - How To Copy Folder From One Instance To Another
Nov 9, 2011I need to copy my discoverer report from dev to prod. How should I do this? Are the items created using calculation in the report can also be copied? These items are not present in the folder in discoverer admin.
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 :: Provide Download Link To Blob In Database On Oracle Reports?
Aug 8, 2013My user would like to have a way to attach files to database records. For simplicity, we'll say that each employee in the database could have 0-many file attachments associated with them. I know how to make this part work using Oracle Forms.
So that's the easy part for me. The tough part is that they want to be able to run an Oracle Report on our application server (displays as a PDF, also downloadable as a PDF) and have links on this report to the attachments that they uploaded using the forms process above.
For the idea of storing the files on a folder somewhere, I simply created a text object on the report that had it's hyperlink property pointing to the file location. Done.. opens fine.
However, I want to be able to have the option of storing these files in the database instead, just in case we can't go with the shared folder idea. I'm not sure how to make this work. I can store a blob in the database.. but how do I link to that blob on the report for them to be able to download it? Is this even possible?
how to create a download link on the Oracle Report that let's them download a file out of the database.
Reports & Discoverer :: Text Bold - Format Particular Word In Oracle Reports At Runtime?
Nov 2, 2010I 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..?
Reports & Discoverer :: How To Call Oracle Reports Inside A Stored Procedure
Oct 14, 2010Currently some jobs created in WBT scripting need to converted into oracle,plsql.There is one job in WBT scripting, which will invoke the oracle reports inside and generate the PDF files in the destination path as follows:
a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?USERID=%LOGONINFO%+server=rep_pscm9722+destype=file+desname=D:ORACLE10G\%CCALLRptName%+desformat=PDF+PARAMFORM=no+report=PCCALL.RDF")
a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?
[code]...
Now, i want to convert this into oracle,plsql? Is it possible or not?
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 :: Oracle Reports Text Formatting As Runtime?
Aug 26, 2013I need the below output in oracle reports 6i.
this is a testing string retrieved from database.
now what i need is that to make bold the specific words in a string came from database.
Reports & 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 Create Oracle Reports With Java Barcodes
May 24, 2010how to create Oracle Reports with Java Barcodes.
View 8 Replies View RelatedReports & Discoverer :: Bind To Reports Server Rep_wwubh01ap45 Failed
Jun 9, 2006While accessing the reports i am getting the following error
Rep - 51002 : Bind to Reports Server rep_wwubh01ap45 failed.
I have checked the file $ORACLE_HOME/reports/conf rwservelet.properties. The parameter SERVER=rep_wwubh01ap45 was present in that file.
Reports & Discoverer :: Hiding Reports Server Window - Specify Cmdkey
Jul 19, 2011We have a reports proces which we want to produce a report where the browser windows doest not display, or if it does, quickly closes after the report is completed.We are using Forms Version 10.1.2.0.2, Oracle Database 10g Release 10.2.0.4.0, OS is Windows XP Pro SP3
We have tried the below, but the primary application window closes, not the report server window.
- http - removed due to form message:You cannot use links until you have posted more than 5 messages.
WEB.SHOW_DOCUMENT(://'|| :global.Report_Server_Name ||
'/reports/rwservlet?cmdkey=ky10i&report='||v_rep_object||'.rdf' ||
'¶mform=no&desformat=pdf&destype=file&desname='||v_file_dir||
'&P_VOU_ID='||'883100000000000005565047129970'||
[code]...
We have modified the forms trigger to produce the report as shown below, but get the error:
FRM-41213: Unable to connect to the Report Server
Current theory is the connection to the database is lacking the user id and password since the cmdkey is not specified. How can we specify the cmdkey when using the run_report_object?
= = = = = = = = = = = = = = = = = = = = = =
DECLARE
v_rep_tx VARCHAR2(100);
v_RepStatus VARCHAR2(2000) := '';
v_rep_idREPORT_OBJECT;
v_repVARCHAR2(100);
[code]...
Reports & Discoverer :: Column Headers Repeating In Oracle Reports 10g
Mar 19, 2013I'm using Report Builder 9.0.4.0.33.
I am creating a report which generates the data to a PDF/CSV based on users Input.When I create the report using Report Builder and execute the report,Delimited data appears in a PDF layout.
But if I add the below code in After Parameter Form trigger,the column headers keeps repeating with the data.
function AfterPForm return boolean is
begin
IF :P_DESTYPE = 'CSV' THEN
:MODE :='DEFAULT';
:DESFORMAT:='DELIMITED';
Elsif :P_DESTYPE = 'PDF' THEN
:DESTYPE := 'CACHE';
:DESFORMAT:='PDF';
END IF;
return (TRUE);
end;
[code]....
But the PDF output seems fine where the header is shown only once.I could see many posts regarding this in Oracle reports 6i wherein delimited_hdr=no is used in Command Line but I would like to know the work around in Oracle reports 10g.
Reports & Discoverer :: Calling Reports From Stored Procedures?
Feb 23, 2011Is there a way to call an oracle report (version 9i) from a stored procedure?
View 2 Replies View RelatedReports & Discoverer :: Automate Oracle Reports Execution
Feb 10, 2012Any way to automate a job to execute several Oracle Reports to run at the end of every month and either email them to a list of people or possibly save them to a location on a network drive.
At first, I started out with 2 avenues of thought:
1) The following link raised the option of an Oracle Scheduler, but from my research, the scheduler only runs database jobs, shell scripts, batch files, etc.:
[URL]......
2) I was thinking about possibly creating a database job of some sort to call the reports, but from the following link, I've determined that one cannot create+call a stored/database procedure to run Oracle Report files. So there goes my second hope.
[URL].......
So, it appears that the scheduler won't meet my requirements and now I think I'm almost out of options.
My last resort is creating a database job that queries required information and spooling the data + various formatting "stuff" into a txt file. Then, that txt file would be my report. This seems a little savage and I would like to think that there's a ay to automatically run an .REP against a database and save an electronic copy of the report somewhere.
Is it possible to automate the execution of Oracle Reports and then saving the report in a particular format (xls/pdf/rtf/etc.)?
Reports & Discoverer :: How To Capture Runtime Reports In A Table
Jun 16, 2011i have created a report in dis report i created bind parameters..how to capture these parameters into a table(for this i hav created a new table) means if i pass delivery_id at runtime
i need to insert this value into what ever i hav created table next time if i pass same value i need to update that record where should i write dis code in a report and can any one send script for this.
Reports & Discoverer :: Moving Fields In Oracle Reports?
Nov 13, 2010In my requirement i have to move a field from bottom to the first page of report. I try to drag the field but i think it's in multiple frame .i am very new to oracle how can i work with multiple frame in layout wizard.
View 2 Replies View RelatedReports & 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 :: Could Not Connect Reports Builder To Database
Jun 29, 2012I could not connect the reports builder to the database. Im trying to connect it to the XE database. I checked the tns names and the hosts. Everything seems to be fine. But still when i try to connect the report it throws an error "ORA 12541- tns no listner"..
View 11 Replies View RelatedReports & Discoverer :: Object Alignment In Oracle Reports
Oct 25, 2011I am unable to properly align two objects in the layout editor in Oracle Reports. The form report I am trying to design must be perfect and I need to highlight a particular report object (data item) by adding a narrow box (boilerplate) next to it on the left hand side, which is filled with a contrasting colour and contains an asterisk.
The problem is this: I cannot seem to align them properly (horizontal stack, align top). Even if I use the 'size objects' option to make them exactly the same vertical size, the align option stated above does the horizontal stack, but vertically they are not aligned - nor can I manoeuvrings the boilerplate box into place manually.
Reports & Discoverer :: Reports Place Holder Column
Jun 18, 2013I want to show closing balance as opening balance by using place holder column
example
Date opbal sale closing bal
01-jun-2013 0 10000 10000
02-jun-2013 10000 5000 15000
how to do this