Report Parameter (Oracle9i form developer)

[meLady]

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.

[meLady]

any replies to my queries?????

[meLady]

any replies to my queries?????

Any Reply ... Any Answer .. I really need the solution (~_~)

[Kulbhushan]

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.

[meLady]

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 (-_-)