473,387 Members | 1,493 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Reports problem:I am submitted this code but reports not run.

1
PROCEDURE invoice IS
repid REPORT_OBJECT;
v_rep varchar2(1000);
rep_status varchar2(20);
PL_ID PARAMLIST;
pr_nm varchar2(20):='PNM';
v_rptserver varchar2(10):='oliur';----1
--rwserver server=oliur EXECUTE IT ON RUN
v_host varchar2(20):='localhost';---2

BEGIN
PL_ID:=GET_PARAMETER_LIST(pr_nm);
IF ID_NULL(PL_ID)=FALSE THEN
DESTROY_PARAMETER_LIST(PL_ID);
PL_ID:=CREATE_PARAMETER_LIST(pr_nm);
IF ID_NULL(PL_ID) THEN
MESSAGE('ERROR CREATING PARAMETER LIST '||pr_nm);
RAISE FORM_TRIGGER_FAILURE;
END IF;
ELSE
PL_ID:=CREATE_PARAMETER_LIST(pr_nm);
end if;
--add parameter with separate statement for each parameter
--ADD_PARAMETER(PL_ID, 'P_BDT',TEXT_PARAMETER,:BAZAREXP.BAZARDT); ----3
-- ADD_PARAMETER(PL_ID, 'PSAL',TEXT_PARAMETER,:SALARY);
repid := find_report_object('REPORT77');---4

SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_ MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE, SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CA CHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT, 'PDF'); --pdf/html
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,v_r ptserver);
v_rep := RUN_REPORT_OBJECT(repid,PL_ID);
rep_status := REPORT_OBJECT_STATUS(v_rep);
IF rep_status = 'FINISHED' THEN
/*Display report in the browser */
WEB.SHOW_DOCUMENT('http://'||v_host||':8889/reports/rwservlet/getjobid' ||
substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server='||v_rptserver,'_blank');
ELSE
MESSAGE('ERROR WHEN RUNNING REPORT');
END IF;
END;

I am submitted this code but reports not run.ORACLE 10g
Jul 22 '17 #1
0 3837

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: flupke | last post by:
Hi, i need to develop an app here which will be used to produce stats. I'm going to go with twisted pb for the client server communication. And wxPython for the GUI. Now i would want to split...
0
by: B. Harwood | last post by:
I am researching the value of purchasing Crystal Reports 9 over using the version of Crystal included with Visual Studio. I am currenly using Visual Studio.NET with C#, writing web applications,...
3
by: Mat N | last post by:
Hi, I've been trying to work out how to create a report based on crosstab query for which the number of fields is variable. For example in a situation where you show customer billing by year in...
171
by: tshad | last post by:
I am just trying to decide whether to split my code and uses code behind. I did it with one of my pages and found it was quite a bit of trouble. I know that most people (and books and articles)...
54
by: CoreyWhite | last post by:
The following experiment is a demonstration of TIME TRAVEL. When writing this program, and testing it out I found that sometimes the program would engage itself in time travel but other times it...
2
by: Rod | last post by:
We've got an old VB6 application which has 9 Crystal Reports it can print. These 9 reports are considered by our users to be in essence one "report", in the sense that they are all related and they...
0
by: gabylever | last post by:
Hello, I have the following problem. I want to export a Crystalreports report to pdf from our c# web application. It works fine. The pdf is created but the parmeters set in the code are not used...
1
by: sprt2002 | last post by:
Have inherited a project so I don’t have all the history. We send out a run-time 2000 DB to approx. 300 reps. every year. Some of the reps has Access Pro installed from Office Pro. The Access Pro...
6
by: G. Stoynev | last post by:
I can't seem to be able to prevent a Crystal Reports formula to evaluate an expression when the report contains no records to show. Here's the formula (DateTransferred is a DateTime column): ...
1
by: titli | last post by:
Hi All, Please tell me the best solution to implemenet security in access databases , to save the tables, queries, forms , reports as well as the VBA code from user access. The users of the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
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...
0
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...
0
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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.