Reporting Services Website

Create an ASP.Net 2.0 website to display reports from SQL Server 2005 Reporting Services using Forms Authentication. The table containing the usercodes and passwords will be provided, and access to a Report Server will be provided. The website will provide a Sign In page, and then display a list containing the reports for that user. The user will select a report which will be rendered from the Report Server. Future projects will add additional functionality the website, but this first project is fairly simple: 1. Authenticate User 2. Render list of reports 3. Render selected report 4. Sign out ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Monday Dec 17, 2007 1:40:04 PM: Thank you for bidding. Attached is a zip file containing 2 files. One file contains an example of the snapshot report (Daily Activity Report). You will configure the Reporting Services to create it at 4:30am for each company for which files were received on that previous day. The other file contains a diagram of the database schema that is relevant to the Daily Activity Report. As you can see the TradingContacts table contains username and password columns that you will use to authenticate the signed in user. The Daily Activity Report consists mostly of data from the Transactions and Files tables. The List of Reports webpage that you will create, will retrieve a list of snapshot reports from the Report Server for the trading relationship (Relationshipid) to which the user belongs. A Windows 2003 server will be made available to you so that you can use Remote Desktop Connection to set up the ASP.Net 2.0 website, configure the Report Server, and add views to the SQL Server 2005 database. The database will be loaded with sample data so that you can test your code. ## Platform Windows Server 2003, SQL Server 2005