By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,490 Members | 1,489 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,490 IT Pros & Developers. It's quick & easy.

Report Parameter (Oracle9i form developer)

meLady
P: 27
Hello,

I have a report called employees' suggestions that displays all records in a employees' suggesions table, and I attached it in a click button called "View Suggestions Report". on a form.

The idea is when a user clicks the "View Suggesions" button, s/he will see an empty parameter box after clicking the button and before displaying the report.

The user will have to type the "value" in the parameter box for example "January 2007". or any months with any years. (There is a field in Employees' Suggestions table that holds this type of value).

Next the user will press the okay button after entering the parameter value, then a report will appear which will display all the suggestions that were submitted by employees on a specified value (the entered value).

I hope my explanation was clear and if it not, I will be more appreciated to explain again ....

Waiting for your reply.
Apr 15 '07 #1
Share this Question
Share on Google+
4 Replies


meLady
P: 27
any replies to my queries?????
Apr 17 '07 #2

meLady
P: 27
any replies to my queries?????
Any Reply ... Any Answer .. I really need the solution (~_~)
Apr 23 '07 #3

P: 1
use can use function :RUN_PRODUCT(reports,path\\'employees',ASYNCHRONOU S,RUNTIME,FILESYSTEM,Parameter_list(optional),null );

u can use this fuction to call report from forms.
write it on button trgger to call report.



Hello,

I have a report called employees' suggestions that displays all records in a employees' suggesions table, and I attached it in a click button called "View Suggestions Report". on a form.

The idea is when a user clicks the "View Suggesions" button, s/he will see an empty parameter box after clicking the button and before displaying the report.

The user will have to type the "value" in the parameter box for example "January 2007". or any months with any years. (There is a field in Employees' Suggestions table that holds this type of value).

Next the user will press the okay button after entering the parameter value, then a report will appear which will display all the suggestions that were submitted by employees on a specified value (the entered value).

I hope my explanation was clear and if it not, I will be more appreciated to explain again ....

Waiting for your reply.
Apr 25 '07 #4

meLady
P: 27
use can use function :RUN_PRODUCT(reports,path\\'employees',ASYNCHRONOU S,RUNTIME,FILESYSTEM,Parameter_list(optional),null );

u can use this fuction to call report from forms.
write it on button trgger to call report.

Hello Kulbhushan,

Thanks for the code, but I have a question .. is this code just to call the report from form ... I know this function .. but can not see the function that allow the user to input a specified value in the parameter box ... Please read my first post and if there is something the required from me more explanation ... I will be more appreciated to do ... please reply to my question (-_-)
May 5 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.