Get Report Filter Values from Other Sources
  • Updated on 02 Oct 2014
  • 4 minutes to read
  • Print
  • Dark
    Light

Get Report Filter Values from Other Sources

  • Print
  • Dark
    Light

In this example we are going to demonstrate how to use a Flow to Coordinate run time editable filters on a report.

Example
We begin in Designer Folder with creating desirable number of Reports . For this example we create two Reports: Accounts Report and Folders Report. To create a new Report we click Create Report from Designer Folder Actions menu. We select Create Report from this drop down menu.
CREATE-ACTION-BAR4.jpg

Next, we name Report and click Create to proceed to Report Designer.
2018-06-28_114948.jpg

Our first Report designed as follow. It has Account Id and Email Address columns from Account Data Source . In addition, it has Email Address Contains Filter that was intentionally renamed to MyNameFilter .
Set Runtime Editable option from Runtime Behavior dropdown menu. We left Value setting blank. This Value will be controlled with our Flow that we will create shortly in this example.

2018-06-28_115440.jpg

In exactly the same way we create our second Report . We used Folder Data source for the Report and Folder Name Filter that was renamed to MyNameFilter as well. Mention that we need to use the same name for all filters in our reports that we want to control with our Flow. In the second Report MyNameFilter is configured the same way it was configured in the first Report .
Back in our Designer Folder we click Create Page/Dashboard to create new Page .
We name our Page and click Create to continue to the Page Designer.
2018-06-28_115739-1.jpg

In our Page Designer we drag our Reports to the workspace. To do it we dragData View item that refers to our Reports . This item is found in the ToolBox in Reports > [Existing Reports] > [Current Folder] > Report: Report Accounts for our Accounts Report, and in Reports > [Existing Reports] > [Current Folder] > Report: Report Folders for our Folders Report.

2018-02-12_113531.png

Next, we need to get our Folder's Id to use in our Flow. We expand our Folder's Options and select Manage > Get Designer Project ID.
2018-06-28_125639.jpg

In the resulting pop-up window we copy Designer Project Id to the clipboard and click Ok to close it.
2018-06-28_125653.jpg

Now we can create our Flow. We click Create Flow in Designer Folder to create a new Flow.
CREATE-ACTION-BAR5.jpg

We name our Flow and click Create to proceed to the Flow Designer.
2018-06-28_125758.jpg

When Flow Designer opens we use Quick Add Step dialog to add New Form to our Flow. We Expand Flows, Rules, Forms and Reports > Forms[Interaction] section and select [Pick or Create Form] step. We give our step name and click Add to add it to our Flow.
2018-06-28_130011.jpg

Next, we create a new form and proceed to the Form Designer. Our Form is designed as follow. It has a TextBox for user's inputs that we are going to use as a Value for our Filters and a Button for user to submit the request.
2018-06-28_150721.jpg

When finished we save our Form and close Form Designer to get back to our Quick Add Step dialog . Next we expand Flows, Rules, Forms and Reports > Forms[End] category and select End Form Session step. We click Add to add it to our workspace.
2018-06-28_141258.jpg

Next, we use Quick Add Step dialog to connect End Form Session to the End step in our Flow. Expand Steps In This Flow category, select [End Step] and click Connect .
2018-06-28_141352.jpg

Select our End Form Session step on the workspace and select Navigate from its Behavior > Options dropdown menu.
2018-06-28_141653.jpg

We locate Parameters options for our End Form Session step and click Add New link to add new Parameters .
In the resulting pop-up window we specify the name of our Parameter. For every runtime filter we want to set, we specify the filter name, a dot, and then the property name like this: MyNameFilter.Value . We define its type String . Then, we click Ok to save and close this window.
2018-06-28_142026.jpg

Next, we need to configure mapping for the Inputs for our End Form Session step. For Folder Id we use our Designer Project Id from previous steps in this tutorial. For our Parameter MyNameFilter.Value we use user's input from the first Form in this flow. Finally, for the PageName we use the name of the Page we created earlier that contains our Reports.
2018-06-28_142306.jpg

This completes our Flow. We can save and close it to return back to our Designer Folder. We locate Thumbnail for our Page and click Edit Page from its Action menu.
2018-06-28_143040.jpg

In the Page Designer we expand Flows category in the ToolBox and drag Flow Run Part component to our workspace.

2018-06-28_143225.jpg

For Flow Run Part component we use Flow Id picker button to pick our controller Flow that we have created previously for this tutorial. This completes our page. We save and close Page Designer.
2018-06-28_143246.jpg

Back in our Designer Folder we use the View that we have created using our Page to test the results.
Our Reports are shown and we type our request into the Flow's Text Box and click Button to see if this request will apply to both Reports. 
2018-06-28_143740.jpg

Was this article helpful?