Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
 The purpose of the Manage Reports Record View is to add or edit reports within NorthScope.   Reports can be added to the 'Reports' left hand menu or the Print Dialog window for a Functional Area within the system. 


Software Version: YYYY2021.MM02.DD 19 and newer

Table of Contents
typeflat

...

Toolbar IconsDescription
CloseClicking this toolbar icon will close the current record and return to the Manage Reports List View. 
HelpCan we add a help icon to this? 
FieldsDescription
Allowed Formats

Identifies the available file formats that the associated report can be exported in from the Print Dialog window.  This is a single select lookup that defaults to blank on New.  This field is required else the message 'At least one allowed format must be specified' will be displayed on Save.  This is always editable and affects the format that the user can export the report in from the Print Dialog window for example.  The lookup contains: PDF, Word, Excel, CSV. 

(lightbulb)  The editability rules do not apply to 'Direct Print' type reports. 

Database Field: ERPx_RSReport.ReportExportTypeEN

Description

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
  This is a text box that defaults to blank on New and allows the user to enter information pertaining to the report that is useful to users and the company. This field is not required and must be <= 1000 characters.  This is always editable and will be visible for reports set to be located on the Reports Page.  

(lightbulb)  The editability rules do not apply to 'Direct Print' type reports. 

Database Field: ERPx_RSReport.Description

Display Name

Identifies the name of the report that is shown on the associated Reports List View or Print Dialog window. This is a text box that defaults to blank on New and allows the user to enter a name for the report that will be displayed to the user.  This field is required and must be <= 50 characters.  If left blank, this will default to the 'Report Name' value.  This is always editable. 

(lightbulb)  The editability rules do not apply to 'Direct Print' type reports. 

Database Field: ERPx_RSReport.DisplayName

File to upload

Displays a text box and browse button for the user to upload a report.  When the user clicks Browse the file explorer window will open for the user to select the .rdl (Report Definition Language) file they wish to upload/deploy.  If another file type is selected, the message "You are only allowed to upload rdl files" will be displayed on Save.  This field is always editable. 

(lightbulb)  The editability rules do not apply to 'Direct Print' type reports. 

Form

Identifies which page/s the corresponding report has access to within NorthScope. This is a single select lookup that defaults to blank and is disabled on New until the Location type 'Print Dialog' is selected.  This field is not required, however if a value is not selected the associated report will not be displayed in any print dialog window.  This field is only editable when the Location is set to 'Print Dialog'.  The lookup contains the available pages the report can be added to appear in the print dialog window based upon the Functional Area selected. 

(lightbulb)  The editability rules do not apply to 'Direct Print' type reports. 

Database Field: ERPx_RSReportForm.FormSK

Functional Area

Identifies which area in NorthScope the report is located.  This is a single select lookup that defaults to the first value available in the list.  This field is required and is always editable. 

(lightbulb)  The editability rules do not apply to 'Direct Print' type reports. 

Database Fields: ERPx_MFFunctionalArea.FunctionalAreaSK, ERPx_RSReport.FunctionalAreaSK

Is History Tracked

FIELD TO BE REMOVED. 

Database Field: ERPx_RSReport.IsHistoryTracked

Launch From

Identifies where the report can be opened from.   This is a single select lookup that defaults to blank on New.  This is required else the message 'Report Location is required' will be displayed on Save.  The lookup contains: Print Dialog, Reports Page, Direct Print.  

Note: The editability rules do not apply to 'Direct Print' type reports. 

Database Field: ERPx_RSReport.ReportLocationEN

On Report Server

Identifies whether or not the report exists on the report server.  This field displays 'Yes' when the report exists on the report server and is blank when it does not.  This field is never editable. 

Report Name

Identifies the name of the associated reportThis is a text box that defaults to blank on New and allows the user to enter a name for the report, this value is not visible to the user.  This field is required else the message 'Report Name is required' will be displayed on Save.  Report Names must be unique, if a duplicate name is entered the message 'Report Names must be unique' will be displayed on Save. This field must be <= 50 characters and is only editable on New.  

(lightbulb)  The editability rules do not apply to 'Direct Print' type reports. 

Database Field: ERPx_RSReport.ReportName

Report Path

Identifies the file system location where the report exists.  This is a text box that defaults to blank on New and allows the user to enter the path to the directory of the associated report being uploaded.  This allows users to use reports that are located on another server as opposed to the NorthScope report server.  

Database Field: ERPx_RSReport.ReportPathOverride

Report Type

Identifies how the report is classified with the report type. This is a single select lookup that defaults to blank on New.  This is required else the message "Report Type is required" will be displayed on Save.  The lookup contains the values in the ReportType Enumeration Class.

Database Field: ERPx_RSReport.ReportType

Use in Company

Identifies which Company/Companies within NorthScope has access to the associated report.  This is a single select lookup that defaults to *ALL* on New. This field is not required, however if no company is selected the report will not be available for use within NorthScope.  This is always editable. 

(lightbulb)  The editability rules do not apply to 'Direct Print' type reports. 

Database Field: ERPx_RSReportCompany.DataEntityCompanySK

...