?
Solved

SSRS Chart Hide Horizontal Axis

Posted on 2014-10-15
5
Medium Priority
?
329 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 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

621 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