This is a most entertaining thread.
I could help with the SSIS stuff (thanks Jeff!) - if it were needed, but it is not.
First task: write the proc to return the data in the required format. With parameters to limit selection, based on requirements.
Second task: develop whatever SSRS reports are needed, using the proc as a data source.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.