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
807 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
  • 3
  • 2
5 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

792 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