Solved

SSRS Chart Hide Horizontal Axis

Posted on 2014-10-15
5
258 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
  • 3
  • 2
5 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 400 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

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…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now