I am migrating reports from 6i to 11g.
I am calling report from form. All the reports works fine.
But in this report I have to pass parameter at runtime and report should save in pdf format at a given location.
forms & report version : 11.1.2
Database : 11g
Operating system : windows 7 professional.
Below is the code i am running.
pl_name VARCHAR2(30) := 'tempdata';
repid := FIND_REPORT_OBJECT('MALWADKARCONSUMPTIONSTMTDBR1');
pl_id := Create_Parameter_List(pl_name);
is the location "'D:\dbr...." where you want the report output to be saved a client folder or a folder on the Reports Server Machine? It needs to be a folder on the machine where Reports Server is running.
if you want to save the report output on the client side then you can display report output on screen and then allow end-user to save it where they want. If that is not a valid option you can use WebUtil functionality to allow transfer report
output from server to the client.
Regarding to the reports server not starting. If you are using a standalone reports server then make sure you start it via opmnctl command. If you are using in-Process Reports Server then make sure WLS_REPORTS is up and running.
Check if reports server is running with the following URL.
http://hostname:port/reports/rwservlet/showjobs?server=<reports server name>
from the code you pasted you have the following.
That means that you are using a standalone reports server but that is the code that you are using in your development environment. You need to decide which reports server are you going to use in your deployment environment and then
change that parameter there. If you will use the in-process reports server then you do not need to pass the name of the reports server because by default it is defined in rwservlet.propeorties file so the report request will be send to in-process by default.
as stated before if the desname value is pointing to the client filesystem it wont create the output there because Reports Server is not running on the client, it is running on the server as this is the way it is.
If you want to save output to the client you need to use the options mentioned before.
For testing purposes only change your code as follows.
Add_Parameter(pl_id,'DESNAME',TEXT_PARAMETER, 'c:\'||vACNAME||' '||:BLOCK50.DOCDATE||'.PDF') ;
As you can see I changed the original folder name to C:\ .. (I hope your reports serve is running on a Windows machine if not then changed to /tmp). Run your form and check c:\ or /tmp and see if you see the report output there. If so,
than your code is fine the only problem is what I have already stated.