Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 817
  • Last Modified:

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

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
Grffster
Asked:
Grffster
  • 3
  • 2
1 Solution
 
ValentinoVBI ConsultantCommented:
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
 
GrffsterAuthor Commented:
Ewh...not great that then. What should I do with this question? Should I close it down or wait for another comment?
0
 
ValentinoVBI ConsultantCommented:
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
 
GrffsterAuthor Commented:
Wish that was a possibility but I very much doubt it seeing the organisation I work for!
0
 
GrffsterAuthor Commented:
No other means of doing it in 2005 it seems.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now