Clever Geek Handbook

XY-Scatter chart in SSRS does not display dots

I am a little confused about this.

I have a dataset with BackupDate and BackupTime as well as BackupType. BackupDate consists of 12 characters to the left of the datetime string in the table. BackupTime consists of 8 characters to the right of the same date and time string. For example: BackupDate will be "December 12, 2008" and BackupTime will be "12: 53PM."

I added an XY scatter plot to the report. I added a value "series" for the BackupType (so you can distinguish between the Full / Incr / Log backup). I added a value for the BackupDate category and set the scale for the X-axis from Min of BackupDate to Max of BackupDate. Then I added an item to the values ​​with the Y variable set to BackupTime and the X variable set to BackupDate. The Y-axis spacing is from 12:00 AM to 11:59 PM, and the formatting for labels is "hh: mmtt".

BackupTime is in Y-axis format. BackupDate is in X-axis format. 10 records are retrieved by my dataset and Legend is correctly populated with the BackupType field.

No points are displayed in the graph, and markers / pointers are not displayed if enabled. There should be a point on the graph for each point in time of each day, there is a specific type of backup.

Am I missing something? Does anyone know of a good tutorial dealing especially with XY scatter graphs and using them the way I intend to?

I am using the 2005 version of SSRS, not the 2008 version.

Screenshot of what my diagram looks like:

chart.jpg

In case it might be related to a dataset:

SELECT     TOP (10) backup_type, LTRIM(RTRIM(LEFT(backup_finish_date, 
                  12))) AS BackupDate, LTRIM(RTRIM(RIGHT(backup_finish_date, 8))) AS BackupTime
 FROM         DBARepository.Backup_History

As requested, here are the results of that query. There is a Where clause to limit the results to a specific database of a specific server that was not included in the above SQL query.

Log Dec 26 2008 12:00 PM
Log Dec 27 2008 4:00 AM
Log Dec 27 2008 8:00 AM
Log Dec 27 2008 12:00 PM
Log Dec 27 2008 4:00 PM
Log Dec 27 2008 8:00 PM
Database Dec 27 2008 10:01 PM
Log Dec 28 2008 12:00 AM
Log Dec 28 2008 4:00 AM
Log Dec 28 2008 8:00 AM
0


source to share


2 answers


As the data grows, the scatterplot avoids the x-axis values ​​if it expands the (float / numeric) constraints



0


source


Open chart properties -> X-Axis tab-> Minor tick mark-> Numeric or Timing Values ​​... It should solve your problem.



0


source






More articles:


All Articles