Use the Database Cleanup tab to delete orphaned reports, cached invoice templates, and old log files.
Contents
Orphaned Report Files
| Field | Description |
|---|
| Report RDL Files That Have Been Orphaned for This Number of Days
|
Enter the minimum age in days for orphaned report files that can be deleted. For example, to delete report files that are 10 or more days old, enter
10.
|
| Total Orphaned Reports (Including Subreports)
|
This field displays the total number of orphaned reports and subreports that will be deleted, based on the number of days that you entered.
|
| Delete Reports
|
Click this option to delete orphaned report files that are older than or equal to the specified number of days. Vision prompts you to confirm the deletion.
|
| Schedule Delete
|
Click this option to schedule the deletion process to run at a later time.
|
Cached Invoice Template Files
| Field | Description |
|---|
| Total Cached Invoice Templates
|
This field displays the total number of cached invoice templates that will be deleted, based on the number of days that you entered.
|
| Delete Cached Invoice Templates
|
Click this option to delete cached invoice template files that are older than or equal to the specified number of days. Vision prompts you to confirm the deletion.
|
| Schedule Delete
|
Click this option to schedule the deletion process to run at a later time.
|
Report Log Rows
| Field | Description |
|---|
| Report Log Rows That Are Older Than This Number of Days
|
Enter the minimum age in days for log file rows that can be deleted. For example, to delete rows that are 10 or more days old, enter
10.
|
| Total Report Log Entries
|
This field displays the total number of log file rows that will be deleted, based on the number of days you entered.
|
| Delete Log Rows
|
Click this option to delete report log rows that are older than or equal to the specified number of days.
|
| Schedule Delete
|
Click this option to schedule the deletion process to run at a later time.
|
Report Archives
| Field | Description |
|---|
| Report Archives That Are Older Than This Number of Days
|
Enter the minimum age in days for archived report files that you want to display in the grid. For example, to display report files that are 10 or more days old, enter
10.
After you enter the number of days, click
Refresh on the grid toolbar to display the archived reports that are that old or older.
If you leave this field blank and click
Refresh, the grid displays all archived reports.
|
| Report Archives Grid Dropdown
|
Click the drop-down arrow on a grid header to complete any of the following actions:
- To print grid data, click
Print. On the Print Preview form, click
to send the grid data to your default printer.
- To export grid data to an Excel spreadsheet, click
Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
- To turn on grouping for a grid, click
Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Not all options are available on all grids.
|
| Refresh
|
After you enter a number of days old in
Report Archives That Are Older Than This Number of Days, click
Refresh on the grid toolbar to display the reports that are that old or older.
If you leave
Report Archives That Are Older Than This Number of Days blank and click
Refresh, the grid displays all archived reports.
|
| Delete
|
To delete a report, click the report and then click this option on the grid toolbar.
|
| Username
|
This column displays the
Vision username of the person who created the archived report.
|
| Folder
|
This column displays the area of Reporting from which you generate the report. For example, if you go to
to generate the report, this field displays
Contact.
|
| Report Name
|
This column displays the name of the archived report.
|
| Created Date
|
This column displays the date that the archived report was created.
|
| Expiration Date
|
This column displays the date and time that
Vision will automatically remove the archived report.
The expiration date and time is based on the number of archive hours that was specified when the report was archived or scheduled to be archived.
|
