| Forms and Reports [message #279327] |
Wed, 07 November 2007 17:09  |
mnanias
Messages: 40
Registered: September 2007
Location: AMERICA
|
Member |
|
|
Hi,
Thanks it worked well.
I have one more doubt on forms.I am using oracle 10g i have forms 10g and report builder 10g installed in my system.So now i have created a report using report builder and i wanted to call that report and print that report thru forms which i have build using form builder.I have used fin_report_object,run_report_obj and all other inbuild func for the report but the error msg i get is report not found and after few days i came to know that they put reports in a diff DB for example i use x DB and the reports are in Y DB how can i call that report thru this when i click a button report should be generated accordingly by the parameter i pass and that should be printed.
Can u please help me in this i am trying to solve this from past few weeks and i am not able to.
Thank You.
|
|
|
|
|
|
| Re: Record_property [message #279494 is a reply to message #279327] |
Thu, 08 November 2007 15:53  |
mnanias
Messages: 40
Registered: September 2007
Location: AMERICA
|
Member |
|
|
Hi,
AS we have to run buttons on the report builder one is for weblayout and other is for paper layout.When i do weblayout i am not able to run the report i am getting an error and when i look into the error file it says server no initialized,so i started using paperlayout.After few days my admin gave me a link and told me that all the reports are save in different schema and to run the report i need to use that link for example
***
https://www7.sis.xyz.edu:4445/ylreports/rwservlet?server=ban2rpt&report=testgsp.rdf&destype=cache&desformat=pdf&useri d=@sfa2
****
so now when i upload my report.rdf file into the univ server and when i run this link with my report name in place of testgsp.rdf i am able to run the report in pdf format so for now i am able to do that and as u told i used web.show_document('above link') and it worked but the problem is if i want to give parameters to it how can i do that.How can i pass parameters to the above link i tried by using &and parameter value in the parameter column for emp: &batch_id = :parameter.batch_id which is a parameter in my form.
So wat u want me to do.Please help me in this.
Thank You.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Record_property [message #282315 is a reply to message #281175] |
Wed, 21 November 2007 08:26 |
mnanias
Messages: 40
Registered: September 2007
Location: AMERICA
|
Member |
|
|
Hi,
Thanks for ur help.Report is working i used web.show_document() function and i have changed server name in rwservelet properties and every thing went fine.
Thank You,
Nagesh.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
