<div>
You must get the RDL and edit with VS2008 or VS2005 (which ever was use to do the report) Create SQL Report Project on the visual studio and import the reports from the Sharepoint folder.
</div>


You must get the RDL and edit with VS2008 or VS2005 (which ever was use to do the report) Create SQL Report Project on the visual studio and import the reports from the Sharepoint folder.

<div>
<div class="content wysiwyg-content">
We have Sharepoint with SSRS 2005. &nbsp;Our previous developer created some reports (.RDL) and published them in Sharepoint.<br />
I need to make some edits to these reports (adding a column).<br />
How can I do this?<br />
<br />
I know these RDL reports are not actual files (that I can browse to via Windows Explorer) but are saved in the SQL database somewhere.<br />
I'm going to <a href="http://localhost" rel="ugc">http://localhost</a>&nbsp;and log in to Sharepoint as an admin. &nbsp;<br />
<br />
When I click on a report in the browser, each report has an &quot;actions&quot; menu in the upper left corner. &nbsp;<br />
The options in this actions - menu are: &quot;open with report builder&quot; (which doesn't work since SSRS is running within sharepoint), &quot;subscribe&quot; and &quot;export&quot; (which exports the report data, not the rdl).<br />
<br />
How can I edit the rdl report? <br />
<br />

</div>
</div>


We have Sharepoint with SSRS 2005.  Our previous developer created some reports (.RDL) and published them in Sharepoint.
I need to make some edits to these reports (adding a column).
How can I do this?

I know these RDL reports are not actual files (that I can browse to via Windows Explorer) but are saved in the SQL database somewhere.
I'm going to http://localhost and log in to Sharepoint as an admin.  

When I click on a report in the browser, each report has an "actions" menu in the upper left corner.  
The options in this actions - menu are: "open with report builder" (which doesn't work since SSRS is running within sharepoint), "subscribe" and "export" (which exports the report data, not the rdl).

How can I edit the rdl report? 



How to edit an RDL report in Sharepoint and SSRS 2005?

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.