User Tools

Site Tools


Sidebar

advanced:ssrs_reports:start

SSRS Reports

This section describes the changes that need to be applied to the reports in order to integrate them with EPM Pulse.

SSRS Integration Limitations

There are several limitations that currently apply to all editions of EPM Pulse. Major limitations are:

  • SSRS report added to a dashboard will not be exported on exporting dashboard to PNG or PDF.
  • Report viewer widget does not support export, print and subscription features which are available via regular report viewer.

EPM Pulse for On-Premise

There are no other limitations except the ones described above in On-Premise installations of EPM Pulse. Available SSRS features are limited only by the edition of SSRS installed.

EPM Pulse for Project Online

SSRS reports are not supported in Project Online version of EPM Pulse.

Report Integration

Datasource

In order to utilize EPM Pulse datasource for Project Server data, report should use a shared datasource 1). Name of the datasource does not matter, EPM Pulse will automatically detect all shared datasources and will replace them to use the correct data connection.

Consume Project Filter Selection

If report displays information based on a variable set of projects, then it is possible to consume a project selection from the Project Filter as a set of project UID's. To consume the project selection add the following parameter to the report:

Property Value
Name EntityUids
Prompt EntityUids
Data type Text
Allow multiple values Enabled
Select parameter visibility Hidden

Consume Timeline Dates

If report displays information based on a date range, then it is possible to consume a date selection from the Timeline. To consume start and end dates from the Timeline add the following parameters to the report:

Property Value
Name StartDate
Prompt StartDate
Data type Date/Time
Allow null value Enabled
Select parameter visibility Hidden

Property Value
Name EndDate
Prompt EndDate
Data type Date/Time
Allow null value Enabled
Select parameter visibility Hidden

Sample Report

Download sample report that displays a list of all projects selected in the Project Filter and filtered by Start and Finish dates selected in the Timeline.

See Also

1)
Mandatory for EPM Pulse for Project Online.
advanced/ssrs_reports/start.txt · Last modified: 2018/07/05 03:00 by Kateryna Zatsepa