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
705 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

by:Niru2k
Comment Utility
I did the same thing but I could not find it
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.

 
LVL 17

Expert Comment

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

Accepted Solution

by:
pssandhu earned 50 total points
Comment Utility
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
Comment Utility
Thanks PSSandhu
0
 
LVL 17

Expert Comment

by:pssandhu
Comment Utility
No Problem.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In this article I will describe the Copy Database Wizard 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.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

762 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

6 Experts available now in Live!

Get 1:1 Help Now