Consultor Eletrônico

Report Builder Engine - pass runtime variable in 19th param

INTRODUCTION:
=============
Passing a runtime variable to the Report Builder Engine through the
19th parameter.


WHY YOU NEED TO KNOW THIS:
===========================
This capability gives the users more flexibility designing a front-
end for their RB reports. THIS METHOD IS NOT RECOMMENDED FOR PASSING
DATA TO THE FILTER BECAUSE IT WILL CAUSE A DECREASE IN PERFORMANCE.
RUNTIME VARIABLES SHOULD BE PASSED TO THE FILTER USING THE
RB-FILTER PARAMETER.
(refer to kbase 15062 Performance hints for the Report Builder Engine
_printrb)

PROCEDURAL APPROACH:
====================
To pass a runtime variable into the 19th parameter, concatenate the
string containing the name of the calculated field defined
in the Report Builder report definition (using the RUNTIME-PARAMETER()
function) with the runtime variable (which must be CHARACTER).


RB-OTHER-PARM = "userparm1 = " + entered_value

where RB-OTHER-PARAM is passed in as the 19th param to RB engine
userparm1 is the calculated field created in the report.
entered_value is the runtime variable defined as CHARACTER

Since the 19th parameter only takes CHARACTER strings, if the runtime
variable is numeric, date or logical it has to be converted inside the
report definition.


REFERENCE TO WRITTEN DOC:
=========================
V7 Report Builder Manual
Chapter 17.2.3 Report Engine - Using Other Parameters

V8 Report Builder Deployment Guide
Section 3.3 User-defined Parameters page 3-21

Progress Software Technical Support Note # 13939