Reporting Services
If you get the following error when trying to export a Local Reporting services report to excel or pdf: Internet Explorer cannot download … ReportViewerWebControl.axd from <server name> Internet explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later. You might want to check the properties on your virtual directory. Here is mine before I made the change. As you can see it is set to “no-cache”. What I think is happening is that IE...
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)...
Question: How do you create a green-bar (zebra stripe) report using groups in reporting services?
Answer: I have seen many examples of creating green-bar reports where each record alternated colors. All one has to do is add a row_number field to their query and use the following expression in the Background color property of the Table Row.
=iif(Fields!row.Value Mod 2 = 0,"Green","White")
But when doing groups and you want each group to alternate colors it is a little more complex, but the trick is still the same. Following the same principal I needed a way to get row numbers for each Group...
The other day I was talking to another local developer that was interested in using reporting services, but while the “Report Viewer” control provided by Microsoft is fast and easy it doesn’t necessarily fit into the business requirements that his users have outlined. To that end it is a good thing that Microsoft provided Web Service access to all of the report servers functionality. Since a high level of customization is needed to the UI and the Report Server already provides much if not all of the data you need to build it my recommendation is to build the UI...