reporting services - Set chart axis label for individual groups with an expression -


i'm on vs2012 ssrs , trying report prepared each agentid. agent needs see bar highlighted , ids other agents should hidden.

we agreed can go plan a putting or planb hiding ids other selected 1 horizontal label.

i've illustrated in picture id 22222.

i managed highlight bar expression on fill property of series. i'm not sure how modify axis label individually. think property axis label refers label every group. can hide of them, can't manipulate them individually.

enter image description here

in category group properties can dynamically assign axis label entry. on value-by-value basis , effects labels, not grouping. if have multiple labels end same won't end grouped together.

category group menu

category group properties

so in case expression label like

=iif(fields!agent_id.value=parameters!agent_id.value,fields!agent_id.value," ") 

do note: i've used space(" ") , not empty string(""). using empty string ssrs fill empty categories numbers. space blank out category name.


Comments

Popular posts from this blog

android - Gradle sync Error:Configuration with name 'default' not found -

java - Andrioid studio start fail: Fatal error initializing 'null' -

html - jQuery UI Sortable - Remove placeholder after item is dropped -