|
|
|
|
SQL Reporting Services - Answers to your questions
| |
|
Author |
Thread:
How can I get a static X Axis in SSRS |
|
MaxStein
|
How can I get a static X Axis in SSRS
Posted:
Sunday, February 14, 2010 9:56 AM (GST)
|
|
I've got a pretty simple need for a graph, or at least I thought it was.
We have a number of time based products and I'd like to have a chart that goes:
<1 Hour 45 Mins 30 mins 15min OnTime
But not all products have files arriving in every timeframe, so may appear as:
45mins 15mins
As you can imaging this makes reporting for management impossible.
I have tried two methods:
1) Nested select where I set each of the required fields and does a count, therefore every result shows all five values, but I cannot figure out how so make a chart work from these values
2) Using case - this was I can do a create a timeval field with the values "! Hour", "45 ins" etc etc, but that is where I end up with some of these values not appearing, so don't get the full chart.
Any ideas as I've been going round in circles for days now!!
Oh, we're using SQL 2005.
|
|
|
|
|
|
|
|
|