I have a scatter chart in SSRS (SQL Server 2012, Visual Studio 2010) that is producing the following:

There are five data points on there, however the result set I am using has 10 rows (a 'Completed Date' of datetime and a 'Lateness' integer whose values can be positive or negative.

This is the Dataset and the results it produces:

SELECT DISTINCT TOP 10 
  a.ACTIVITY_NAME As [Activity Name]
  , ad.COMPLETED_DATE As [Completed Date]
  , ad.DAYS_LATE As [Lateness]
  FROM ACTIVITIES a
	JOIN ACTIVITY_DATA ad ON ad.ACTIVITY_ID = a.ACTIVITY_ID
	LEFT JOIN ORDERS o ON o.ORDER_ID = ad.OBJECT_ID
	JOIN ORDER_ITEMS oi ON oi.ORDER_ITEM_ID = ad.ORDER_ITEM_ID 
	JOIN CUSTOMERS c ON c.CUSTOMER_ID = oi.CUSTOMER_ID
  WHERE (ad.KEY_DATE >= DATEADD(YEAR, - 1, GETDATE())) AND (ad.KEY_DATE <= GETDATE()) AND (ad.COMPLETED_DATE IS NOT NULL)
    AND a.ACTIVITY_ID = 21
  ORDER BY ad.COMPLETED_DATE DESC

Activity Name	Completed Date	Lateness
02 First fit    	2015-06-09 00:00:00	1
02 First fit	        2015-06-05 00:00:00	32
02 First fit    	2015-06-04 00:00:00	31
02 First fit    	2015-06-02 00:00:00	-13
02 First fit    	2015-06-02 00:00:00	-6
02 First fit    	2015-06-02 00:00:00	1
02 First fit    	2015-06-02 00:00:00	15
02 First fit    	2015-06-02 00:00:00	22
02 First fit    	2015-06-02 00:00:00	29
02 First fit    	2015-05-27 00:00:00	44

How can I tell SSRS to show every data point in my chart?

p.s. I have the Vertical and Horizontal Axes' set to an interval of 1 in the above image (nothing else has been altered from the default settings for scatter charts). Leaving the interval as Auto does not solve this problem.

Hi Matthew,

Please follow the below link,the issue was same as of yours.Hope you find it useful.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cd24556a-8486-4789-ae53-9b3f70c689b6/how-to-setup-a-scatter-plot-chart?forum=sqlreportingservices

Thank you Milan, however this doesn't help me.

This is the graph as it is currently showing, together with a table showing all of the data that the graph is also using:

This is how I have set up the Chart Data groupings:

I am looking for a graph that will eventually plot the 'Lateness' of events over time (including events that are early - aka have a minus value), with the date on the X axis and the 'lateness' on the Y. There are a number of different events I will be looking to plot in this way once I can get all of the test data points to show up (some events can have a couple hundred points, so I need to be sure that the test data is correct first).

Can you post a sample dataset for the report.

Hello Milan

The Dataset used is in my first post.

I have an 'Activity Name' field (nvarchar), a 'Completed Date' field (datetime), and a 'Lateness' field (int).

This is the sample dataset I am using for this specific forum thread (and the dataset used in all of my screengrabs above)...

Activity Name	Completed Date	Lateness
02 First fit    	2015-06-09 00:00:00	1
02 First fit	        2015-06-05 00:00:00	32
02 First fit    	2015-06-04 00:00:00	31
02 First fit    	2015-06-02 00:00:00	-13
02 First fit    	2015-06-02 00:00:00	-6
02 First fit    	2015-06-02 00:00:00	1
02 First fit    	2015-06-02 00:00:00	15
02 First fit    	2015-06-02 00:00:00	22
02 First fit    	2015-06-02 00:00:00	29
02 First fit    	2015-05-27 00:00:00	44

Hi matthewthedunce,

According to your description, the dataset contains ten records, but when display those data in a scatter chart, It only display five points, right?

In your scenario, when [CompletedDate] value is equal to 2015-06-02, there are multiple corresponding [Lateness] values. So when you add [ActivityName] field as a series group, it will display sum total values (48) for the 2015-06-02 instead of separate multiple data points.

If you want to display those ten points in a scatter chart, you can add [ActivityName] field as a series group, then delete group on expression in Series Group Properties. Please refer to screenshots below:

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu