January 28, 2009 at 3:52 am
I would like to know if a cumulative line chart can stop the line for the series part way across the chart if there are no later results.
I have a report in SSRS 2008 which was written originally in SSRS 2005. It shows the transaction sum for the month across the year (year is a series). However where the are only results for January in 2009 the results show as one line across the whole year, can the line stop at February? When I run the report in 2005 the line stops at February so I'm not sure why in 2008 it shows the same value all the way up to December.
I couldn't find anything like this on this or any other website so any ideas to help me would be gratefully recieved.
Many thanks.
February 11, 2009 at 2:04 pm
lisa.hamblin (1/28/2009)
I would like to know if a cumulative line chart can stop the line for the series part way across the chart if there are no later results.I have a report in SSRS 2008 which was written originally in SSRS 2005. It shows the transaction sum for the month across the year (year is a series). However where the are only results for January in 2009 the results show as one line across the whole year, can the line stop at February? When I run the report in 2005 the line stops at February so I'm not sure why in 2008 it shows the same value all the way up to December.
I couldn't find anything like this on this or any other website so any ideas to help me would be gratefully recieved.
Many thanks.
I'm having a similar issue to yours: a column chart that was rendering normally in SSRS 2005, is displaying empty (no data) in SSRS 2008. It is the same report!
I'm guessing this has something to do with the new Date/Time datatypes in SQL 2008, but this is just pure speculation at this point.
I think there may be a common cause behind both issues.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 11, 2009 at 2:16 pm
One clue that might help:
I just opened my report in BIDS 2008 and the chart looks different in the layout tab. Moreover, I have been able to reproduce the report-server behavior in the Preview tab: they are both showing an empty chart.
Looks like some chart settings have changed in the 2 versions: SSRS 2005 and 2008.
I would suggest that, if you can, open your report in BIDS 2008 and troubleshoot from there. Once you get your chart to display as expected, redeploy your report from there.
If I come up with anything more, I will post it here.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 20, 2009 at 3:37 am
Thanks for your reply, I'm working in BIDS already & like you say it's showing the same error there. I can't find anything different with the dates. The field I'm bringing through is datetime, I'm not sure if thats different to you or not.
I think I'm just going to have to hope that this is a bug that Microsoft will fix with an update at some point but if anyone out there comes up with a solution before then please post it here.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply