Home » Developer & Programmer » Reports & Discoverer » New to oracle..pls help to open report from form (oracle developer suit 10g windows)
New to oracle..pls help to open report from form [message #387301] Wed, 18 February 2009 15:51 Go to next message
GAN2009
Messages: 25
Registered: January 2009
Location: Phils
Junior Member
Hi oracle experts,

I know this topic has been asked many times but it seems I'm not able to follow as I said I am very new to oracle. My problem is how to open a report from a form depending on what been selected from menu. The selection from my menu is 2008 or 2009. If I select 2008 I want to open report but only 2008 report should show up. How to pass the value 2008 on the report?

My report query is
SELECT PNT_RECORDNO, NAME, ADDRESS FROM TBL_MAIN WHERE
ENTERED_YEAR = ??????? - how to put the value here base from form?

I'm only running my form & report from my machine.

Please help



Re: New to oracle..pls help to open report from form [message #387359 is a reply to message #387301] Wed, 18 February 2009 23:54 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Values are transferred as parameters - let's call it "par_year". It means that you'll have to create a user parameter "par_year" in the report's Object Navigator and use it in report query as
SELECT list_of_columns 
FROM some_table
WHERE year = :par_year

As you use Developer Suite 10g, you should probably investigate use of the WEB.SHOW_DOCUMENT when calling report from a form.

[EDIT: a typo]

[Updated on: Wed, 18 February 2009 23:54]

Report message to a moderator

Re: New to oracle..pls help to open report from form [message #387493 is a reply to message #387359] Thu, 19 February 2009 08:44 Go to previous messageGo to next message
GAN2009
Messages: 25
Registered: January 2009
Location: Phils
Junior Member
Hi Littlefoot,

I know a little about web.show_document. I used it to open my report without parameter and it works perfectly fine. But now that I need to include the parameter how will I do that? If it's not too much to ask, kindly give me a sample code I would put in my form menu.

Thank you very much.
Re: New to oracle..pls help to open report from form [message #387516 is a reply to message #387493] Thu, 19 February 2009 12:50 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Something like
web.show_document('http://127.0.0.1:8889/reports/rwservlet?
report=c:\some_report.jsp&destype=cache&desformat=htmlcss
&userid=scott/tiger@ora10
&par_year='||:my_year_parameter);
(note the last line).
Re: New to oracle..pls help to open report from form [message #387759 is a reply to message #387516] Fri, 20 February 2009 08:42 Go to previous message
GAN2009
Messages: 25
Registered: January 2009
Location: Phils
Junior Member
Thank you Littlefoot, your suggestions with samples works fine.
Previous Topic: dynamic reports
Next Topic: Running Reports 10g on Vista
Goto Forum:
  


Current Time: Fri Dec 09 19:22:52 CST 2016

Total time taken to generate the page: 0.09758 seconds