Report Distribution

Last Updated: 08/17/2016 Introduced in Verision: 3.5

This tutorial demonstrates how to use Report Distribution functionality. This feature was implemented in Decisions 3.5. Report Distribution allows to create and manage how Reports could be distributed (download, send over email, etc.).

Example:

In this example we are going to overview Report Distribution functionality and extend it by creating a simple Report Distribution type.

We begin with creating a simple Report for this tutorial. In the Designer Folder we click Create Report/Page > Create Report on the Folder Actions Panel.

createReport

Then, we Name our Report and click Create to proceed to the Report Designer.

nameReport

In the Report Designer we add Data Source first. For this example we add Account Data Source from Data Sources > Common category.

addAccontDataSource

Next, we add some fields to populate our Report. We added Account Id and Email Address fields.

This completes our Report design. We can save and close Report Designer.

addColumns

Back in the Designer Folder we locate a thumbnail for our Report and from its Action menu we click Run Report.

runReport

When Report is running we click Print icon located in the upper right corner.

printReport

Download/Send Report window pops up. We can choose Report Distribution type here. By the default we should have two options: Download and Email Distribution Flow. Let’s select second option and click Process.

emailDistribution

Send Email Form pops up. We can fill out this Form and click Send. This Flow will send an Email with Report attached as an Excel file.

fillUpTheForm

We can extend Report Distribution options by creating a specific Flow. Navigate to System > Designers > Report Distribution Folder in the Portal. We can see Email Distribution Flow that we were using as Report Distribution type in previous steps of this tutorial.

reportDistributionFolder

Any Flow that is created in this Folder will be presented as Report Distribution type. Click Create Report Distribution Flow on Folder Actions Panel.

createReportDistrFlow

In the resulting window we Name the Flow and click Create to proceed to the Flow Designer.

nameDistrFlow

Then, in the Flow Designer we add Show Popup step from the Favorite Steps category.

showPopup

In the resulting window we check Show All Properties checkbox in order to be able to map data for this step.

checkShowAllProperties

Then, in the Message Input we are going to Select Value of ReportViewerContextID. This value is presented in every Report Distribution type Flow and can be useful to get and manipulate Report data.

mapDataForMessage

Next, for the Subject Input to the step we are going to use a Constant value for the simplicity of this example.

finishPopUpSetup

Finally, we connect Done outcome from the Show Popup step to the End Step in our Flow. This completes our Flow. We can save it and close Flow Designer.

distrFlowCompleted

If we go back and run our Report again and clicking on the Print icon, Download/Send Report window gives us a new Distribution Option: Pop Up Notification (which is a Report Distribution Flow that we created in this tutorial). We select this option and click Proceed.

newReportDistrib

Our Report Distribution Flow pops up a Notification with Constant Subject and Report Viewer Context ID Value for this Report.

notificationShown

 

 

Additional Resources