There is an existing MS Access database querying data in MS SQL Server 2000
It produces Sales reports -
by Customer,
by Product,
by Product Group,
by Territory,
by Territory and Customer,
by Territory and product Group,
Columns for Sales, Margin, both Selected period and Total Year to date
The job is to -
install SQL Server Reporting Services on our Windows 2003 Server,
re-create the existing Access reports,
setup secure user Access in IIS for users on our LAN,
provide instructions on how to maintain the reports