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
Solved

SSRS Chart Hide Horizontal Axis

Posted on 2014-10-15
5
268 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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Suggested Solutions

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

839 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