Jason C Report post Posted December 6, 2012 Hi, We are experiencing issues with our charts automatically updating when data for a new year is entered into the source database. We are using mutli series bar charts with SQL as a datasource. We wrote our SQL in such a way that it would emcompass a rolling 24 month's worth of data. The data is grouped by month on the x axis and the series is grouped by year. Once users enter data for the next year, a new series is not created unless we manually edit each of the reports and go to the group and drilldown tab and click apply. Once we click apply the reports work correctly. How can we have the user's data in the database automatically update the reports as expected? Thanks, Jason Share this post Link to post Share on other sites
Rahul Kumar Report post Posted December 11, 2012 Hi Jason, We have were able to re-product this issue. This is occurring only if you are using grouping with "distinct values from field" option. The fix will be available in next minor release. Share this post Link to post Share on other sites
