Intranet Report is a web based reporting tool for small and medium businesses.
The Problem Domain
Typically a business will have an Accounts software and an operations software. chances are that these systems are built over databases like access, sqlserver or other databases. if these databases can be connected by ODBC or OLEDB then you can develop custom reports for the data that is available.
Usually a custom report is in a fixed format and you would need the developers services again just to change the layout of the report.
Generic reporting tools like crystal reports are too expensive for small businesses and may not be justified by the returns.
Simplesoft has developed an application that can solve some of the reporting issues faced by the small and medium businesses.
Intranet Report Design
Intranet report is designed to be an application that will allow a person knowing the database and sql to create reports for the organization.
First the designer creates a view that has all the required data for the report. this can be done using the database view creation utility.
Then using the view you can define the report columns and rows information.you can also define a detail report for a particular data item on the report.
The report may depend on a data store that is refreshed by running a particular stored procedure or sql, this can also be defined along with the report so that when the report data is refreshed then the underlying data is also refreshed.
The Reports can be cached based on the business requirement and to avoid load on the live data.
The Reporting application has a built in rights management module that can be used to manage users and report rights.
A demo of the front end application can be seen here
System Requirements
Webserver IIS 6 .
Dotnet Version 2+
MSDE database / SQLserver
ADS Aware can be used in an active directory setup.
Application is developed using
Visual basic 6 , C# for the web front end , SQL server for the Configuration settings data.
You can Email 
