1. I don't recommend using RB to edit the reports, instead use BIDS. 2. You should not edit the existing reports, you can make a copy of the reports and use that.
3. If you have to use RB don't forget to download and install the SQL certificate to your PC. 4. You will likely have to give them read only access to the DB too. 5. If you are going to writing RBA enable reports, there are tricks to get it going. Take a look at my blogs about it. Here are some of the blog topics on the subject. http://be.enhansoft.com/search.aspx?q=BIDS <Shameless plug> As an aside, I'm hoping to present this topic at http://mms.mnscug.org/ if you would like to see this topic at MMS tweet @MMSMinnesota and tell them it is a must have. :) </Shameless plug> Honestly I don't use the MS datasource when creating my reports. Instead I create my own DS and then change the DS to use the MS DS when I upload them. These blogs/ videos will get you started on that part. http://be.enhansoft.com/post/2010/08/26/How-to-Change-the-SSRS-Datasource.aspx https://www.youtube.com/watch?v=XWR6uzMl_8k Garth Jones Chief Architect Tel: 613-627-4801 x168 Fax: 613-627-4802 www.Enhansoft.com<http://www.enhansoft.com/> [Description: Description: cid:[email protected]]<http://www.enhansoft.com/> Enhancing Your Business [Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<http://be.enhansoft.com/>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<https://twitter.com/enhansoft>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<http://www.facebook.com/EnhansoftInc>[Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Enhansoft's YouTube Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description: Description: Description: Description: Description: Description: cid:[email protected]]<http://myitforum.com/myitforumwp/community/groups/enhansoft/> [cid:[email protected]]<http://mms.mnscug.org/> Ask Me About Our Free SSRS Reports<http://www.enhansoft.com/pages/Free-SSRS-Reports.aspx> From: [email protected] [mailto:[email protected]] On Behalf Of King, Jason Sent: Thursday, July 31, 2014 1:16 PM To: [email protected] Subject: [mssms] RBA for Reporting administrators Has anyone had any luck creating a role for users that need to be able to create and modify reports? I have a role that will allow the users to read but when I created one for people to create I cannot seem to connect to the data set. Also, the only way I have been able to give EDIT rights to reports is if I give Modify rights to the site. I don't want to do this since people who make reports don't need access to modify the site itself. Here is what my role looks like: [cid:[email protected]] [cid:[email protected]] [cid:[email protected]] With the role you see here. I can get to reports and click EDIT. When report builder launches, I choose to create a new data set. The user gets "Login Failed for User" ............................................................................................................................. Jason King | Solutions Design Team ________________________________ CONFIDENTIALITY NOTICE: This email contains information from the sender that may be CONFIDENTIAL, LEGALLY PRIVILEGED, PROPRIETARY or otherwise protected from disclosure. This email is intended for use only by the person or entity to whom it is addressed. If you are not the intended recipient, any use, disclosure, copying, distribution, printing, or any action taken in reliance on the contents of this email, is strictly prohibited. If you received this email in error, please contact the sending party by reply email, delete the email from your computer system and shred any paper copies. Note to Patients: There are a number of risks you should consider before using e-mail to communicate with us. See our Privacy & Security page on www.henryford.com<http://www.henryford.com> for more detailed information as well as information concerning MyChart, our new patient portal. If you do not believe that our policy gives you the privacy and security protection you need, do not send e-mail or Internet communications to us.
