Control Child Report Filter Value From Master Report Field
  • Updated on 09 Dec 2014
  • 3 minutes to read
  • Print
  • Dark
    Light

Control Child Report Filter Value From Master Report Field

  • Print
  • Dark
    Light

This tutorial demonstrates how to send a value for the Filter from Master Report to Child Reports that are on the same Page by clicking on the Field in Master Report.
Example
For this Example we need to create two Reports (Master and Child ) and a Page to display them.
We begin in a Designer Folder with clicking Create Report > Create Report from Folder Actions panel.
Next, we name Report and click Create to proceed to the Report Designer. This is going to be a Report of all Folders and it is going to serve as Master Report that will send values to dependent Reports .
2018-07-02_150407.jpg

In the Report Designer we addFolder Data Source from Data Source > Common category in the ToolBox .
2018-02-09_123628.png

Next, from Folder Data Source we add desirable columns to our Report .
2018-02-09_123644.png

OurFolder Id column will be sending its field values to other Reports . To set this option we select Folder Id column and locate its Properties . Then, we check Send Data As Filter Change Source checkbox.
Filter Change Source Name text box shows up. Here we need to enter the name of the Filter we want to send values to. Entity Folder Id Equals is the name of the Filter we are going to use in our Child Report.
2018-02-09_123725.png

This completes our Master Report. We can save it and close to return back to our Designer Folder.
In theDesigner Folder we click Create Report > Create Report to create second Report for this Example . Next, we name our Report and click Create to proceed to the Report Designer.
2018-02-09_123835.png

In the Report Designer we add Entity Data Source from Data Source > Common category in the ToolBox .
2018-02-09_123913.png

Next, we add desirable columns to our Report from Entity Data Source.
2018-02-09_123938.png

Then, we need to add and configure a Filter for this Child Report that will accept values from the Master Report. We add Entity Folder Id Equals filter from Data Filters > Field Filters > Entity Folder Id category.
2018-02-09_124031.png

We select this Filter and locate its Properties . We change its Runtime Behavior to Get Values From Other Reports type.
2018-02-09_124108.png

This completes ourChild Report design. We can save it and close Report Designer.
Next, we need to create Page to display these Reports . In theDesigner Folder we click Create Page/Dashboard from Folder Actions panel.
2018-07-02_151252.jpg

Name the Page and click Create to proceed to thePage Designer.
2018-07-02_151610.jpg

In the Page Designer we use Report Viewer component from Reports category in the ToolBox to display our Reports . We use Default Report picker for this component to pick our Master Report.
2018-07-02_151745.jpg

Similarly we add another Report Viewer component to the Page and pick our Child Report as Default Report for this component.
2018-07-02_151834.jpg

This completes our Page design. We save and close Page Designer.
In the Designer Folder we clickManage > Page > Display Existing Page option to add new custom view to our Folder .
2018-07-02_151949.jpg

Both Reports shows up. We select any Folder in the Master Report and observe how the Child Report fills up with entities that reside in the selected Folder .
We can use search bar on the Master Report to search for our Designer Folder. When found, we select it and observe that Child Report Refreshes and reflect all entities that are in our Designer Folder.
firstTest.png

Download Example: Report Filter Example

Was this article helpful?