May 18, 2017 at 11:27 pm
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?
May 25, 2017 at 5:42 am
haven't tried it, but does the visibility property allow you to achieve this by only being true if it's one of those dates?
alternatively, have a chart that summarizes by quarter, and then takes you to a subreport on just that quarter's data to make it a little more readable
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply