Standard Reports List

Overview

The following is a list of the Standard Reports that are available in Govern. The links on this page will be updated periodically. When updates are made the page will appear on the list of posts that appear on the upper right hand side of this page.

Standard Reports

Reports by Modules

Read More...Read Less...

Utility Billing (In Development)

101-ub-rpt-001-UBSummaryCard (UBSumCard.rpt)
101-ub-rpt-002-GenericUBBill (GenUBBill.rpt)
101-ub-rpt-003-WaterLien-PrelimDetail (WatrLnPrDtl.rpt)
101-ub-rpt-004-WaterLien-Summary (WatrLnSum.rpt)
101-ub-rpt-005-WaterLien-NotSubjectToLien (WatrLnNSTLn.rpt)
101-ub-rpt-006-UBReadingHistory (UBRdHist.rpt)
101-ub-rpt-007-UBReadingEditList (UBRdEdList.rpt)
101-ub-rpt-008-ComputationRegisterTentative (CompRegTent.rpt)
101-ub-rpt-009-ComputationRegisterPosted (CompRegPost.rpt)

Accounts Receivable / Cash Collection / Misc. Billing

101-ar-rpt-004-CashBalancingReport
101-ar-rpt-060-ACHlist-backlog
101-cc-rpt-057-ReceiptLog-backlog
101-cc-rpt-058-Receipt
101-cc-rpt-060-CheckValidation
101-gl-rpt-001
101-mb-rpt-001-RecurringList-toreview
101-mb-rpt-003-Invoice

Property Control

101-pc-rpt-001-OwnerLabels

Tax

101-re-rpt-001-TaxComputationRegister
101-re-rpt-002-TaxComputationRegisterSUMMARY
101-re-rpt-004-TaxReceiverDetailsByARCLASS
101-re-rpt-005-TaxReceiverDetailsTotalASOFDate
101-re-rpt-006-TaxReceiverDetailsTotalsASOFDate
101-re-rpt-008-ReDashboard

Workflow Management

Reporting – Crystal Reports

Link to Confluence (Access required)

https://harrisgovern.atlassian.net/wiki/spaces/govrd/pages/492077121/Reporting+-+Crystal+Reports

Read More...Read Less...

Code	Description	Technical Documentation	User Documentation (KB)
ar-005.rpt	A/R Activity
ar-rpt-004.rpt	Cash Balancing Report
cc-rpt-058.rpt	Receipt
cc-rpt-060.rpt	Deposit Receipt
gl-rpt-001.rpt	Auxiliary Ledger
mb-rpt-003.rpt	Invoice
pc-rpt-001.rpt	Owner Listing
pp-rpt-001.rpt	Personal Property Computation Summary
re-rpt-001.rpt	Tax Computation Register
re-rpt-002.rpt	Tax Computation Summary
re-rpt-005.rpt	Tax Receiver’s Totals (As of Date)
re-rpt-008.rpt	Real Property Tax Dashboard
reTaxSum.rpt	Tax Computation Summary
std-rpt-000.rpt	Govern Report Formulas
std-rpt-001.rpt	User Batch Audit Report
std-rpt-002.rpt	Audit Trail Report
std-rpt-003.rpt	GNA Audit Trail Report
std-rpt-038.rpt	Data Dictionary
st-rpt-001.rpt	Self Reported Tax Summary
wm-rpt-000.rpt	Workflow Summary
wm-rpt-001.rpt	Workflow – Step & Activities
wm-rpt-002.rpt	Workflow – Matrix
wm-rpt-003.rpt	Workflow List
wm-rpt-010.rpt	Application Letter
wm-rpt-011.rpt	Workflow Cash Balancing Report
wm-rpt-013.rpt	Permit Poster
wm-rpt-015.rpt	Permit – Renewal Letter
wm-rpt-018.rpt	Workflow – Process Audit
wm-rpt-100.rpt	Workflow Dashboard
wm-rpt-200.rpt	Animal License
wm-rpt-201.rpt	Building Permit

Reporting – SQL Server Reporting Services (SSRS)

Link to Confluence (Access required)

https://harrisgovern.atlassian.net/wiki/spaces/govrd/pages/492077127/Reporting+-+SSRS

