469,333 Members | 4,185 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,333 developers. It's quick & easy.

Report Parameter (Oracle9i form developer)

meLady
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
4 2056
meLady
27
any replies to my queries?????
Apr 17 '07 #2
meLady
27
any replies to my queries?????
Any Reply ... Any Answer .. I really need the solution (~_~)
Apr 23 '07 #3
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
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.

Similar topics

1 post views Thread by Nathan Bloomfield | last post: by
2 posts views Thread by Lloyd Stevens | last post: by
reply views Thread by bprasanth | last post: by
3 posts views Thread by Richard Hollenbeck | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.