How to: Locate and Edit a Report
You can customize or change the reports that are created by either the process template or by users manually. To edit and re-deploy a report, your user account must be a member of the Content Managers role in SQL Server Reporting Services.
To connect to the Team Foundation data warehouse, you will need the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider installed on the computer. The driver is available through the Microsoft Download Center (http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc).
Contact your Team Foundation Server administrator or your team project administrator to make sure that your user account has the permissions described in the following section.
To edit and re-deploy a report, you must be a member of the SQL Server Reporting Services Content Managers role. For more information, see Team Foundation Server Permissions.
To change a report
In Team Explorer, click the team project node.
On the Team menu, click Show Report Site.
In Report Manager, click the name of the report.
Click the Properties tab, and then click Edit.
In the File Download dialog box, click Save.
In the Save As dialog box, navigate to the location to save the edited report, and then click Save.
Team Explorer saves a copy of the report .rdl file to the local computer.
In the Download Complete dialog box, click Close.
In Visual Studio, on the File menu, point to New, and then click Project.
In the Project types pane of the New Project dialog box, select Business Intelligence Projects.
If Business Intelligence Projects does not appear in the list of project types on the local computer, you must install SQL Server Business Intelligence Development Studio on the computer.
In the Templates pane, select Report Server Project.
In the Name box, type a name for the project, and then click OK.
On the Project menu, click Add Existing Item.
In the Add Existing Item dialog box, navigate to the location where you saved the report .rdl file, and then click Add.
The report file is added to the new report project.
On the View menu, click Solution Explorer.
In Solution Explorer, click the report .rdl file.
On the View menu, click Designer.
In the IDE, make the changes to the report.
On the Project menu, click report name Properties.
In the project name Property Pages dialog box, expand the Deployment node.
Set the OverwriteDataSources property to False.
Set the TargetDataSourceFolder to /.
Set the TargetReportFolder to the name of the destination folder.
Set the TargetServerURL to **http://**application-tier server/reportserver, and then click OK.
On the Build menu, click Deploy project name.