SSRS how to access the report

RCDA Webmaster 291 Reputation points
2022-12-12T17:51:58.13+00:00

A colleague of mine built some reports using SSRS. I need to update the report and have downloaded Report builder 3.0. I am able to access the report via the URL: http://server/ReportServer/Pages/ReportViewer.aspx?%2fNotitiaeReport%2fParishNotitiae&rs:Command=Render&ParNumber=193&rs:format=pdf

what I do not know how to do is access the report in the report builder. I have tried:

\server\reportserver
\server\reports

Neither of these locations exist. How do I get to the report pieces that need to be updated? Is there a place on the server where I can find the report files or are they stored in the database and only accessible via the URL?

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.
3,063 questions
{count} vote

Accepted answer
  1. Anonymous
    2022-12-13T01:49:55.797+00:00

    Hi @RCDA Webmaster
    Do you have permission to connect to http://server/reportserver?
    When you open the report builder, connect to the report server URL, and then click File -> Open. In the Recent Sites and Servers window, you will see the report server URL you connected to. Double-click the URL, and you can see the deployed files. Then open the file you want to modify. After the modification, click File -> Save to save your modification.
    269843-1.png
    269834-2.png
    Best regards,
    Aniya

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. RCDA Webmaster 291 Reputation points
    2022-12-16T14:07:43.127+00:00

    The answer definately helped. I use report builder once a year to update 1 report. I didn't remember that I had to connect via http. I was trying \server\reportserver. Another question: How do I update the default server that the program tries to connect to? It's trying to connect to an old server that I no longer use when I click open.

    0 comments No 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.