Line graph in Report Builder duplicating X-axis dates

0
votes

I am attempting to create a line graph in Report Builder using the following data:

TRWR    rental  85805   2013-09-14 13:02:54.900
TRWR    rental  74415   2013-09-15 18:00:00.420
VRWR    rental  83017   2013-09-14 10:03:43.597
VRWR    rental  73984   2013-09-15 18:00:01.203
HRWR    rental  83017   2013-09-14 14:03:15.497
HRWR    rental  74005   2013-09-15 18:00:01.957

And the query that I am using is the following: 

select ServerName, DatabaseName, FileSizeMB, DISTINCT PollDate from DBinfo
where DatabaseName IN (@Database) AND ServerName IN(@Servers) AND PollDate Between @StartDate AND @EndDate AND PhysicalFileName LIKE ('%mdf')

However, when I attempt to create the chart the X axis (dates) are duplicating. This is how I've set it up. Can anyone please show me how I can enter distinct dates. Please see the link for the image: http://imgur.com/7nhP3B6

1
reporting-servicesreportbuilder3.0

1 Answers

0
votes

Well even though it is not the best method for determining duplicates it gets the job done generally. I would guess the first step in debugging your method is your dataset is actually returning duplicates. You can avoid this by merely stating:

Select DISTINCT ....

versus

Select .....

This is merely SQL syntax telling the database engine to list a distinct row for each result.