Custom Reports Tab of Report Administration

Use the Custom Reports tab to upload customized reports (.RDL files) that are located on a workstation into Vision.

Contents

The upload process copies the reports from a workstation to Microsoft SQL Server Reporting Services and to your Vision reporting server. It makes the uploaded reports accessible from the Reporting menu in the Navigation pane in Vision.

The Custom Reports tab displays only if it has been enabled by your Vision system administrator by selecting the Allow RDL files to be uploaded in Report Administration check box on the General tab of the Weblink utility. Reports (including custom reports) from your Vision application server can be loaded into Vision using the Load Reports tab on the Report Administration form.

Apply Schema Update to Custom Report File Section

Use the fields in this section to upgrade custom reports to the RDL report schema version that is currently supported in Vision. This applies only if the report files are saved on a local machine and they have not been saved in the Vision database. If you need to upgrade custom reports that are saved in your Vision database, use the Upload option on the toolbar of the Load Custom Reports grid on this tab.

For more information about the RDL report schema version that Vision currently supports and more information about upgrading your custom reports, see the Deltek Vision Custom Reports and Microsoft SQL Server Reporting Services guide. You can download the guide from the Deltek Customer Care Connect website.

Field Description
Folder This field displays the folder that you select when you click the Select Folder button in this section. You select the folder on your local machine that contains the RDL files that you want to upgrade to the currently supported RDL schema. You can also manually enter a folder and its path in the Folder field.
  • Select Folder: Click this button to open the Browse for Folder dialog box, and browse to and select the folder on a your local machine that contains the custom report RDL files that you want to upgrade.
  • Apply: Click this button to upgrade the schema of all the custom report RDL files in the selected folder. When the process is complete, review the RDLProccessing.log log file that is saved in the report folder that you entered in the Folder field. The log file contains the status of each processed RDL file and identifies any errors.

Load Custom Reports Grid Toolbar

Field Description
Load Custom Reports

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 File > Print 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.

Download Click this option to download a copy of the selected custom report. The custom report must be available in the database to download it.
Synchronize Click this option to get a copy of a custom report from the database and store it to the report server. The custom report should be available in the database and have the Missing in report server status to synchronize the custom report.
Upload Click this option to open the Select Custom Report File to Upload dialog box and select an RDL report file to upload.
Delete Click this option to delete the selected custom report in the Load Custom Reports grid.
Upgrade This option displays only if you have a saved custom report in the Vision database. Use this option to upgrade custom reports to the RDL report schema version that is currently supported in Vision if the report files are saved in your Vision database. If you need to upgrade custom reports that are saved on a local machine, use the fields in the Apply Schema Update to Custom Report File section on this tab.

For more information about the RDL report schema version that Vision supports and more information about upgrading your custom reports, see the Deltek Vision Custom Reports and Microsoft SQL Server Reporting Services guide. You can download the guide from the Deltek Customer Care Connect website.

When you click Upgrade, Vision does the following: It upgrades the report schema for each custom report, resaves the reports in the Vision database, and uploads the reports to the Vision report server.

During the upgrade, Vision backs up the custom reports that are saved in the Vision application server's Report\Backup folder.

When the upgrade finishes, you can review the RDLProcessing.log log file that is saved in the Vision application server's Report\Backup\<database name> folder. The file contains the status for each processed RDL file and identifies any errors.

Load Custom Reports Grid

This grid displays all the reports you have uploaded using either the Custom Reports tab or the Load Reports tab.

Field Description
Name This field displays the name of the report derived from the .RDL file that you selected on the Select Custom Report File to Upload dialog box.
Filename This field displays the name of the uploaded .RDL file that you selected on the Select Custom Report File to Upload dialog box .
Report Path This column displays the folder path where the custom report is stored on the report server.
Location From this drop-down list, select the Reporting application in which you want the custom report to display. This field is only editable during the initial upload and will no longer be editable after you click Save. Once saved, you will have to delete and upload the custom report again to select a different Reporting application.
Status This column displays the upload status of the custom report that was uploaded. The column can display the following statuses:
  • Synchronized: The custom report was uploaded successfully in the report server and the database.
  • Missing in report server: The custom report was only successfully uploaded in the database and did not get saved in the report server.
  • Missing in database: The custom report was only successfully uploaded in the report server and was not saved in the database.