The Tally Table has proven to be a simple and elegant method for avoiding many varieties of RBAR. Unfortunately, one of its more common uses, that of a CSV splitter, has a well-known and serious performance problem. MVP Jeff Moden shows us what that problem is and how to correct it. (UPDATED with additional info and attachments on 5/12/2011).
In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.
The sample was not showing hidden when I would go through the "Edit Group" route, so this was how I setup my report. But when I went into the XML, it listed the hidden and toggle item properties. I didn't know they wee separate items and thought the Wizards (Edit Group, etc) read and wrote […]
I totally agree with ron... it's better to have less data that is accurate than all the data that might be...