Found quite a funky thing out today that i didn't know about with SQL reporting services. You can download the .rdl file from the web based reporting interface.
This could be very useful if you have lost a copy of the report, or want to look at how someone else has done something
- Within the web browser interface into the reports, click on a report, then click its properties tab
- On the general section, just above the apply etc buttons is a little section called Report Definition
- Click on edit and this will then download a copy of the report as a .rdl file you can open in visual studio, easy!