I created reporting on a 1-year long decommissioning project. I developed complex stored procedures using Dynamic SQL in order to combine reports that were originally in Crystal and Business Objects and bring them into SQL Server Reporting Services and be highly interactive and flexible for whatever were the needs of the end users.