New to oracle..pls help to open report from form [message #387301] |
Wed, 18 February 2009 15:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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 asSELECT 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|
|