Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
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
Medium Priority
?
822 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

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 200 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
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…
Integration Management Part 2

578 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