Solved

SSRS Chart Hide Horizontal Axis

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

733 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