Example Project - ASP.Net - VB.Net - SSRS

I have several enterprise level reports that I am going to parse and load into various tables in SQL Server 2012. I am then going to need to divide out the data by region and distribute to the regional personnel. I have a web server (2008 R2) that I would like set up a website to allow regional users to download data through either a dynamic query to excel or text file for review. I was hoping someone might have a link to a sample project (asp.net: VB.Net or C# ) which is similar so I can use it as a reference point to build from. I am not tied to any specific implementation but I was considering using SQL Server Reporting Services for the report information and using a web application to manage the download and security. I am not tied to any specific methodology but I would like to use the 2 tools (sql server / web server) that already have project approval. Please provide a link to any relevant examples or provide alternative method for implementation. Thanks in advance for your help!