Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
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
?
815 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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

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…
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

604 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