A SQL Server (2005 or later) database has the ability to log changes and deletions to tables in the database. Changes are logged to dedicated tracking tables in the database. We require some reports to view this data.
There is no need to be concerned about how the changes are being logged to these tables as the requirement is strictly reporting.
We require three reports to be developed to display this data.
1. An update summary report, listing changes for a specific filter (User, date etc..).
2. An update details report, which sumarises all changes for a single table/record.
3. A data deleted summary and detail report.
The app should be written in VS2010 ASP.NET (C# or VB.NET OK).
The tool used for reporting should be standard .Net components, Crystal Reports (for VS 2010), or an equivalent if nominated in the proposal and if we approve it. ReportViewer RDLC reports will also be OK (full reporting services is not available) if they can meet functionality requirements.
There should be no components that cannot be easily deployed using one click deployment or have a royalty as the IT environments is restrictive.
The reports should be viewable in Internet Explorer or other browsers without plug-ins. An export to PDF and Excel should be available.