I deployed a RDL thru BIDS, then edited the same RDL using report builder, Now I can I load the updated RDL back in BIDS

I deployed a RDL thru BIDS, then edited the same RDL using report builder, Now I can I load the updated RDL back in BIDS to edit it further and make some enhancements
Niru2kAsked:
Who is Participating?
 
pssandhuConnect With a Mentor Commented:
Try opening the same report in Report Builder and see if you can save a copy of the report on your dektop. If you are able to save the report on your desktop then follow the steps above.

P.
0
 
pssandhuCommented:
Yes. Log into the reporting services via Sql Server Managment Studio (SSMS). Right click on the report and export it to your desktop. Go to your dekptop, right click on the report and select copy.

Open your BIDS project and in the solution exporere window on the right go Ctrl + V to paste the report. Douple click the report and start editing.

P.
0
 
Niru2kAuthor Commented:
Thanks pssandhu for the solution, but I could not see reports when I logged into Reporting services thru SSMS. is these some thing I am missing or any other way to do it
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
pssandhuCommented:
When you open up SSMS, a small window titled "Connect to Server" shows up. In that window under "Server Type", choose "Reporting Services". There is a drop down that will enable you to choose from a list of services (see the screen shot below). Then under "Server Name" type the sql server name or IP address that you trying to connect to.

Click okay and if you the correct permission you will be able to log in.

Hope this helps.

P.
Screeshot.bmp
0
 
Niru2kAuthor Commented:
I did the same thing but I could not find it
0
 
pssandhuCommented:
So you cannot see Reporting Services as an option in the drop down?
0
 
Niru2kAuthor Commented:
Thanks PSSandhu
0
 
pssandhuCommented:
No Problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.