Reports

<< Click to Display Table of Contents >>

Navigation:  Professional >

Reports

Definitions

Report Output Types

ST_REPORT_TYPE Entries

 

This section contains information on running and publishing reports in EQuIS Professional, including configuring, managing, and customizing various report types.

 

For information about the EQuIS Professional standard, custom, and module-specific reports developed by EarthSoft, refer to the Reports section of the EQuIS Library chapter. The EQuIS Library is also accessible from the Table of Contents of the EarthSoft Online Help. Consult individual report articles for specific information regarding the report type and output, provided in the header at the top of the page.

 

Definitions

 

Base Report: This refers to the original report from which a crosstab or user report was created. For example, Analytical Results II can be the base report used in a crosstab report or as the base report for a saved user report.

Class Report: A report that uses a DLL file, as opposed to a stored database procedure/function or a saved SQL query.

Crosstab Report: Like a pivot table, a crosstab report takes output and summarizes it based on different groupings, typically using more than one header row to group the data.

Database Function Report: These are reports stored as procedures or functions within the SQL database itself (rather than as a .dll file in the EQuIS Program folder). These are typically older reports, and may have the v54 prefix, such as the Analytical Results Report (v54.analytical_results).

Published Report: A report that is saved to the database using the Report Publisher. This creates entries in the ST_MODULE, ST_REPORT, and ST_REPORT_PARAMETER tables. If choosing to store the report assembly in the database, the assembly will be present as a Binary Large Object (BLOB) in ST_MODULE.ASSEMBLY, appearing as “System.Byte[]” within the table. This allows use of this report in Enterprise, provided that report dependencies are in the Enterprise bin folder. Users without the Report Library installed are also able to use a published report, provided their permissions allow it. The published report will then be the version used for all users of the database, unless a user has a newer version installed on their system.

System Report (formerly known as “build report”): A report that comes standard with EQuIS Professional, if the EQuIS Library is installed.

User Report (formerly known as “pick report”): Report parameters for a published report can be saved to the database as a user report, appearing in the ST_USER_REPORT and ST_USER_REPORT_PARAMETER tables. With the appropriate permissions and active facility, these reports will appear:

in the 'User report' drop-down for each opened report in EQuIS Professional, and

as individual entries in the Enterprise Report Chooser.

 

Both system and user reports appear, differentiated by specific icons, in the Enterprise Report Chooser.

 

Report Output Types

 

1.Grid Report: Also known as an Igrid (Infragistics – a third party tool used by EQuIS – grid) report, the output for a grid report appears directly in the Professional interface rather than in a separate program such as Excel. The output can then be exported from within Professional. In Enterprise, these reports can be used with the EZView Widget's View button and in the Data Grid and Map widgets. This report type is required within Microsoft Power BI.

2.Non-grid Report: The report outputs directly to a defined file type without being viewable in Professional. Specific report documentation pages will specify the output types available (e.g. Excel spreadsheet, graphic, Keyhole Markup Language [*.kmz]).

 

ST_REPORT_TYPE Entries

 

Possible report related entities that can appear in the ST_REPORT_TYPE table are described below. Not all of them may be present in a specific database, depending on the database modules, saved reports, and age.

 

Searching a Report Type in the Reports tab of the Open Window shows all reports of that type.

 

Description

Report Type

Method of Publication

Active Report

rpx

Active Reports Form

Database Function

func

SQL Server Management Studio (SSMS) – equis.add_report stored procedure

Database Procedure

proc

Database Table

table

Database View

view


EDD Export

edd

Report Publisher Form

DLL Report

class

Report Publisher Form

Published Crosstab Grid Report

xtabgrid

Crosstab Interface

Published Crosstab Report

xtab

Crosstab Interface

Report Definition Language (RDL) Report

rdl

Report Publisher Form

SQL Reports

sql

Report Publisher Form

 

The Open Reports window in Professional will display the report types listed above, except for the Database View, provided that the corresponding ST_REPORT.STATUS_FLAG is ‘A’. If these reports do not appear as expected, they may have been moved to a folder.