?
Solved

How to set the number of x-axis labels dependent on the number of categories in an ssrs 2005 chart

Posted on 2010-09-23
5
Medium Priority
?
812 Views
Last Modified: 2012-05-10
I have a report that shows a chart showing how much money has been made over a period of time. It reports the total money received at monthly intervals. As time goes on, there are more and more monthly totals so my x-axis is starting to look very cluttered. I know you can set this manually to display the label of every nth month by setting interval = n, but Is it possible to set the x-axis interval using an expression to say if either:

1) if the first/earliest month is more than say 3 years ago then set interval to 5

or

2) if there are >  n number of categories (x-axis labels) then only display say every 5th category (month) xaxislabel.xls xaxislabel.xls
0
Comment
Question by:Grffster
[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 37

Accepted Solution

by:
ValentinoV earned 2000 total points
ID: 33751338
As far as I know you can't do that, at least, not in 2005.  The charts in SSRS 2005 do not accept much expression-based logic.  In SSRS 2008 however it is possible.  (So if you need a reason to convince your manager to get an upgrade, here's one.)
0
 

Author Comment

by:Grffster
ID: 33752879
Ewh...not great that then. What should I do with this question? Should I close it down or wait for another comment?
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 33755103
You could wait a bit to see if someone comes up with a clever solution to this problem.  If not then I believe my first reply would be a valid answer (even though it doesn't solve your problem, it would mean that the problem is unsolvable).

So no upgrade to 2008 in the near future then?
0
 

Author Comment

by:Grffster
ID: 33755403
Wish that was a possibility but I very much doubt it seeing the organisation I work for!
0
 

Author Closing Comment

by:Grffster
ID: 34044168
No other means of doing it in 2005 it seems.
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
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