Hi, I'm new to Oracle Developer 2000.
I'm working on Forms6
I have a form build based on emp table, I also have Report built based on emp table, report does not take any parameters, I have a button on form, I want report to execute when I press the button.
What is the code to call a report from the form.
Thanks in advance.
You can use the
RUN_PRODUCT built in procedure.
Can you give me an example Report name is TESTREPORT
Search forums, similar question has been asked before and was answered.
RUN_PRODUCT(REPORTS, 'REPORTNAME.REP', SYNCHRONOUS, RUNTIME, FILESYSTEM, NULL, NULL);
If you are running on NT, you must put the report in a directory listed in the REPORTS60_PATH registry entry:
its fine, but in forms 6i the syntax is like this
RUN_PRODUCT(REPORTS, 'REPORTNAME.REP', SYNCHRONOUS, RUNTIME, FILESYSTEM, to_Char(NULL), NULL);
Click Here to Expand Forum to Full Width