As part of a large organisation, out projects have to conform to various SOX requirements. One of these is that the requirements must be printed and physically signed off. I have managed to export the work items but the format is not suitable.
We use Crystal Reports Enterprise as our main reporting platform and thought the easiest way around this was to create a nice report in crystal complete with signoff page etc.
The report writing team can see the database but we have no idea as to what sort of sql query to use to retrieve all of the work items for a particular project. Does anyone have any ideas??

Many thanks

David