CODEWITHSUNDEEP
reporting-services
M.JAY
M.JAY

Reputation: 193

SSRS: x-Axis display less characters

I would like to display less characters in the x-axis of my diagramm. How can I do this. The x-axis now is too large:

enter image description here

I would like to display the characters like this here:

enter image description here

Is this possible?

Upvotes: 1

Views: 103

Answers (1)

Matej Hlavaj
Matej Hlavaj

Reputation: 1038

Yes ofc you can. For example you can use Expression if you want in Category group settings:

enter image description here

In properties chose Label Expression (fx button):

enter image description here

And create your expression, for example following showing 20 left chars + ... if lenght of string is more than 20: 

=IIF(Len(Fields!groupX.Value) > 20,Left(Fields!groupX.Value,20) + "...",Fields!groupX.Value)

Where 20 is limit number of chars showed up in your chart...

Upvotes: 1

Related Questions