1
Vote

A chart element with the name '' could not be found in the 'SeriesCollection'

description

Chart does not render due to the error message described in title. Reason for it is that at least one column is not named.
 
Example:
 
/ Query will return two columns: PageId and "unknown" /
SELECT [PageId], AVG([Rating])
FROM [sample].[dbo].[PageRating]
WHERE Rating IS NOT NULL
GROUP BY PageId
 
/ Workaround: explicitly name the column - "AS Rating" in this case /
SELECT [PageId], AVG([Rating]) AS Rating
FROM [sample].[dbo].[PageRating]
WHERE Rating IS NOT NULL
GROUP BY PageId

comments