Dears,
I have a little problem. I am willing to run reports via forms. It is giving error. It is my first try to do this. May be I am wrong at some place of coding. I have followed following to run the report. -
- DECLARE
-
repid REPORT_OBJECT;
-
v_rep VARCHAR2(100);
-
rep_status VARCHAR2(20);
-
BEGIN
-
repid := FIND_REPORT_OBJECT('report4');
-
v_rep := RUN_REPORT_OBJECT(repid);
-
END
-
but failed.
Can somebody please clarify the entire process to run a report through forms. I am using Forms/Reports9i.
Thanks.
3 1859
I havent worked on 9i but i think its the same as 6i. Try this code to run u r report. If u dont have any parameters to pass ignore the add parameter part. -
PROCEDURE PU_RUNREPORT IS
-
-
pl_id ParamList;
-
-
BEGIN
-
pl_id := Get_Parameter_List('TEMPDATA');
-
IF NOT Id_Null(pl_id) THEN
-
Destroy_Parameter_List( pl_id );
-
END IF;
-
pl_id := Create_Parameter_List('TEMPDATA');
-
-
Add_Parameter (pl_id , ............);
-
-
Run_Product(REPORTS,<Report Name>,SYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id,NULL);
-
-
END;
-
-
All,
Please makre sure you follow POSTING GUIDELINES when ever you post in this forum
Thanks
MODERATOR
If your report is registered as concurrent program, then you can use below API to submit concurrent program from oracle tools: -
-
Enter the correct values for the Parameters in the call.
-
-
Parameters are as follows:
-
-
application - Short name of the application associated with the concurrent
-
request to be submitted.
-
-
program - Short name of the concurrent program (not the executable) for which
-
the request should be submitted.
-
-
description - Description of the request that is displayed in the Concurrent
-
Requests form (Optional.)
-
-
start_time - Time at which the request should start running, formatted as HH24:
-
MI or HH24:MI:SS (Optional.)
-
-
sub_request - Set to TRUE if the request is submitted from another request and
-
should be treated as a sub-request.
-
-
argument1...100 - Arguments for the concurrent request; up to 100
-
arguments are permitted. If submitted from Oracle Forms, you must specify all
-
100 arguments.
-
-
-
-
---------------------------------------
-
-
-
see that you mentioned only 4 or 5 arguments for the call fnd_request.submit_request.Hopefully you have 100 arguments in your procedure.If not you should add the remaing parameters as the one below.
-
-
FND_REQUEST.SUBMIT_REQUEST('BPSI','OF006011','',SYSDATE,
-
FALSE,v_batch_no,ORG,0,'','','','','','','',
-
'','','', '', '', '', '', '', '', '',
-
'','','', '', '', '', '', '', '', '',
-
'','','', '', '', '', '', '', '', '',
-
'','','', '', '', '', '', '', '', '',
-
'','','', '', '', '', '', '', '', '',
-
'','','', '', '', '', '', '', '', '',
-
'','','', '', '', '', '', '', '', '',
-
'','','', '', '', '', '', '', '', '',
-
'','','', '', '', '', '', '', '', '');
-
-
Sign in to post your reply or Sign up for a free account.
Similar topics
by: CSDunn |
last post by:
Hello,
I have a situation with MS Access 2000 in which I need to display report
data in spreadsheet orientation (much like a datasheet view for a form). If
you think of the report in terms of what...
|
by: Nathan Bloomfield |
last post by:
Does anyone know if there is any documentation which relates to Access2k + ?
or can anyone help adjust the code?
I am having trouble converting the DAO references.
TITLE :INF: How to...
|
by: Bob Alston |
last post by:
I am looking for Access reporting add-in that would be easy to use by
end users. My key focus is on selection criteria. I am very happy with
the Access report writer capabilities. As far as...
|
by: lorirobn |
last post by:
Hi,
I have a report that works just fine.
Now I would like to add the capability to choose selection criteria to
limit what is displayed. I created several reports that do this, but
they used...
|
by: monskie |
last post by:
Hello to all,
I have a problem which could be trivial to you guys. This
concerns opening several crystal reports on the a crystal
viewer on an ASPX page by calling window.open.
My...
|
by: Dave |
last post by:
On my form I have combo boxes. These combo boxes, after updating
them, populate respective listboxes that are located below the combo
boxes on the same form. I am trying to use a "generate...
|
by: creative1 |
last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however,...
|
by: Studiotyphoon |
last post by:
Hi,
I have report which I need to print 3 times, but would like to have
the following headings
Customer Copy - Print 1
Accounts Copy - Print 2
File Copy -Print 3
I created a macro to...
|
by: Gord |
last post by:
When I open a certain report, it runs some code that generates the records
that will be displayed in that report. This works fine. When I go to print
preview the report it appears that the code...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |