Solved

SSRS 2008

Posted on 2014-04-14
1
149 Views
Last Modified: 2014-05-22
hi

when i create a report in SSRS manager , i have to assign one connection manager to all the reports one by one .
1. is there a way by which i can do that from one place , without going to each report and assign it.
0
Comment
Question by:BeyondBGCM
1 Comment
 
LVL 42

Accepted Solution

by:
EugeneZ earned 200 total points
Comment Utility
there is no documented regular SSRS GUI bulk reports connections change: you would need to do it on by one.
However, you may  use rs.exe (SSRS utility)  RS.SetItemDataSources method
http://msdn.microsoft.com/en-us/library/ms162839(v=sql.100).aspx

more
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/01a23528-550a-4e38-a222-f5529650d31a/bug-in-ssrs-setitemdatasources-web-service-method?forum=sqlreportingservices
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

743 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

8 Experts available now in Live!

Get 1:1 Help Now