Passing Inputs on a Flow Sourced Report
  • Updated on 05 Mar 2019
  • 2 minutes to read
  • Print
  • Dark
    Light

Passing Inputs on a Flow Sourced Report

  • Print
  • Dark
    Light

This example demonstrates how to pass inputs on a Flow Sourced Report using two different reports and then displaying both reports on a single Page .  The Page will give a view of the Feilds that each account is associated with. This example uses accounts and then displays a list of the groups associated with each account when that account is selected.

Example

Steps

  • GetGroupsForAccount: Integrations>Internal Services>Group Services> GetGroupsForAccount

The image below displays a flow built for the purpose of getting accounts from a database using a step called GetGroupForAccount and then outputs groups for each account. 
2018-09-10_112441.jpg

Start Step

On theStart Step under Common Properties and Under Flow Data select Show Editor and add Flow input data. For this example, accountid (string) is used as theInput name.
2018-09-10_113423.jpg

Get Groups For Account

Select Get Groups For Account Step. Under Inputs next toaccount id chooseSelect From Flow and Pick theInput name created on theStart Step.
2018-09-10_114016.jpg

End Step

Select theEnd Step under Common Properties. UnderData and underOutput select Show Editor to add Output Data. For this example,grouplist (Group) is used as theOutput name. Under Inputs and next to grouplistchoose Select From Flow
2018-09-10_115158.jpg

Now save and exit the flow to Navigate back to the designer Folder.

Create a Report

In the designer Folder create a Report that collects and displays all Accounts and a Report that displays the Groups.

Account Report

Create a report that passes in Account as the Data Source. Under Data Sources select Common and then Account Data Sources. UnderData Fields select Add and choose the Fields that will display on the report. The report example hasEmail Adress and Account ID added to the Fields displayed.
2018-09-10_133314.jpg

In Data Fields select Account Id column and select Send Data as Filter Change Source and make the Filter change source accountid. This name has to match the configuration name on the other report. 
2018-09-11_095635-1.jpg

Group Report

Create a report that is sourced from a Flow. This example shows the Flow Output name isgroup list. To pass in the Flow Data in the report selectAdd underData Sources chooseGroup Report Source Flow. Under Data Fields select Add to choose the Data Fields for display**.** Next, under Settings and underRuntime Behavior chooseGet Values From Other Reports. UnderConfiguration enter the Input name created on theStart Step.
2018-09-10_133043.jpg

Create a Page

Create aPage that displays both reports, using theReport Viewer. Select a row in the account, theReport Viewer will show all groups associated with the selected row.  In this example, admin@decisions.com is selected on the left side of the Report Viewer and on the right side of the page the groups are listed under Group Id.
2018-09-11_101654.jpg

Was this article helpful?