Share via

SSRS Editing reports in 2008 R2

RCDA Webmaster 281 Reputation points
2021-02-02T21:12:21.083+00:00

my company is running an SQL server database and report server that is 2008 R2. I need to make some changes to one of the reports.

I've done some tutorials on lynda.com and have learned the 2019 version of report server and report builder.

What do I need to do to be able to edit reports on a 2008 R2 server?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,951 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 38,621 Reputation points
    2021-02-03T02:43:24.507+00:00

    Hi @RCDA Webmaster ,

    You may download the report from the report server and then edit with report builder,

    For compatibility, I'd suggest that you may use the Report Builder2.0.

    Details for your reference:report-builder-tutorials

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 45,366 Reputation points
    2021-02-03T07:23:04.747+00:00

    The current SSDT = "SQL Server Data Tool" version still support SSRS 2008 + 2008R2, see

    Download SQL Server Data Tools (SSDT) for Visual Studio

    0 comments
  2. RCDA Webmaster 281 Reputation points
    2021-02-03T13:52:00.193+00:00

    I decided to download the sub reports that I need to edit. What I can't figure out is how to do that. When I open the folder with the sub reports, my options are to click on the report to open it or right click on it and save link as. Save link as, saves the page not the report. when I hover over, I get a down arrow next to the report. I tried clicking the arrow next to each report and nothing happens. Maybe I need some permission on the server?

    With SQL server 2019, I could click on the ellipse and and open in Report Builder. How do I go about that?

    63545-subreports.jpg

    0 comments
  3. RCDA Webmaster 281 Reputation points
    2021-02-03T14:16:04.193+00:00

    Doing some research let me to the realization that expected functionality only works if I use Internet Explorer.

    0 comments
  4. Olaf Helper 45,366 Reputation points
    2021-02-03T14:26:10.637+00:00

    I decided to download the sub reports that I need to edit. What I can't figure out is how to do that

    In SSRS 2008R2 it works different. Open a report, then click on top left in the bread crumb on the report name; you get to the report properties.
    In the icon bar is a download button.

    Easier way: Use my PowerShell script to export all reports, data source etc. in one batch:
    https://gist.github.com/jzabroski/346ab6bd2dd0988fe5b6e1f660023470

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.