Read More...Read Less...

Code	Description	Technical Documentation	User Documentation (KB)	OF Reference Changes	Test Case
ubLien.rdl	Lien Preliminary List	Water Lien (Prelim Dtl)
ubLienEx.rdl	Lien Preliminary List Exempt	Water Lien (Not subject to lien)
ubLienSum.rdl	Lien Preliminary List Summary	Water Lien (Summary)
ubReadHist.rdl	Reading Edit List	Reading Edit List
ubReading.rdl	Reading History	Reading History
ubSumCard.rdl	Summary Card	Summary Card	101-ub-rpt-001-ubsummarycard	Add Standard Reports to Report Parameter Editor: UB – Summary Card	UB – TC – RPT – UB Summary Card

Reporting – Word

Link to Confluence (Access required)

https://harrisgovern.atlassian.net/wiki/spaces/govrd/pages/491978764/Reporting+-+Word

Read More...Read Less...

Code	Description	Technical Documentation	User Documentation (KB)	OF Reference Changes	Test Case
st-rpt-100.docx	Sales Tax Period Correction
st-rpt-101.docx	Sales Letter

100-ReportingLists

(0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.

GNA – Report Criteria Editor

Report Criteria Editor

Overview

User designed Crystal Reports™ are generated from data obtained from the data source. In some instances user input requested by a prompt is required to filter the data, e.g. entering a date range, specifying a fiscal year, etc. In other instances the data must first be extracted and “pre-processed”. For these types of reports it is necessary to configure the preprocessing. This configuration is in the form of prompts for the user to enter required criteria.

NOTE: Attempting to run reports without configuring required prompts will result in an error.

NOTE: Users of Crystal Reports will need to install the Crystal Reports 2013 runtime on the server hosting the application, and on each client computer. Refer to the Crystal Report Runtime section of the Govern Deploy EZ guide.for details.

Display the Report Criteria Editor

To display the Report Criteria Editor…

In the GNA ribbon, select the System Parameters tab.
Click the Report Parameters Editor icon.
Select a report from the List of Reports column on the left hand side.
In the Report Editor, click Report Criteria.

In the Report Criteria Editor, you are able to configure any required user prompts. See Adding one or more Criteria to a Report for details about adding prompts.

Report Criteria Editor Parameters

Report Criteria: The Report Criteria column displays the list of criteria that are associated with the report. When a criteria is selected, its parameters are displayed in the Report Criteria Editor.

Report Criteria Properties group

Prompt: Enter a name that will appear in the title bar of the user prompt. Table Selection: Select the table that data is being selected from using the drop-down menu.
Field Selection: In the drop-down menu, select the field within the table that is being selected.
User Validation Table: If the criteria has to be validated with a user validation table, select the table from the drop-down menu.
System Validation Table: If the selected criteria is to be validated with a system validation table, select one from the drop-down menu.
Ask for Range: Select Ask for Range to display a range prompt; e.g. entering a date range.

Adding Criteria to a Report

When linking reports to a profile, it may be necessary to customize the report to make it more interactive. This can include requesting that the user enter a date range to define the scope of the report. For example, we can include a report for an Audit Trail Inquiry, but we will need to specify the criterion that we want to user to enter.

To specify the criteria for a report…

In GNA, click the System Parameters tab. Click the icon for the Report Parameters Editor.
In the Report Editor, click to select a report from the List of Reports:
By default the report has a criteria called Tax Map Number. For our report we would like to be able to search for a Last Name as well as a First Name.
Click Report Criteria to display the Report Criteria Editor.
In the Report Criteria Editor, click New to begin adding your criteria. Under the Prompt parameter, enter First Name.
For Table Selection, select na_names.
Under Field Selection, we are looking for the FIRST_NAME; we will not be using any user or system validation tables.
Do not select the Ask for Range option because it is required for these parameters.
Click Add to add the criteria to the Report Criteria list.
Repeat the above steps to add a criteria called Last Name.

Change criteria appearance order

Should you want to change the order that the criteria are presented to the user on the form in Govern…

Select the criteria under the Report Criteria list.
Click Up or Down to move them.
When complete, click Save.
Click the Close button to return to the Report Editor.
In Report Editor, click Save and exit from the form.

In Govern, you can preview your updated profiles. Reports are viewed under the Reports Explorer. The two (2) added criteria appear on the form. Users can now perform a search for specific first names and/or last names in addition to the tax map number.

Report Editor

Overview

The Report Parameters Editor form is used to configure reports on an individual basis. These reports display query results found in the fields of tables within the data source.
Reports are given access through the default connection key. If required, they may also be configured using an alternate connection key. As long as the alternate connection key has been defined in the Connection Key Management form, it will be available in the Alternate Connection Key list. See Alternate Connection Key Properties group for details about alternate connection keys. In Release 6.0 of GNA, there is enhanced support for SQL Server Reporting Services (SSRS)™. SSRS reports and Crystal Reports™ are configured in the OpenForms General Settings form, see OpenForms™ General Settings for details.

Intelligent Scanning in Reports Editor

There is an underlying intelligence in the functioning of the Reports editor. Both SQL Server Reporting Service (SSRS) and Crystal Reports reports are read, and the data sources are scanned.
Connection options to the database are by default specified as the current connection. If required, secondary sources can be selected from a list of alternate Connection Keys. During the initial scanning phase, if a report is determined to be invalid, i.e. incompatible, a warning is displayed in the form of a window with a list of the offending reports.

NOTE: When there is no backwards compatibility with a report, the default connection setting will be used.

Details of the Report Scanning Process
When the Report Editor is launched, each report that is selected from the List of Reports list is scanned. The report connection key is tested. When the system encounters either a Crystal Report or an SSRS report that is not associated with a Govern connection key, the system will ask to associate the report with…:

The current Connection Key (Default) OR
The user can see the path to the data source, and may select a connection key from the list of available Alternate Connection Keys.

During the “Database Verification” process…

After performing an update / general maintenance, or defining database connections, running the Database Verification process is recommended as it will update the database for access by Govern applications.When this process is run in GNA, during the Misc. Corrections phase a script performs the following:

Conversion of Alternate Connection Key information (i.e. server, database names, etc.) into the Connection Key in the new table.

The following four (4) fields will be set to NULL:

[DTSRC_SERVER]
[DTSRC_DBNAME]
[DTSRC_UID]
[DTSRC_PASSW]

Note: In the SY_REGISTRY screen, four key names were removed,

[DTSRC_SERVER]
[DTSRC_DBNAME]
[DTSRC_UID]

Record Set Key: This option provides the ability to run the report by dataset, e.g. current P_ID, current dataset, or database. In the drop down menu list, select the primary key that will be used by this report, otherwise the user will not be prompted to select a dataset for the report.

NOTE: A Record Set Key should be specified.

The report dataset will be filtered with a list of values for the selected key.
Example: SELECT * FROM pc_parcel WHERE p_id = ‘123’ OR p_id = ‘456’ etc.

Report Criteria: Click Report Criteria (A) to display the editor. The Report Criteria Editor is used to configure prompts for reports that require user input. See Report Criteria Editor on page 85 for details on configuring prompts.

The report dataset will be filtered with a unique value for the selected keys.

For Example…
SELECT * FROM pc_parcel WHERE p_id = ‘123’

Criteria Key group

Add Criteria Key: Click Add Criteria Key to display the criteria key list; select one or more criteria to be added, click OK or Cancel.
Remove Criteria Key: Select a criteria key from the Criteria Key list and click Remove Criteria Key to remove it from the list.

Alternate Connection Key Properties group

Although database connection parameters are set in the Govern DeployEZ™, they can be overridden on a report by report basis. If required, each report can be configured with an alternate connection key.

NOTE: All settings made in this section override the current, default, connection key. Users should ensure that the alternate connection
key required has been entered in the Connection Key Management form. See The Connection Key Management form.

Data Source: This is the path to the server that the report will be accessing.
Alternate Connection Key: Select an alternate Connection Key from the list.

Report Group

This parameter contains the Report Grouping for the Report Explorer in Govern.
Upper/Lower Level: Select configure these parameters to indicate the location of the report in the Treeview pane in Govern.
For Example…
When the following report, Mass App.- Inventory Report is configured to appear in the following Report Group; Upper Level: List & Reports, and Lower Level: CAMA. In Govern, the report will appear in the List & Report upper folder (A) and CAMA lower folder (B):

Utility Billing (UB) Report – Summary Card

Overview

The Utility Billing Summary Card report has been designed to show all services; e.g. Last Readings, Consumption, and Billing History, for an UB account in a selected year. There are no parameters in this report. It’s filtered by Govern ids: Year, UB account and Tax Map.

Report Details

Report Code

The report code for the UB Summary Card report is: ubSumCard.rpt

Sample Layout

Below is a sample layout of the report.

101-ub-rpt-001-ubsummarycard

(0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.

Reporting in OpenForms

Version 6.0 and Version 6.1 (In Development)

Overview

The following page reviews General OpenForms reporting features and options specifications.
For additional information, see Standard Feature Reports in Govern (std-fea-013) and Report Editor and Report Criteria setup in Govern Administrator.

Specifications

The following standard features are available for reporting

Standard and Custom Reports Definitions
SAP Crystal Reports and Crystal Reports server are supported
- - Use of GovernActions in Crystal ReportsTM
Microsoft SQL Server Reporting Services are supported
Reports are setup by Profiles
Security can be setup by Profile User and Role
Run-Time parameters (required and not required) and selection criteria can be setup by report definition
User persistent run-time parameters by user (parameters and criteria entered are saved by user)
User defined output report formats
Reports can be executed automatically upon a batch definition execution (after batch process completion)
Reports can be scheduled using Govern Scheduler
Reports output format can be configured

Read More...Read Less...

System Registry Parameters

Default paths and server information are stored in the system registry.

To access, in the GNA ribbon…

Select Parameters (tab) > System Parameters (group) > General Settings Editors.
In the OpenForms General Settings form, select Report from the Registry Filter combo-box.
Locate the Section Name column.

Configurable paths related to reports are presented in this section of the registry.

NOTE: Errors will be displayed in the Report Editor if paths are not correctly defined.

Crystal Report
- Custom and Standard report paths
Log File
- Standard Log Path – N.B. specified at the report level
Report Parameters
SSRS configuration parameters, service and connection information

Report Definition Editor

There is an underlying intelligence in the functioning of the Reports editor.
When setting up a report, both SQL Server Reporting Service (SSRS) and Crystal Reports reports are read, and the data sources are scanned.
On run-time, connection key(s), parameters and predefined criteria are used to execute the report.
Multiple report definitions can be configured for the same report. Currently there are two (2) editors:

Crystal Report
DocX Reports

Crystal Report Definition Editor

The report definition contains:

Report Name
- Physical report name selected from the standard or the custom report path
Audit Trail
Report Group – now linked to profiles
- Upper Level
- Lower Level
Recordset Key – that is to be used.
- List of Govern IDs
Report Criteria
Criteria Key
- User Selection Report Criteria Prompts that can be configured using any of the fields of tables used in the report
Alternate Connections Key
- The deployment connection key is used when executing a report. In some cases, a secondary connection key can be provided
For detail information, see Report Editor and Report Criteria

Report Parameters

The following are standard report parameters

Parameter Name	Value returned
Govern ID code	Govern IDs (p_id, na_id, wm_id, etc.)
dept	Ids.Dept
dept_label	Vt_user WHERE tableName=’depart’ AND code=Ids.Dept
language	Cuurent set language
year	Ids.Year
rpt_county	Sy_registry WHERE sectionName=‘general’ AND keyName-‘county’
rpt_date	‘ShortDate LongDate’ (as string)
rpt_default_date	‘ShortDate’
rpt_login	Ids.User
rpt_logo	Path : ‘{RegistryVaue}ReportCompagnyLogo.bmp’ Registry Value is found in the User/System Regostry using those rules: Try to get value from usr_registry WHERE sectionName=’govern’ AND keyName=’bitmap’ If no value found, fall back on sy_registry WHERE sectionName=’path’ AND keyName=’bitmap’
rpt_name	Report Path
rpt_range	Return, as string, all the filter dynamically applied on the Report
rpt_state	Sy_registry WHERE sectionName=’general´AND keyName=’state’
rpt_title	Report description (as set in GNA)
rpt_ub_max_variation	Sy_Registry WHERE sectionName=ub parameters’ AND keyName=’Max Variation’
rpt_uid	Ids.User
rpt_username	OrganizationName set in GovernNetConfig.xml
uniform	Sy_registry WHERE sectionName-‘work_text’ AND key_name=’Assessment Equalisation Rate’

Formulas for Crystal Reports

This section lists the recommended, general, read-only and conditional formulas to include when creating reports through Crystal Reports.

Recommended Formulas

Include the following formulas when you create Crystal Reports:

Formula	Definition
@rpt_date (totext (currentdate))	Date & Time
@rpt_name	Report Name
@rpt_Username	Town or Company Name

General Formulas

Govern populates the following Crystal Reports formulas automatically, if they are included in your reports:

Formula	Definition
@dept	Department (code)
@dept_label	Department label
@language	Language
@rpt_county	County
@rpt_default_date	Default Date
@rpt_login	User name
@rpt_range	Range Text
@rpt_state	State
@rpt_title	Report Title
@rpt_uid	User identification code (UserID)
@uniform	Assessment Equalization Rate
@year	Fiscal year in use by current user in Govern

Read-Only Formulas

The following Crystal Reports formulas are read-only; i.e., they must contain a non-blank value in the report. These formulas trigger specific actions or populate specific formulas:

Formula	Action
@acbill	Refreshes the AC_POST_MASTER table with the current Aircraft ID or the current Name ID (in duplicate bill printing).
@all_ar_needed_ac	Populates the value of several formulas for the current NA_ID and for the all Tax sub-systems. See the Conditional Formulas* section on this page*.
@all_int (under revision)	Updates the following fields in the AR_ SUMMARY table for all installments with positive balance, for all Taxation and Assessment sub-systems and for the current NA_ID. (All updated installment records within a sub-system will contain the same information). LATE_CHARGES (Accrued Penalty or Interest) CHARGE_DATE (Current date as defined in Govern) BALANCE_AS_OF_DATE (Total balance due, exclusive of late charges)
@btbill	Refreshes the BT_POST_MASTER table with the current Boat ID or the current Name ID (in duplicate bill printing).
@drilldown	Enables Crystal Reports Drill Down feature
@govern_tx_interest *This formula is used when calling a Web Crystal Report	Updates the LATE_CHARGES column in the AR_SUMMARY table. Use when calling a Web Crystal Report in the Real Property Tax Subsystem.
@govern_ub_interest *This formula is used when calling a Web Crystal Report	Updates the LATE_CHARGES column in the AR_SUMMARY table. Use when calling a Web Crystal Report in the Utility Billing Subsystem.
@mv_ar_needed_ac	Populates the value of several formulas for the current NA_ID and for the Motor Vehicle Excise Tax sub-system. See the Conditional Formulas* section on this page*.
@mvbill	Refreshes the MV_POST_MASTER table with current Motor Vehicle ID or the current Name ID (in duplicate bill printing).
@mv_int	Updates the following fields in the AR_ SUMMARY table with motor vehicle excise tax information, for all installments having a positive balance for the current MV_ID. (All updated installment records will contain the same information). LATE_CHARGES (Accrued Penalty or Interest) CHARGE_DATE (Current date as defined in Govern) BALANCE_AS_OF_DATE (Total Balance Due, excluding late charges.)
@pp_ar_needed	Populates the value of several formulas for the current PP_ID and for the Personal Property Tax sub-system. See the Conditional Formulas* section on this page*.
@pp_ar_needed_ac	Populates the value of several formulas for the current NA_ID and for the Personal Property Tax sub-system. See the Conditional Formulas* section on this page*.
@ppbill	Refreshes the PP_POST_MASTER table with the current Personal Property ID or the current Name ID (in duplicate bill printing).
@pp_int	Updates the following fields in the AR_ SUMMARY table, for the current PP_ID, with Personal Property Tax information, for all installments having a positive balance. (All updated installment records will contain the same information). LATE_CHARGES (Accrued Penalty or Interest) CHARGE_DATE (Current date as defined in Govern) BALANCE_AS_OF_DATE (Total Balance Due, excluding late charges)
@re_ar_needed	Populates the value of several formulas for the current P_ID and for the Real Estate Tax sub-system. See the Conditional Formulas* section on this page*.
@re_ar_needed_ac	Populates the value of several formulas for the current NA_ID and for the Real Estate Tax sub-system. See the Conditional Formulas* section on this page*.
@re_int	Updates the following columns in the AR_SUMMARY table, for the current P_ID, with Real Estate Tax information, for all installments having a positive balance. (All updated installment records will contain the same information). LATE_CHARGES (Accrued Penalty or Interest) CHARGE_DATE (Current date as defined in Govern) BALANCE_AS_OF_DATE (Total Balance Due, excluding late charges)
@td_ar_needed	Populates the value of several formulas for the current P_ID and for the Tax Deferral sub-system. See the Conditional Formulas* section on this page*.
@td_int	Updates the following fields in the AR_SUMMARY table for all installments having a positive balance, with Tax Deferral information for the current P_ID. (All updated installment records will contain the same information). LATE_CHARGES (Accrued Penalty or Interest) CHARGE_DATE (Current date as defined in Govern) BALANCE_AS_OF_DATE (Total Balance Due, excluding late charges)
@tt_ar_needed	Populates the value of several formulas for the current P_ID and for the Real Property Tax Title sub-system. See the Conditional Formulas* section on this page*.
@tt_int	Updates the following fields in the AR_SUMMARY table, for the current P_ID, with Tax Title/Lien information, for all installments having a positive balance. (All updated installment records will contain the same information). LATE_CHARGES (Accrued Penalty or Interest) CHARGE_DATE (Current date as defined in Govern) BALANCE_AS_OF_DATE (Total Balance Due, excluding late charges)
@txbill	Refreshes the TX_POST_MASTER table with the current Property ID or the current Name ID (in duplicate bill printing).

Conditional Formulas

The Crystal Reports formulas listed in this table are populated by Govern conditionally, on the presence of the following read-only formulas:

@all_ar_needed_ac
@mv_ar_needed_ac
@pp_ar_needed
@pp_ar_needed_ac
@re_ar_needed
@re_ar_needed_ac
@td_ar_needed
@tt_ar_needed

Formula	Action
@ar_interest_1 @ar_interest_2 @ar_interest_3 @ar_interest_4	Calculates the interest and penalties committed for the current fiscal year and the specified installment.
@current_due	Calculates the total balance due for the current fiscal year, including late charges.
@daily_interest	Calculates the daily interest and penalties.
@prior_ar_fee_1 @prior_ar_fee_2 @prior_ar_fee_3 @prior_ar_fee_4	Calculates the demands, charges and fees committed for prior fiscal years and the specified installment.
@prior_ar_interest_1 @prior_ar_interest_2 @prior_ar_interest_3 @prior_ar_interest_4	Calculates the interest and penalties committed for the prior fiscal years and for the specified installment.
@prior_due	Calculates the total balance due for the prior fiscal years, including late charges.

Tables/Fields and Naming Standards

Report File Name

Physical report name available in the standard or custom report path
Report File Name Maximum Length is 15
Recorded in VT_SYSTEM where table_name = REPORTS

Report Options

Standard report parameters that can be used in the report (ex: Department, City/Town Name, Report Title, etc.)
Recorded in VT_SYSTEM where table_name = RPT_OPT

Report Record Set Keys

Standard Govern IDs located in table VT_SYSTEM where table_name = BRULE

Report Definition

Report definitions are stored in table USR_REPORT_DEF
Table contains:
- File Name (available in Standard or Custom report paths)
- Audit Trail – deprecated
- Record Key
- LK_Brule

Batch Processing and Reports

Parameters defined for a batch process can be used by reports.

Batch Process On Completion Report

It is possible to setup a report to be executed upon a batch process definition completion.

Batch Process to Schedule Reports

It is possible to setup a batch process definition to schedule reports.

Report Formats

You can specify the output format of a report that will be generated by a batch process. Verify with IT for the list of file formats allowed for the organization.

Batch Process Parameters

The parameters defined for the batch process can be accessed by the report.

Troubleshooting

A new installation pack for Crystal ReportTM is required to be installed on each client when upgrading to Release 1706.

What’s New

NEW! Workaround to resolve printing issues with Landscape orientation Crystal Reports
Word Reporting

Reporting Govern Actions

Version 6.0 and Version 6.1

Overview

A GovernAction is a link between a method (InsertData) and a report. GovernActions take the form of a report object with a name that has a ‘GovernAction’ prefix, and value format. The process is similar to an Insert or Update action in the database. GovernActions are executed just prior to Displaying, Exporting, or Printing a report. Users should note that there is no Log, or indication of the running of the GovernAction. If the Govern Action triggers an exception, execution of the report stops, and the error is displayed but it is not handled. The GovernAction is designed to be triggered from any Govern report, but currently the action is only configured through Crystal Reports.
Govern Actions are an efficient way to…

Perform an audit on parcels that have been accessed using Crystal Report.
Provides a secure, and controlled method of inserting data in tables.

Have a report display information on multiple accounts, the report can then generate history information in the table and show new data that has been inserted; this new data is inserted in the (Table: ST_EVENT_HIST)

Read More...Read Less...

Documentation

User

Click below to display or download the user documentation
100-reporting-GovernActions.pdf

Technical

Click below to display or download the technical documentation.
100-reporting-GovernActions-TECH.pdf

What’s New!

Changes Due to Refactoring

NEW! As a result of recent refactoring, the following two (2) changes have been made to the Govern Actions.

Placement of Govern Actions in Crystal Reports

Govern Actions no longer need to be placed exclusively in the Details section in a Crystal Report; Actions may now be placed in any of the main sections available to Crystal, i.e. Report Header, Page Header, Details, Report Footer, and Page Footer.

Grouping Allowed

A Crystal Report report can now have grouping and Govern Actions at the same time. For example there could grouping under an ST_ID. The methodology employed involves parsing the exported XML file and identifying required keywords.

NOTE: There is a limitation to the size of the XML file that is parsed; file size should not exceed 2 GB.

100-reporting-GovernActions

(0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.

Std. Report – Business Entity Audit

Standard Report – Business Entity Audit

Scheduled Release GA 1609

Business Entity Audit Trail Report

Purpose

Standard Report used for inquiries in the Business Entity Audits. When the Audit flag is set on a Business Entity, all changes to this entity is recorded.
Contains the prior and the new information.

Process Name

Report Process Name available in VT SYSTEM Table where Table_name = REPORTS

std-rpt-002

Parameters include

From Date
To Date
User
Form
Table
Column

Sample Copy

Click on this document to download a copy of the report.
101-std-rpt-002_BEDauditReport.pdf

101-std-rpt-002-BusinessEntityAudit

(0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.

Standard Reports List

Overview

Standard Reports

Reports by Modules

Utility Billing (In Development)

Accounts Receivable / Cash Collection / Misc. Billing

Property Control

Tax

Workflow Management

Reporting – Crystal Reports

Reporting – SQL Server Reporting Services (SSRS)

Reporting – Word

Report Criteria Editor

Overview

Display the Report Criteria Editor

Report Criteria Editor Parameters

Report Criteria Properties group

Adding Criteria to a Report

Change criteria appearance order

See Also

Report Editor

Overview

Intelligent Scanning in Reports Editor

During the “Database Verification” process…

Criteria Key group

Alternate Connection Key Properties group

Report Group

See Also

Utility Billing (UB) Report – Summary Card

Overview

Report Details

Report Code

Sample Layout

Reporting in OpenForms

Overview

Specifications

System Registry Parameters

Report Definition Editor

Crystal Report Definition Editor

Report Parameters

Formulas for Crystal Reports

Recommended Formulas

General Formulas

Read-Only Formulas

Conditional Formulas

Tables/Fields and Naming Standards

Report File Name

Report Options

Report Record Set Keys

Report Definition

Batch Processing and Reports

Batch Process On Completion Report

Batch Process to Schedule Reports

Report Formats

Batch Process Parameters

Troubleshooting

What’s New

Related Topics

Reporting Govern Actions

Overview

Documentation

User

Technical

Related Topics

What’s New!

Changes Due to Refactoring

Placement of Govern Actions in Crystal Reports

Grouping Allowed

Standard Report – Business Entity Audit

Business Entity Audit Trail Report

Purpose

Process Name

Parameters include

Sample Copy