>I have an application which contains a number of standard reports which generally meet the needs of users. I am looking for a system which I can use to allow end-users to design occasional use reports. It looks like Crystal Reports will support this but does anyone know of any other tools which can meet this need.

Try Stonefield Query. It allows users to create all sorts of reports in run-time.