Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing paramater in reports 6i

766559May 6 2010 — edited Jun 10 2010

Hi,

I have created a report using report builder. and in forms i tried to view the report, its working fine

Now i need to pass paramater to that report, like where userid=1 or something

How can i do that?

Now i've given like this , in the when_button_pressed

repid := find_report_object('report9'); 
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'userid='||:txtbx1);
v_rep := RUN_REPORT_OBJECT(repid);

But it is not working
Do i need to make any changes in the report file(.rpt)?

Thanks

Edited by: Tuts009 on May 5, 2010 9:41 PM

This post has been answered by Ammad Ahmed on May 6 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2010

Added on May 6 2010

#6i, #and, #forms, #moved-from-devops, #oracle, #reports

9 comments

3,142 views