I am getting a problem I use lexical Parameter but When I call that through Form my parameter forms didn't call that on report parameter. My query is below as well I have attached all Jpg files to understand. I Didn't getting where I am mistaken.
DECLARE
pl_id PARAMLIST;
BEGIN
pl_id := GET_PARAMETER_LIST('TMP');
IF NOT Id_Null(pl_id)
THEN
DESTROY_PARAMETER_LIST(pl_id);
[code]........
I have added a text field on forms 6i which calls reportAfter adding the new field called "appeal_name" it gave me the desired result for two three times and somehow after that it started to throw this error
ORA- 00933. I did try to find solution on the web and was given the hint that this occurs due to space or indentation in the coding. I have used Ltrim and Rtrim to remove any space when I added the text field "appeal_name", Following code has been added
if
upper(ltrim(rtrim(:appeal_name)))!='ALL' then
where_cond:=ltrim(rtrim(where_cond))||' and upper (tbl_donation.appeal_code)='''||:blk_hsbt.appeal_code||'''';
elsif :appeal_name is null then
where_cond:=ltrim(rtrim(where_cond))||' and tbl_donation.appeal_code is null';
end if;
Created a report object "REPORT62" in Forms Objectnavigator
Trigger on When Button Pressed
DECLARE
rep_id REPORT_OBJECT;
rep_result VARCHAR2(200);
BEGIN
rep_id := find_report_object('REPORT62');
rep_result := RUN_REPORT_OBJECT(rep_id);
END;
Report is called in the property
Filename C:DevSuiteHome_1forms est.rdf
When button is pressed error is raised
There was a failure in the Form server during startup. This could happen due to invalid configuration.
declare
v_show_documentVARCHAR2 (2000) := '/reports/rwservlet?';
v_connectVARCHAR2 (200) := 'userid=scot/tiger@connect_string';
v_report_serverVARCHAR2 (30) := 'rep_cs-oracle';
-- i make this server name by using this command:C:DevSuiteHome_1BIN
wserver server=rep60 start >>when i started it getting to shutdowing directly!!!!! i don't know why
[code].....
the error is:
before the browser is opened!! an error is occur is that:
javaw.exe -Entry point Not found
the procedure entry point kguuseg could not be located in the dynamic link library oraclient10.dll
then the browser is opened ,this error written in it:
REP-52266: The in-process Reports Server rep_cs-oracle failed to start.org.omg.CORBA.OBJECT_NOT_EXIST: vmcid: SUN minor 204 completed: No
i tried to call Report Designer 5.0u Editor (MRD) it is not supported Oracle tools products from form builder Ver6i i try to use RUN_PRODUCT built-in but is not work, how i can call products not supported by oracle like Crystal Reports XI , Report Designer. I located my file in my local PC C: empVD.mrd
View 10 Replies View RelatedI have created a simple form & report based on 2 tables Cust & cntry.I just want to display all customers of region selected in the criteria form. I am uploading the files.
Other than selection criteria report is fine.
How can i pass the parameter from reports to form. means how can i open particular form from my report. means if i write query
select * from emp
this emp table report open now i just want open only emp no 10 form from this report so which parameter i have to pass.
From my form with a single button i need to display a report with a paramter. Report is displaying fine but the parameter is not getting passed. I did the following behined my button i add this
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
plid ParamList;
vParamValue number := 20;
[code]...
If i remove the where condition the whole table data start appearing in the report but adding where condition is not accepting 20 as i send from the FORM Button. And the report with blank data appeared with column headings.
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).
have a customer table with following columns.
1 - Cust_ID
2 - Cust_nam
3 - Cntry_id
I have another table country.
1 - Cntry_id
2 - Cntry_nam
3 - Region
Now I want to view report for all customers of a certain region selected by user in criteria form.How can I do this?
In my application (forms6i) initially data will be displayed in a non-database block after a lot of calculations and validations which is time consuming.
Now, if the user want to print it as a report, we store the displayed data in a dummy table and run the report using that dummy table and then delete records from it.
Is it possible to pass the records displayed to the report as a parameter so that I can avoid Unnecessary add/delete records?
I 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 .
I need to check the condition based what string I am sending. Suppose I am calling with
1.'a,b,c' then it should check all the if blocks.
2.'a,b' then it should check only 'a' and 'b' if blocks.
Is it possible to do so?
DECLARE
a VARCHAR2(5):=0;
b VARCHAR2(5):=0;
c VARCHAR2(5):=0;
PROCEDURE p1(
p_str VARCHAR2)
IS
BEGIN
[code]....... I
I'm trying to execute a dynamic sql that calls a function. But that function has inserts and deletes inside and this way it can't be called through a select statement. And to be worst, it has an other problem, my function uses a record type as parameter.
My code (sample):
-----------------
DECLARE
type r_parameters is record
(cd_query cons_query_param.cd_query%type,
cd_usuario cons_query_user.cd_usuario%type,
nr_param cons_query_param.nr_param%type,
vl_param varchar2(2000),
[code].....
I have a requirement in which I have to call a packaged procedure created in one database DB1 to other database DB2 through a DBLink. The packaged procedure to be called has refcursor as OUT parameter.
When I run the procedure in DB1 , it works fine:
Declare
v_ref_data SYS_REFCURSOR;
a1 Number;
b1 varchar2(100);
c1 varchar2(100);
Begin
apps.XXCU_DB1_PKG.get_DB1('101062','9138', v_ref_data);
FETCH v_ref_data into a1,b1,c1;
dbms_output.put_line(a1|| ' '|| b1|| ' '|| c1);
End;
When I run the packaged procedure from DB2 using DBlink, it gives error:
Declare
v_ref_data SYS_REFCURSOR;
a1 Number;
b1 varchar2(100);
c1 varchar2(100);
Begin
apps.XXCU_DB1_PKG.get_DB1@dblink('101062','9138', v_ref_data);
FETCH v_ref_data into a1,b1,c1;
dbms_output.put_line(a1|| ' '|| b1|| ' '|| c1);
[code]...
I read somewhere on other forums that refcursors can not be passed through the DB links, is it true??
I am trying to open report in parameter form in drill down report.
View 7 Replies View RelatedI 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 RelatedI have a requirement to run below given URL by Stored Procedure. I am using Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
[URL]
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 RelatedI 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 RelatedFor the below query:
SELECT id, pob,exp
FROM emp
where exp= (:exp)or @exp is null
O/P:
id pob exp
_____________________
1 CT 2
2 NJ 3
3 NY 2
It takes only one value of :exp but, I would like to give multiple values separated by ','. My problem is the parameter can be either single value or Blank or multiple values. My code do work for single value and Blank, Now how to implement multiple values .
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 RelatedI 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 RelatedI know lexical parameter concept..but i want a demo report which will use lexical parameter...
View 1 Replies View RelatedI 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 RelatedI 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.
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]...
I am trying to create a report parameter using an lov. You be able to pick one item or return All
The source for my lov is
SELECT l.extkey||' - '||l.longdescr a, l.clocid b
from udm_cloc l, udm_cust c, udm_lde lde
where l.custid = c.custid
and c.ldeid = lde.ldeid
[code].......
But I keep getting an error
'LOV query is invalid, a display and a return value are needed, the column names need to be different. If your query contains an in-line query, the first FROM clause in the SQL statement must not belong to the in-line query.
I have a user requirement where they want to be able to select multiple values for a single parameter that will act as a filter for a report. The possible values for a parameter can come from almost any master data Oracle eBusiness table. I don't want to just present the user with a LOV where they search down a list selecting what they want. That wouldn't be very practical for selecting part numbers from 1000's of rows. I also want the user to easily see what values they have selected. I thought about providing a button that would navigate to a multi-row form where they could record their values and use those values in the where clause of the SQL for the report, but that is a somewhat complex solution I have never tried before. how to do this. I'm working in the latest version 4 of APEX.
View 1 Replies View RelatedI 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'