| calling a report from forms [message #79921] |
Thu, 25 July 2002 15:33  |
Tyler
Messages: 123
Registered: January 2002
|
Senior Member |
|
|
hello all, I have been a forms developer for a while and I just now have to start using Reports, I've never used it before and have figured most out... I think...
Anyway, I am passing a code to a report to get the necessary info, with RUN_PRODUCT. The thing is, a "parameter form" comes up as a mediary before the report, I don't want the form to come up, just strictly call the report and display it, how do I get rid of that form?
Thanks,
~ T ~
|
|
|
|
| Re: calling a report from forms [message #79928 is a reply to message #79921] |
Fri, 26 July 2002 04:33  |
kat
Messages: 15
Registered: February 2000
|
Junior Member |
|
|
hi!
-set the parameter programatically,
SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_OTHER,PARAMS);
-start report generation,
report_handle:= RUN_REPORT_OBJECT(report_id);
greetz kat
|
|
|
|
| Re: calling a report from forms - correct way [message #80438 is a reply to message #79928] |
Fri, 20 September 2002 13:26 |
Cal
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
This may be a little late. Here is the correct way to do it using run_report_object (code snippet from metalink):
repid := find_report_object('rep1');
set_report_object_property(repid, report_other, 'p1=15');
set_report_object_property(repid, report_other, 'p2=19');
set_report_object_property(repid, report_other, 'paramform=no');
v_rep := RUN_REPORT_OBJECT(repid);
The key is paramform=no, the default is yes.
This may be too late for you (as it's three months past your original post) but if anyone else comes across this, this is the way. I had a hard time finding any documentation on the report_other built in for set_report_object_property.
|
|
|
|
| Re: calling a report from forms - correct way [message #85326 is a reply to message #80438] |
Wed, 16 June 2004 02:18 |
hudo
Messages: 165
Registered: May 2004
|
Senior Member |
|
|
This answer is also "a little late", nevertheless.
Tyler runs his reports with RUN_PRODUCT,
so the following syntax has to be used to get rid of the parameter form:
para_id_rep PARAMLIST;
--get rid of parameter form
ADD_PARAMETER(para_id_rep,'PARAMFORM',TEXT_PARAMETER,'NO');
--use parameter form
--ADD_PARAMETER(para_id_rep,'PARAMFORM',TEXT_PARAMETER,'YES');
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
