Reports Sharing Filters At Runtime
Create the Parent Report
1 Create a Report.
2 In the Report Designer, within the Data Sources column, select the Add link to add Accounts as the Data Source to the Report.
3 Add Email Address and Created On Date as the Data Fields.
4 Add Email Address Contains Filter from Filters > Add > Field Filters > Email Address.
5 Select the Filter just added to the Report and locate its Settings.
6 Under Runtime Behavior, select Runtime Editable in the drop-down menu.
7 Set Show All Data When Filter Value Is Empty to true.
8 Select the Email Address Data Field.
9 Expand the Settings, set Send Data As Filter Change Source as true, then type "Email Address Contains".
10 Save and close the Parent Report.
Create the Child Report
1 Create a Report; under Data Sources, select Add. Choose Folder Data Source.
2 Add Entity Name and Created By as the Data Fields.
3 Under Filters, add Created By Contains Filter.
4 Navigate to the Filter Settings and rename it "Email Address Contains".
5 In the Runtime Behavior drop-down, select the Get Value From Other Reports option, as this is the Child Report that will use the Value from its Parent Report.
6 Save and close the Report.
Debug
Add the two reports to a Page.
1 Select the filter icon on the Parent Report. Type a desirable value into the Parent Report's Email Address Textbox. Select APPLY.
2 As expected, it affects both Reports.
from: https://documentation.decisions.com/v9/docs/reports-sharing-filters-runtime
Howdy, Stranger!
Categories
- 4.1K All Categories
- 57 General
- 11 Training
- 200 Installation / Setup
- 1.1K Flows
- 106 Rules
- 259 Administration
- 212 Portal
- 487 General Q & A
- 690 Forms
- 332 Reports
- 3 Designer Extensions
- 47 Example Flows
- 51 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 176 Pages
- 5 Process Mining
- New Features
- 176 Datastructures
- 68 Repository
- 214 Integrations
- 28 Multi-Tenant
- 27 SDK
- 75 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 62 Lunch And Learn Questions