On Fri, Jan 16, 2015 at 3:57 PM, Alan Bourke <[email protected]> wrote:
> Yes I always get the data into the subset required, grouped and sorted > insofar as possible, before reporting. Especially with big datasets. > -------------- This report was taking a few hours to pull data for 2014. I have it now around 30 seconds to get EVERYTHING. Now setting the If clauses to only pull what is needed from this beast. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYJXFyYb9QJn9=ctopkfz3acm3gvauyfvkjcfxxpyw4...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
