Shawn Weisfeld

I find when I talk to myself nobody listens. - Shawn Weisfeld
posts - 364, comments - 174, trackbacks - 34

My Links

News


Shawn Weisfeld's Facebook profile

The views expressed in this blog are mine and mine alone, not that of my employer, Microsoft, or anyone else’s. No warrantee is given for the quality of any material on this site.

Archives

Post Categories

Reporting Services

Cannot export Local Reporting Services Reports to excel or pdf?

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...

posted @ Wednesday, April 21, 2010 11:15 PM | Feedback (2) | Filed Under [ Reporting Services ]

Reporting Services 2008 is still using the XLS (BIFF) file format

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)...

posted @ Tuesday, March 9, 2010 2:41 PM | Feedback (0) | Filed Under [ Reporting Services ]

Creating a Green-Bar (Zebra Stripe) Report on Groups in Reporting Services

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...

posted @ Tuesday, October 16, 2007 10:34 AM | Feedback (0) | Filed Under [ Reporting Services SQL ]

SSRS Web Services

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...

posted @ Wednesday, January 3, 2007 6:58 PM | Feedback (0) | Filed Under [ ASP.NET C# Reporting Services ]

Powered by: