Getting Started with SSRS and ASP .net

Here are few notes (mostly links) I accumulated as I grew accustomed to integrating SSRS with ASP.net

To render reports using SSRS, you can use the report control which is pretty easy to use in ASP .net

I was using Visual Studio 2010 with SQL Server 2012.

I mostly use MVC3, but getting started with asp .net wasn't too hard.

Here are some helpful beginner asp .net links:



Creating your first page :

• http://www.codeguru.com/csharp/.net/net_asp/tutorials/article.php/c19305/Writing-Your-First-ASPNET-Page.htm
• http://www.w3schools.com/aspnet/aspnet_pages.asp

Set contents of div from code behind : http://stackoverflow.com/questions/5703419/how-to-change-the-inner-html-of-a-div

Get name of host : http://stackoverflow.com/questions/646525/getting-the-ip-address-of-server-in-asp-net


Check if listbox/dropdown box has nothing selected : http://stackoverflow.com/questions/3034442/how-do-i-check-if-selected-value-of-the-listbox-is-not-selected-in-c


SSRS

If you don't know how to set up SSRS: http://beyondrelational.com/modules/12/tutorials/26/tutorials/4598/geting-started-with-ssrs-part-1-sql-server-reporting-services-overview-and-installing-in-windows-ser.aspx

Looks to be a common problem with SSRS : first report of the morning starts very slow. This article presents some possible solutions : http://www.mssqltips.com/sqlservertip/2735/prevent-sql-server-reporting-services-slow-startup/

Now, to get your reports to come up in your asp .net program.

Setting up SSRS in Visual Studio

Set up asp.net app with SSRS : http://blog.infotoad.com/post/2009/07/02/Integrating-Reporting-Services-with-Web-Applications.aspx

Ways of Connecting to SSRS: http://msdn.microsoft.com/en-us/magazine/cc188712.aspx

Enabling impersonation : http://msdn.microsoft.com/en-us/library/bb909707%28v=vs.90%29.aspx

Adding a web reference in VS for SSRS : 

• http://msdn.microsoft.com/en-us/library/ms169926%28v=sql.90%29.aspx
• http://msdn.microsoft.com/en-us/library/ms169816%28v=sql.105%29.aspx

REport content doesn't show up : 

http://stackoverflow.com/questions/1772557/in-vs2010-beta-2-the-web-report-viewer-does-not-display-the-content-of-the-repo

Login to report server via reportviewer control : http://social.msdn.microsoft.com/Forums/en/vsreportcontrols/thread/5aa7eee7-d4a7-427a-ab8d-7a3d4d4f0bf3