Invantive Estate

The report is built in Jasper Reports. As a report needs to log on to the middle tier, the report gets via the parameter REPORT_CONNECTION a prepared database connection for the user. This database connection has to be passed on to subreports.

The web page will pass on all GET and POST parameters to the report. The value of GET and POST parameters can be used in the report if a report parameter exists with the same name.

In addition the following parameters will always be delivered:

•P_SYSDATE_C: the date and time of the first report being executed, formatted for use in the report as a String. For use in combination with subfunctions to always use the same time.

•P_PAGENUMBER_OFFSET: contains the number of pages filled prior to this report if a function consists of several subreports with the help of Subfunctions. Is 0 in all other cases. Can be used to have a correct page numbering when using several subfunctions. P_PAGENUMBER_OFFSET is passed on as an integer.

•P_CONNECTION_ESTATE: an already open connection with Invantive Estate, based on the class java.sql.Connection.

•P_CONNECTION_REPORT: an already open connection as specified for the report, based on the class java.sql.Connection. Has the same connection as REPORT_CONNECTION.

•P_URL: the URL used to open the report.

•RPT_CODE: the code of the report that is running, not taking into account if code which was passed on via FTE_ID or possibly via MIM_ID or via FTE_CODE in the URL.

•P_CIG_OMSCHRIJVING_LANG: long description of the filter.

•P_CIG_OMSCHRIJVING: description of the filter.

•P_MAT_SERVER_PREFIX_URL: prefix for web pages of the application.

•P_MAT_REQUEST_URL_HOOFDMENU: the URL from the main menu of the web frontend.

•P_MAT_LOGO_URL: URL to the logo to print each page (LOGO_BKG_URL uit bubs_mijn_rechten_r).

•P_MAT_LOGO_URL_ULT: URL to the most specified logo to print each page. The most-specified logo is: when there is 1 logo that applies for all projects in the filter, choose that. Otherwise, if there is 1 logo that applies for al project entities, choose that. Otherwise, the system-wide logo, which is also to be found in P_MAT_LOG_URL (LOGO_BKG_URL uit bubs_mijn_rechten_r).

•P_MAT_GBR_AANMELD_CODE: registration code of the current user.

•P_ISG_ONDERTITEL_LOGO_RAPPORTEN: subtitle for the logo.