I have a report that has balances on an account for most days since 1/1/2010. It was originally only run on weekdays and every so often the update would fail. When I graph this the labels are unreadable. I would like to be able to only show the label for the 1st day of each quarter whilst still showing the actual chart for every day. So the data will be every day but the labels would only show for say 1 Jan 2015, 1 Apr 2015, 1 Jul 2015, 1 Oct 2016, 1 Jan 2016, 1 Apr 2016 and so on.
The data includes a date formatted as 'convert(varchar(10),t.date,103) as Date1' but also has a date in the standard SQL date format ie 'yyyy-mm-dd hh:mm;ss.sss'
Any suggestions?