- In simplifying your task of putting the Workbook and Worksheets together
- and I can’t stress enough how much time this will save you from trying to re-jig your Web server to serve Excel documents using the Microsoft.Office.Interop.Excel library.
Sometimes when you are working with ASP.NET, you’ll want to be able to programmatically capture the HTML that gets output by your .NET code. Here are sample snippets in VB.NET and C# that should give an idea of how this is done. Continue reading “Catch the HTML for an ASP.NET Web Page”
SQL Server Reporting Services (SSRS) is a handy tool for generating reports quickly. However, like most reporting packages, making the reports dynamic rather than simple static canned reports takes a bit of effort. For example, you may want to let the users of your report choose from a list of options. You could then apply these choices to the report results in various ways such as using the user selections to filter the results, or to hide and show results columns. In general, adding a dynamic, customizable aspect to your reports adds value for your users beyond spitting back a simple canned set of results.
In this example I will be working with a SQL Server 2008 SSRS set-up, but the general concepts hold true for related versions.