Reports & Discoverer :: 10g Parameter Form Error?

Sep 26, 2012

While 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.

View 3 Replies


ADVERTISEMENT

Reports & Discoverer :: 10g - Parameter Form - Desname

Sep 3, 2010

In 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 Related

Reports & Discoverer :: Select List Of Values From Parameter Form?

Jun 9, 2012

I 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.

View 1 Replies View Related

Reports & Discoverer :: How To Create Parameter Form In Descriptive Format

Jan 28, 2013

I 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?

View 3 Replies View Related

Reports & Discoverer :: Changing Lov Font Face To Parameter Form

Apr 11, 2012

I 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

View 4 Replies View Related

Reports & Discoverer :: Error On Creating PDF File From A Form?

Oct 14, 2010

When a creating a pdf report in reports 6, under oracle 10g, the error message displayed is: The file is damaged and could not be repaired. If I change the report definition from a pdf to a txt file, the error does not display, but the output has the margings distorted.. It only happens when using reports 6

View 2 Replies View Related

Reports & Discoverer :: Error Message When Passing The Report Parameter From Command Line?

Jan 31, 2012

I 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'

View 1 Replies View Related

Reports & Discoverer :: Can Create Drill Down Report With Parameter Form Of Report

Nov 29, 2011

I am trying to open report in parameter form in drill down report.

View 7 Replies View Related

Reports & Discoverer :: Can Create Drill Down Report With Parameter Form For Report

Dec 19, 2011

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?

View 1 Replies View Related

Reports & Discoverer :: How To Use System Parameter As Currency

Jun 8, 2010

How the use the system parameter as currency, decimal and thousand.

View 2 Replies View Related

Reports & Discoverer :: How To Accept Parameter Between Two Report

Jul 20, 2012

I 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 Related

Reports & Discoverer :: Parameter Passing Through Report

Feb 2, 2012

I 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 Related

Reports & Discoverer :: Destype Parameter Attributes

Oct 21, 2011

Attributes required on the destype parameter list. This attributes are like PRINTER

EXAMPLE:
ADD_PARAMETER(listap,'DESTYPE',text_parameter,'PRINTER');

View 1 Replies View Related

Reports & Discoverer :: Pass Parameter From Forms To Report

Oct 5, 2013

I 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).

View 5 Replies View Related

Reports & Discoverer :: How To Create Report Using Lexical Parameter

Feb 17, 2011

I know lexical parameter concept..but i want a demo report which will use lexical parameter...

View 1 Replies View Related

Reports & Discoverer :: Script To Find Report Parameter

Dec 9, 2011

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.

View 2 Replies View Related

Reports & Discoverer :: Parameter Wise Report Content

Jan 10, 2012

I 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.

View 1 Replies View Related

Reports & Discoverer :: Discover Parameter Default SYSDATE?

Oct 26, 2012

I'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.

View 2 Replies View Related

Reports & Discoverer :: Bind Parameter Defined In Report

Oct 4, 2010

I 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]...

View 2 Replies View Related

Reports & Discoverer :: Using Parameter For Maximum Rows To Fetch To Be A Number

Dec 15, 2010

In 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 Related

Reports & Discoverer :: Hide One Frame And Display Other Depending On Parameter Value

Aug 22, 2010

I want to hide one frame and display the other depending on the parameter value . How could i make that ?

View 1 Replies View Related

Reports & Discoverer :: How To Add Column In Oracle Form

Sep 12, 2010

I would like to know how can i add a column in existing report. I try to change SQL by doing this it does add that new column into group but when i try to run report i can not see that changes . then i try to do some changes in paper layout but i am not able to bring the changes in out put. i am new to this FORMS Reports . do i have to create a group again i am how can i change the layout in that report.

View 4 Replies View Related

Reports & Discoverer :: Multiple Columns In Param Form

Jun 4, 2012

I am adding a parameter to the parameter form of existing reports based on a select statement and has two columns. That part is fine. However, Oracle reports is adding a dash between the two values. Still fine, but I am also adding a UNION with ALL in case the user wants to run the report for all values. In the Parameter form it looks like this:

ALL -
RBC - 111
RRG - 234
TEB - 445

How do I get rid of the dash for "ALL" since I did not physically add it? Below is my select statement for the parameter I created:

SELECT code,
code_num
FROM codes
WHERE code_num <> 0
UNION
SELECT 'ALL', ' '
FROM dual
ORDER BY 1;

View 8 Replies View Related

Reports & Discoverer :: Calling Report From A Form (both 6i) On 11g Database

May 28, 2011

i am facing another problem with 11g database. i am using 6i forms and reports and recently shifted database to 11g 64 bit version. as its 6i forms so i use run_product to call reports. suppose my code for runproduct is in a button, once i press the button to get the print i am getting the logon_screen. if i enter login data again its giving the report.

View 1 Replies View Related

Reports & Discoverer :: ORA-00920 Error In Discoverer

Jun 17, 2008

While executing the query i got an error saying "ORA-0092 - invalid sql query"

SELECT
S.user_je_source_nameSource,
B.nameBatch_Name,
B.default_effective_dateBatch_Eff_date,
B.posted_dateBatch_Posted_Date,
B.default_period_nameBatch_Period,
[code].......

View 2 Replies View Related

Reports & Discoverer :: Calling Report From Form Asking Enter Password

Nov 28, 2010

I am calling a report from Form 6i by using RUN_PRODUCT.After pressing the call button from Form 6i, report is showing box for enterning user id and password.

View 5 Replies View Related

Reports & Discoverer :: Link Two Forms And Pass Employee Name To Next Form

Jul 31, 2010

if i have two reports one of them is that you enter the office name and it will show you list of employee. the second one i want to show the information that is related to that employee by putting beside each employee button that if pressed i will go to other report that show me information about that employee.How i could link the two form and pass the employee name to the next form

View 4 Replies View Related

Reports & Discoverer :: Runtime Error On Reports 6i

Aug 15, 2012

I am using windows 7 and running report from report builder 6i. I got this message error report builder has stopped working. And when i press on show problem details i got this info

Problem signature:
Problem Event Name:APPCRASH
Application Name:RWBLD60.EXE
Application Version:3.0.0.0
Application Timestamp:39c93f24
Fault Module Name:UIW60.DLL
[code].......

Read our privacy statement online:

[URL]........

If the online privacy statement is not available, please read our privacy statement offline:

C:Windowssystem32en-USerofflps.txt

View 3 Replies View Related

Reports & Discoverer :: Report End With Error

Jan 4, 2012

We are using APPS 11i, Yesterday some Report are end with Error. Error Details Given Below.

X Error of failed request: BadWindow (invalid Window parameter)
Major opcode of failed request: 15 (X_QueryTree)
Resource id in failed request: 0x2600001
Serial number of failed request: 614
Current serial number in output stream: 614

View 1 Replies View Related

Reports & Discoverer :: 11g Compilation Error

Aug 22, 2013

I am doing report migration from 10g report to 11g version 11gR2(11.1.2.0.0). It is not converting into REP when I check the logs . I got compilation error, then I convert 10g RDF to 11g RDF and try to compile it in 11g report builder developer tool, It is giving me compilation error.

It is not allowing me any sql in that proc but if i comment it it get successfully compiled and if the same report i open with oracle report 10g it get successfully compile.

Command using for Conversion:
rwconverter userid=<schema_name>/<schema_name>@tns batch=yes source=<source RDF path> stype=rdffile DTYPE=REPFILE dest =<Dest RDF/REP Path> OVERWRITE=yes

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved