Overview

User may integrate their Third party Reports with Ephesoft Reports using Advanced Reports license with advanced Reports switch set ON.

C:\Users\anika2078\Desktop\Custom1.png

Configuration of Third party Report Context

  • Context Loading of Third party reports is configured by adding context path configuration on server.xml located at [EphesoftInstallationDirectory]\JavaAppServer\conf\*

Add following under Host tag:

<Context path=”/Third party_Reports_Context” docBase=”[system_directory_path]\\Third party_Reports_Folder_Name” privileged=”false”/>

  • Or, user may have an external server that loads the context of their Third party reports and ensure the context is preloaded when integrated Third party Reports are accessed.

Either of above must be executed on all servers in a multi-server environment.

Integration of Third party Report

Some insert commands in Ephesoft database would integrate the Third party report files within Ephesoft Reports.

Three tables involved are: reports_folder, report and sub_report:

  • Inserting Third party Report context path, if other than existing report contexts in reports_folder table:
MSSQL MariaDB
insert into reports_folder (creation_date, last_modified, host_uri_path, default_context_path) values (GETDATE(), GETDATE(), ‘<hostname:port_number>’, ‘/ Context_Path_of_folder_containing_custom_reports’); insert into reports_folder (creation_date, last_modified, host_uri_path, default_context_path) values (NOW(), NOW(), ‘<hostname:port_number>’, ‘/Context_Path_of_folder_containing_custom_reports’);

Columns in Data Table

Column Name Description
host_uri_path
  • Null if the Third party report is deployed using Ephesoft’s JavaAppServer Context path loading. The Reports will automatically take hostname as system name and port number as port number used by Ephesoft Application.
  • Otherwise, a composed host_uri_path with host server name and port number.
Default_context_path Common URL path of reports those are part of a Third party report context.For Example: ‘/EphesoftReports/rdPage.aspx?rdReport=’
  • Inserting Third party Report parent folder name, in report table:
MSSQL MariaDB
insert into report (creation_date, last_modified, report_name, default_folder_path, parent_folder_id) values (GETDATE(), GETDATE(), ‘Report_UI_display_name’, ‘Report_folder_name’, (select id from reports_folder where default_context_path = ‘parent_default_context_path’)); insert into report (creation_date, last_modified, report_name, default_folder_path, parent_folder_id) values (NOW(), NOW(),Report_UI_display_name ‘, ‘Report_folder_name’, (select id from reports_folder where default_context_path = “‘parent_default_context_path “));

Columns in Data Table

Column Name Description
Report_name UI display name of Report parent folder name.
default_folder_path Name of a parent folder containing reports. (Usually a Third party report, say SubReport, with folder Report is named as Report.SubReport, hence default_folder_path would be Report in this example.
Parent_folder_id refers to a context path entry in reports_folder table

Multiple number of entries in this table may point to one report context path.

  • Inserting Third party Report’s name, in sub_report table:
MSSQL MariaDB
insert into sub_report (creation_date, last_modified, report_name, default_report_path, parent_folder_id, parent_id) values (GETDATE(), GETDATE(), ‘False Positive’, ‘False_Positive_Report’, (select id from report where default_folder_path = ‘Advanced_Reports’), (select id from sub_report where default_report_path = ‘Document_Correction_Report’)); insert into sub_report (creation_date, last_modified, report_name, default_report_path, parent_folder_id, parent_id) values (NOW(), NOW(), ‘Unnecessary Review’, ‘Unnecessary_Review_Report’, (select id from report where default_folder_path = “Advanced_Reports”), (select id from sub_report sr where default_report_path = “Document_Correction_Report”));

Columns in Data Table

Column Name Description
Report_name UI display name of Report name.
default_ report _path Name of a report in its filename. (Continuing with the example used previously, Usually a Third party report, say SubReport, with folder Report is named as Report.SubReport, hence default_report_path would be SubReport in this example.
Parent_folder_id Refers to parent folder entry in report table. (Report, with respect to above used example).
Parent_id Defines the level of report in hierarchy within a report folder. Set to null if it a direct child of a parent folder in report table else if it is a child of a sub_report in hierarchy, it refers to a sub_report in sub_report table.For example: Document correction Report has parent_id as null because it a direct child of Advanced Reports, but False Positive Report has parent_id as the id of Document correction Report.

Multiple number of entries in this table may point to one report folder.

Multiple number of entries in this table may be children of one sub_report.

 

 

 

 

<Back4.0.0.0 Release Documentation

Was this article helpful to you?

Engineering