Reporting

Reporting offers you a wide range of reports that present information about all aspects of your data, including projects, firms, contacts, and employees.

In Reporting, you can do the following:

  • Generate reports to preview on the screen or to print. You can print the report immediately, or you can schedule it to run at a later time.
  • Set report options that control how information is displayed on the report, which columns are included, and how the data is sorted and grouped.
  • Select the data that is included on reports.
  • Save sets of report options to use again. The sets of options include all settings on all options tabs. You can also save sets of selection criteria. Both types of named, saved sets are available whenever you print reports. This makes the reporting process easier and quicker.
  • Create and save favorite report formats. A favorite is a set of saved options combined with a set of saved record selection criteria. After you create and save a favorite, you can use it to quickly generate the report with the saved current options and record selection criteria.
  • Access any report or favorite report from your dashboard.
  • Drill down to another report to see supporting detail.
  • Export DPS data to an Adobe Portable Document Format (PDF) file, a Microsoft® Excel spreadsheet file, and other common file formats.

User roles determine whether or not a user can generate each type of report and what data is displayed on the reports they can generate.

Reporting Services

DPS uses SQL Server Reporting Services to generate standard reports, manage reporting processes, and provide tools for building custom reports. SQL Server Reporting Services is a component of Microsoft SQL Server and part of the Microsoft Business Intelligence framework. You automatically receive SQL Server Reporting Services with your SQL Server database.

The reporting features that SQL Server Reporting Services provides vary somewhat based on the version of SQL Server that you are using.

See the Deltek DPS Technical Installation Guide for detailed information about setting up reporting services, required versions of SQL Server Reporting Services, and related topics.

Report Administration

The Report Administration utility allows you to load reports on the report server, view the list of available printers for reports, display servers and reports' current activity, that are currently running on the report server, delete jobs, and view log data.

Reports Grid

You use the Reports grid to select reports, set options, select data, create favorites, preview reports, and print reports.

Report Descriptions

The Help system provides descriptions of the standard reports. The descriptions include column and option definitions. The report descriptions are grouped by category. For example, the descriptions for all reports related to contacts are grouped under Contacts.

Custom Reports

Standard reports that are provided with DPS are designed to meet most of your business needs. In addition, you can create custom reports using Microsoft SQL Server® Reporting Service's SQL Server Data Tool — Business Intelligence Report Designer. This report writing tool is also known as SSDT-BI Report Designer. For more information, about creating custom reports, see the Deltek for Professional Services Custom Reports and Microsoft SQL Server Reporting Services PDF guide. You can download it from the Deltek Customer Care Connect website.

Related Topics:

  • Basics
    If you are new to Reporting, you may find it helpful to review information about report favorites, options in Settings that affect reports, and considerations for generating reports when you use multiple companies.
  • Reporting Procedures
    Reporting offers many ways to create and generate reports. Initially, many of the reports have default settings for the report's options. You can change both the content of the report and its formatting if the default settings do not meet your needs.
  • Reporting Screens
    In addition to the Reporting form, you use the Options dialog box, Preview Window, and various formatting dialog boxes to work with and print reports.
  • Report Descriptions
    Reporting provides an extensive selection of standard reports. Each set of report description topics includes an overview topic, one or more topics that describe the report options, and a topic that describes the contents of the report columns.
Parent Topic: Deltek DPS® Help