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
806 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SHOWPLAN permission denied in database 'AdventureWorks'. 13 99
SSRS 2008 Multi Value Parameter Filter using OR 3 39
sql query help 2 51
SSRS troubles 4 47
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…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

786 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