With a functional RSP and the knowledge of how to make some basic queries, you should now be prepared to create new reports or edit existing reports. This can be done straight from the CM12 admin console, straight from your RSP, or using Microsoft SQL Management Studio.
If SSRS was installed with SQL 2008 and not 2008 R2 or 2012, CM12 will start Report Builder 2.0 if you right-click on a report and select Edit. If you are on SQL 2008 R2 or 2012, you will get an error stating that Report Builder 2.0 is not installed as a click-once application on the report server. In this case, you must edit the report from Report Manager (the RSP website).
To upgrade your admin console to leverage Report Builder 3.0, follow the steps listed at http://technet.microsoft.com/en-us/library/gg712698.aspx.
The steps that follow below are for the more common version—Report Builder 3.0. We're going to start by editing one of the built-in reports.
Additionally, it's rather...