EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB313442: How to display the filter summary in a Report Services Document dynamically


Community Admin

• Strategy


This Knowledge Base article describes how to display the filter summary in a Report Services Document dynamically.

Symptom:
This Technical Note describes how to display the filter summary of a dashboard dynamically. This is useful for instances when dashboards has a filter panel with multiple filters. This will help the end user understand what selections have already been made without the need to go back to the filter panel to find out what was selected earlier.
 
As you can see below, it is unclear what selections have currently been made without scrolling through the various selectors in the filter selector:

ka04W000000OdspQAC_0EM4400000025SX.jpeg

 
Action:

  1. Create 2 text box, 1st as {&CurrentSelectionID:nodekey&} and 2nd as {Attribute@ID}
  2. Apply conditional formatting to text box 2 {Attribute@ID}, condition is: Selected Text Field Does not equal ""; formatting is replace text with All. As shown below:

 
            

ka04W000000OdspQAC_0EM4400000025SW.jpeg

 

  1. Put 1st text box above 2nd text box, and apply background color to 1st text box so that is covers the 2nd one.

 
After that, when users select some elements, the 1st text box will display selected elements and covered the 2nd one. When user selects nothing, both text box will be hidden so nothing displayed. When users select all, the 1st text box will be hidden while 2nd will display ALL. This is shown below:

ka04W000000OdspQAC_0EM4400000025SQ.jpeg

 
 

ka04W000000OdspQAC_0EM4400000025SV.jpeg

 


Comment

0 comments

Details

Knowledge Article

Published:

June 15, 2017

Last Updated:

June 15, 2017