Report Management Tools
The Report Management Tools screen is separated into three sections:
- Primary: Manage netFORUM reports from this form.
- Permissions: Check permissions on database stored procedures that run reports.
- Systems Options: Manage system options.
The Primary section of the Report Management Tools is the default view. Click More and then either Permissions or System Options to change the view.
Click the Expand/Collapse button to expand and collapse the list or click the New Window button to open the list in a new window.
Additional information about working with list views is available in List.
Primary
The Primary section contains child forms that show user login information for reports, report links in from which reports are run, either as form links or from report central, as well as other child forms that show reports with no links, locked reports, and reports presumed to be client reports.
Netforumreportuser Sql Login
Lists the SQL Login used for reports. If you do not see a LoginName, then that user is orphaned and running the report fails. Run exec dbo.sp_change_users_login @action='Auto_Fix',@UserNamePattern='netForumReportUser' to fix.
| Column Name | Description |
|---|---|
| UserName | Lists the user name. |
| RoleName | Lists the user role name. |
| LoginName | List the user login name. |
| DefDBName | TBD. |
| DefSchemaName | TBD. |
| UserID | Lists the user ID. |
| SID | Lists the computer security identifier. |
Reports Run From Form Link
Lists the forms with reports available from a link within the form.
| Column Name | Description |
|---|---|
| Folder (icon) | Click the folder icon to open the folder and list the individual reports. |
| Form Description | Lists the form description. |
| Form Title | Lists the form title. |
| Number | Lists the number of form linked reports. |
Lists the reports available from a link in the form.
| Column Name | Description |
|---|---|
| Pencil (icon) | Click to open the report in Edit Report (child window). |
| Arrow (icon) | Click to open the report in Edit Report (main window). |
| Report Name | Lists the report name. |
| Report Path & File | Lists the report path and file name. |
| Deleted? | Indicates whether or not the report has been deleted. |
| Locked | Indicates whether or not the report is locked. |
| Run (button) | Click to run the report. |
Reports Run From Report Central
Lists the reports available from Report Central .
| Column Name | Description |
|---|---|
| Folder (icon) | Click the folder icon to open the folder and list the individual reports. |
| Content Group | Lists the content group in Report Central. |
| Number | Lists the number of reports in the content group. |
Lists the reports available from a link in the form.
| Column Name | Description |
|---|---|
| Pencil (icon) | Click to open the report in Edit Report (child window). |
| Arrow (icon) | Click to open the report in Edit Report (main window). |
| Report Name | Lists the report name. |
| Report Path & File | Lists the report path and file name. |
| Group Item | Lists the report group item. |
| Deleted? | Indicates whether or not the report has been deleted. |
| Locked | Indicates whether or not the report is locked. |
| Run (button) | Click to run the report. |
Reports With No Links
These reports do not have links to Report Central or Forms. They are either unused or are called from within hyperlinks or program code.
| Column Name | Description |
|---|---|
| Pencil (icon) | Click to open the report in Edit Report (child window). |
| Arrow (icon) | Click to open the report in Edit Report (main window). |
| Report Name | Lists the report name. |
| Report Path & File | Lists the report path and file name. |
| Deleted? | Indicates whether or not the report has been deleted. |
| Locked | Indicates whether or not the report is locked. |
| Run (button) | Click to run the report. |
Locked Reports
These reports are locked.
| Column Name | Description |
|---|---|
| Pencil (icon) | Click to open the report in Edit Report (child window). |
| Arrow (icon) | Click to open the report in Edit Report (main window). |
| Report Name | Lists the report name. |
| Report Path & File | Lists the report path and file name. |
| Deleted? | Indicates whether or not the report has been deleted. |
| Locked | Indicates whether or not the report is locked. |
| Run (button) | Click to run the report. |
Client Reports
These reports are custom client reports located in the client folder.
| Column Name | Description |
|---|---|
| Pencil (icon) | Click to open the report in Edit Report (child window). |
| Arrow (icon) | Click to open the report in Edit Report (main window). |
| Report Name | Lists the report name. |
| Report Path & File | Lists the report path and file name. |
| Deleted? | Indicates whether or not the report has been deleted. |
| Locked | Indicates whether or not the report is locked. |
| Run (button) | Click to run the report. |
Permissions
The Permissions section contains this Report Management Tool.
Presumed Report Stored Procedures Without Permissions
These database stored procedures do not have execute permission. If these stored procedures are used by a report, the report will not run.
| Column Name | Description |
|---|---|
| SP Name | Lists the stored procedure name. |
| Presumed Report | Lists the presumed report. |
| Run (button) | Click to run the report. |
System Options
The System Options section contains these Report Management Tools.
Netforumreportuser Sql Login
Lists the SQL Login used for reports. If you do not see a LoginName, then that user is orphaned and running the report fails. Run exec dbo.sp_change_users_login @action='Auto_Fix',@UserNamePattern='netForumReportUser' to fix.
| Column Name | Description |
|---|---|
| UserName | Lists the user name. |
| RoleName | Lists the user role name. |
| LoginName | List the user login name. |
| DefDBName | TBD. |
| DefSchemaName | TBD. |
| UserID | Lists the user ID. |
| SID | Lists the computer security identifier. |
Report System Options
Lists the report system options.
| Column Name | Description |
|---|---|
| Pencil (icon) | Click to open the report in Edit - System Option (child window). More information about system options is available in the System Options Reference. |
| Option | Lists the system option name. |
| Option Description | Lists the system option description. |
| Value | Lists the system option configurable value. |
| Locked | Indicates whether or not the system option is locked. |