Solved

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

Posted on 2011-02-28
8
733 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:Niru2k
  • 5
  • 3
8 Comments
 
LVL 17

Expert Comment

by:pssandhu
ID: 35000130
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
 

Author Comment

by:Niru2k
ID: 35000392
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
 
LVL 17

Expert Comment

by:pssandhu
ID: 35000459
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Niru2k
ID: 35000734
I did the same thing but I could not find it
0
 
LVL 17

Expert Comment

by:pssandhu
ID: 35000757
So you cannot see Reporting Services as an option in the drop down?
0
 
LVL 17

Accepted Solution

by:
pssandhu earned 50 total points
ID: 35000831
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
 

Author Closing Comment

by:Niru2k
ID: 35001606
Thanks PSSandhu
0
 
LVL 17

Expert Comment

by:pssandhu
ID: 35001689
No Problem.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now