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 this page the Manage Reports Record View is to view, add , or edit , remove the reports within within NorthScope.  Additionally, users can Deploy reports, Download report files and Import report packages   Reports can be added to the 'Reports' left hand menu or the Print Dialog window for a Functional Area within the system


Software Version: YYYY.MM.DD and newer

...

Page Header

Close from.  This is required and comes the Location field on the record view  This field is always editable. Note: The editability rules do not apply to 'Direct Print' type reports. that the user entered on the Record View required and must be <= 50 characters. This field is not editable after save.

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

Database Field: ERPx_RSReport.ReportName

Identifies the status of the report. For standard reports shipped with NorthScope, the status will default to 'Not Deployed' until the user deploys it.  Reports that are manually added by the user, if successful, will save as 'Deployed'.  Reports that are not found on the report server or their location is not in the standard location will display a status of 'Unknown'ReportStatusENSystem Version ERPxRSReportDefinitionIsSystemVersion
Toolbar IconsDescriptionDelete
Insert excerpt
Delete - LVDelete - LV
nopaneltrue
Deploy ReportsOpens the Deploy Reports page which allows users to select one or more reports to deploy/ re-deploy to the report server. 
DownloadOpens a drop-down menu for the user to select which type of file to download.  The options include: "Download RDL", "Download Query", and "Download Report Package".  Choosing Download RDL will download the RDL (Report Definition Language) file, which is a file extension for an XML file used on Microsoft SQL Server reporting services.  If Download Query is selected, a zip file containing the SQL file/s used to create the associated report will be downloaded and if Download Report Package is selected, a .rpt file (named .nsrpt in NorthScope) which is a report file format will be downloaded for the associated report. 
Edit
Insert excerpt
Edit - LVEdit - LV
nopaneltrue
Excel
Insert excerpt
Excel - LVExcel - LV
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - GlobalFavorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - GlobalGrid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - GlobalHelp - Global
nopaneltrue
Import Report PackageOpens the Import Report Package page which allows users to browse to a .nsrpt file and import the corresponding report.  Users may only import one report package at a time. 
New
Insert excerpt
New - GlobalNew - Global
nopaneltrue
Save
Insert excerpt
Save - RV HeaderSave - RV Header
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
CheckboxCheckbox
nopaneltrue
Clicking 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. 

Database Field: ERPx_RSReport.ReportExportTypeEN

Description

ADD DEF/ GLOBAL CONTROL HERE.  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.  

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 required and can be edited from the record view.  It 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 and .  If left blank, this will default to the 'Report Name' value.  This is always editable. 

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

Database Field: ERPx_RSReport.DisplayNameDatabase Field: ERPx_RSReport.DisplayName

File to upload
Form

ADD DEF/ GLOBAL CONTROL HERE. 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.  The lookup contains the available pages the report can be added to appear in the print dialog window based upon the Functional Area selected. 

Database Field: ERPx_RSReportForm.FormSK

Functional Area

Identifies which area in NorthScope the report is located.  This is required and can be edited from the record view and is always editable. 

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

  This is a single select lookup that defaults to the first value available in the list.  This field is required  

Database Fields: ERPx_MFFunctionalArea.FunctionalAreaSK, ERPx_RSReport.FunctionalAreaSK

Launches From

Is History Tracked


Database Field: ERPx_RSReport.IsHistoryTracked

Location

Identifies where the report can be opened

from

.

  

Database Field: ERPx_RSReport.ReportLocationEN

On Report Server


Database Field: 

Report Name

Identifies the name of the associated report

This is

Status

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.  This field must be <= 50 characters and is only editable on New.  

Database Field: ERPx_RSReport.

ReportName

Report Path


Database Field:

 ERPx_

RSReport.

ReportPathOverride

Use in Company

Identifies which Company/Companies within NorthScope has access to the associated report.  This is not required and can be edited from the record view.  If all companies have been selected the value *ALL* will be displayed in this field and if no companies have been selected then this field will be blank. This field is always editable.  Note: The editability rules do not apply to 'Direct Print' type reports.  

Database Field: ERPx_RSReportCompany.DataEntityCompanySK

...