OraFAQ Forum: Reports & Discoverer » New to oracle..pls help to open report from form

Home » Developer & Programmer » Reports & Discoverer » New to oracle..pls help to open report from form (oracle developer suit 10g windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

New to oracle..pls help to open report from form [message #387301]

Wed, 18 February 2009 15:51

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

Report message to a moderator

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

Littlefoot
Messages: 21808
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

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.

Report message to a moderator

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

Littlefoot
Messages: 21808
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).

Report message to a moderator

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

GAN2009
Messages: 25
Registered: January 2009
Location: Phils

Junior Member

Thank you Littlefoot, your suggestions with samples works fine.

Report message to a moderator

Previous Topic:	dynamic reports
Next Topic:	Running Reports 10g on Vista

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 20:00:12 CDT 2024