?
Solved

SSRS Chart Hide Horizontal Axis

Posted on 2014-10-15
5
Medium Priority
?
296 Views
Last Modified: 2014-10-22
Hello Experts Exchange
I am developing a report in SSRS that has a chart, when the chart has only a few categories going along the horizontal axis the chart looks fine, however when there is a lot of categories the chart gets very messy and unable to read the data.

Is it possible to have a expression so if the categories go over 5 then the horizontal axis is hidden?  

If so where would the expression go and what would it look like?

Regards

SQLSearcher
0
Comment
Question by:SQLSearcher
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 1600 total points
ID: 40382034
Make sure the Properties pane is visible (press F4 if it isn't).

Click on the Chart Axis.

Go to the Properties pane - Visible. Click on the drop-down arrow and select "<Expression...>"

Change the "Set expression for: Visible" to

=CountDistinct(Fields!myField.Value)<6

where myField is your category field.
0
 

Author Comment

by:SQLSearcher
ID: 40382076
Hello Phillip
I have just tried your steps and it did not work my chart still looks crushed with data.

I set the visible properties to this;
=CountDistinct(Fields!Level_3.Value)<6

Is there something else I should try?

Regards

SQLSearcher
0
 

Assisted Solution

by:SQLSearcher
SQLSearcher earned 0 total points
ID: 40386320
Hello Phillip
I found the right expression that is needed to make the axis visible and hidden.

The expression is;
=IIF(CountDistinct(Fields!Level_3.Value)<6,"True","False")

Thanks for your help.

Regards

SQLSearcher
0
 

Author Closing Comment

by:SQLSearcher
ID: 40396445
Found part of the solution myself.
0
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40396664
Excellent - well done.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question