Rant start . . . .
I was in a meeting and we were talking about SSRS and I have heard yet again that Excel 2007 is great because it breaks the 65k record limit. That is wonderful, but IMHO, Microsoft has dropped the ball with SSRS 2008 since it is still using the BIFF file format.
From my read of Books Online (
http://msdn.microsoft.com/en-us/library/ms159836.aspx), “Excel places limitations on exported reports due to the BIFF's format capabilities” but why are we still using BIFF and XLS? Why are we not using XLSX and the newer (heck it is 3 years old now) file format?
Ok, rant over. . . . thanks for listening.