Reports & Discoverer :: How To Use System Parameter As Currency
Jun 8, 2010How the use the system parameter as currency, decimal and thousand.
View 2 Replies
ADVERTISEMENT
Reports & Discoverer :: Customized System On Oracle 10g
Jun 30, 2011I have customized system on oracle 10g ( English interface and reports ) , the company want to make the system in both (Arabic and English) , i make every thing is okay , but the problem when i change the PDF subset in the file uifont.ali to include Arabic fonts , the report server every 2 hours stopped and give me the message ( server is in progress ) ,
View 1 Replies View RelatedReports & Discoverer :: 10g Parameter Form Error?
Sep 26, 2012While calling a report I am getting the following error.
REP-546: Warning: The value of restricted LOV parameter TOPROFIT is not among the selectable values.
When I call the same report through another PC it displays parameter form.
I am using Report Builder 10g.
Reports & Discoverer :: How To Accept Parameter Between Two Report
Jul 20, 2012I am running rep_1, and before executing second rep_2 the user should enter department number, after accepting department no, the second rep_2 should be executed. But after accepting parameter the second rep_2 is not displaying any record.
View 1 Replies View RelatedReports & Discoverer :: Parameter Passing Through Report
Feb 2, 2012I had created drill down reports. rep_1 dispalying various Location_cd. by clicking location_cd The parameter form of rep_2 is displayed in which location_cd is displayed which is already selected and accept dept_cd from user. While running the rep_2 the parameter location_cd is passing null value.
View 1 Replies View RelatedReports & Discoverer :: Destype Parameter Attributes
Oct 21, 2011Attributes required on the destype parameter list. This attributes are like PRINTER
EXAMPLE:
ADD_PARAMETER(listap,'DESTYPE',text_parameter,'PRINTER');
Reports & Discoverer :: 10g - Parameter Form - Desname
Sep 3, 2010In the parameter form in my report I want to give user the facility of browsing the location where he/she wants to store the report. how can I accomodate the same?
View 1 Replies View RelatedReports & Discoverer :: Pass Parameter From Forms To Report
Oct 5, 2013I can not Pass parameter from forms to Report.
I use three parameter for report. I want to show the employee who has been hired between from_date to_date,it work well in report builder. but I want to pass parameter from forms to report and pdf format. I upload my work (this is actually a zip File, change file type txt to zip just before open).
Reports & Discoverer :: How To Create Report Using Lexical Parameter
Feb 17, 2011I know lexical parameter concept..but i want a demo report which will use lexical parameter...
View 1 Replies View RelatedReports & Discoverer :: Script To Find Report Parameter
Dec 9, 2011I 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.
View 2 Replies View RelatedReports & Discoverer :: Parameter Wise Report Content
Jan 10, 2012I developed a report for bar code and it is running well.the contents in one bar code are Item name,code,price.I designed 4 pieces in a page and generate also 4 pieces in a page.
But Now I want to generate the report with a parameter where I can mention how many copies of bar code will generate in a page for this specific item.
If I put 3 pieces in parameter then bar code will generate 3 pieces. or so and so.
Reports & Discoverer :: Discover Parameter Default SYSDATE?
Oct 26, 2012I've hunted everywhere, and I'm beginning to think this is impossible, however I'll give it a shot...
I would like my Discoverer report start date/end date to default to YESTERDAY.
Reports & Discoverer :: Bind Parameter Defined In Report
Oct 4, 2010I Created a Bind parmeter in report .....but when i run report it show only loc bind parameter not fyyear bind parameter...
Code is :
SELECT distinct BPT_LOC Location, BPT_DOC_DT BNP_REF_DT, BPT_DOC_NO BNP_REF_NO,
BPT_VEN_NM Vendor_Name,
BPT_BIL_NO Bill_No, BPT_BIL_DT Bill_Date ,
E.BMDT_CNTRCT_CD CONTRACT_NO,
BPT_NET_VOU Total_Amount, BPT_SAL_RT VAT_AMOUNT,
[Code]...
Reports & Discoverer :: Select List Of Values From Parameter Form?
Jun 9, 2012I am trying to select multiple values from a parameter form based on a select statement.
I created the parameter and write the select statement under list-of-value property However what I want is to let users choose multiple values from the select statement not only one value.
Reports & Discoverer :: Using Parameter For Maximum Rows To Fetch To Be A Number
Dec 15, 2010In Report it is possible to set the maximum rows to fetch to be a number e.g. 1+.Is it possible to use a number that is selected from another query? When I try to do this i.e. I put in the field num_lines or :num_lines I just get invalid number
View 10 Replies View RelatedReports & Discoverer :: How To Create Parameter Form In Descriptive Format
Jan 28, 2013I have developed report in reports9i and executing this report at application server but the parameter form is not displaying as its displayed in report builder.
parameter form isn't in descriptive format like you can check the department field. how to create parameter form in descriptive format or I am doing any mistake?
Reports & Discoverer :: Hide One Frame And Display Other Depending On Parameter Value
Aug 22, 2010I want to hide one frame and display the other depending on the parameter value . How could i make that ?
View 1 Replies View RelatedReports & Discoverer :: Changing Lov Font Face To Parameter Form
Apr 11, 2012I need to change the font face from following lov value for parameter form, How?
SELECT DISTINCT CODE_ENTRY.VILLAGE_NAME, CODE_ENTRY.UNIONN_NAME
FROM CODE_ENTRY
Reports & Discoverer :: Error Message When Passing The Report Parameter From Command Line?
Jan 31, 2012I prepared a report in Oracle reports and trying to run the report through command line by creating a batch file. but i am getting the following error message when i run the batch file
REP-0069: Internal error
REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output
the batch file is as follows
D:DevSuiteHome_1BINRWRUN p:spannawazeitspanna_wa_zeit.Rep userid=alrayatec/alrayatecprod@alraya.world
DESFORMAT=HTMLCSS DESTYPE='mail' DESNAME='sarfraz_it@hnd.com'
Reports & 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 RelatedPerformance Tuning :: Update Currency Column Of One Table Using Other Table Currency Column?
May 11, 2012I am trying to update currency column of one table using the currency column of other table using the following sql code.
update ODS.SO_ITEM OSI
set CURRENCY__CODE=(select currency__code from sa_sales.SO_ITEM SSI where SSI.ID=OSI.ID)
This update is taking taking a lot of time and is never ending.
should i create index on source table (SA_SALES.SO_ITEM) or on target table (ODS.SO_ITEM) ?
Replication :: ORA-00119 / Invalid Specification For System Parameter
Dec 28, 2007I am getting errors while starting up my database using command 'STARTUP'
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL2'
have a look on sqlnet.ora , tnsnames.ora, listener.ora
sqlnet.ora
# sqlnet.ora Network Configuration File: c:oracleproduct10.2.0db_2
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
[code]....
RESUMEABLE Parameter / No Space Left On File System Export Fails
Dec 2, 2010I have some question about the parameter RESUMABLE 10G. My quesition is suppose if i am running a expdp process and if there is no space left on the file system the export fails. So in this case if we set the RESUMABLE parameter in the DB will it be useful to resume the expdp from where it fails or it will useful if we schedule a job for the export.
View 2 Replies View RelatedReports & 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 RelatedReports & 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.