0
votes

I'm on VS2012 SSRS and trying to do a report prepared for each AgentID. The agent needs to see his bar highlighted and IDs for other agents should be hidden.

We agreed I can go with plan A putting or planB completely hiding IDs other than the selected one from horizontal label.

I've illustrated this in the picture with ID 22222.

I managed to highlight the bar with an expression on the fill property of the series. But I'm not sure how to modify the axis label individually. I think that the property for axis label refers to the label for every group. I can hide all of them, but can't manipulate them individually.

enter image description here

1

1 Answers

2
votes

In the category group properties you can dynamically assign the axis label for the entry. This is on a value-by-value basis and only effects the labels, not the grouping. So if you have multiple labels that end up the same they won't end up grouped together.

category group menu

category group properties

So in your case the expression for the label would probably be something like

=IIF(Fields!AGENT_ID.Value=Parameters!AGENT_ID.Value,Fields!AGENT_ID.Value," ")

Do note: I've used a space(" ") and not just an empty string(""). Using an empty string SSRS will fill the empty categories with numbers. A space will blank out the category name.