We the reporting is definately going to take some work - but we already have a web based application that currently has preset reports that do the querying.  They'll have...

Currently the single database located at the Central location contains all the sales information for the remote sites.

Nightly on a scheduled basis the remote sites replicate information back to the...