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.
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.
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
Post a Comment