Posted 22 Feb 2013
Link to this post
I have a report that contains many charts. In most cases it uses the same data but they are just grouped differetnly. Currently each chart has a differnt sqlDataSource. As you can figure this means it is slow to load. Is there a way I could return a generic dataset and then do the grouping, summing, and detemine percentage for each grid, that way I can make one or maybe two calls to the database and have the front end do all the work. Also is it correct to assume that this will be faster?