Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 sql server 2008 report builder 2.0

Author  Topic 

jassie
Constraint Violating Yak Guru

332 Posts

Posted - 2010-05-02 : 18:31:31
My company used just purchased sql server 2008 and I installed several new reports via sql server report service 2008.
Now I am ready to setup report builder 2.0 for expereinced users that are not in the Information Technology group.

Can you tell me and/or refer some urls that I can use to setup report builder 2.0 for these users?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-03 : 01:40:38
see

http://www.mssqltips.com/tip.asp?tip=1690

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

andrewhopkinson
Yak Posting Veteran

63 Posts

Posted - 2010-05-08 : 12:19:23
I am in the process of doing the same thing. I think the first thing you should do is to make sure your report server security is properly configured. Make sure that the users you are giving access to the server have proper priviledges for the tasks they are performing, this is especially important if they are inexperienced with SQL. A good idea is to only give RB people readonly access to views and stored procedures. You should probably setup a shared datasource on the report server that they can access instead of creating their own. Accessing a shared datasource is not entirely obvious in RB 2.0, you have to go to "options" in the bottom part of the screen and enter the URL of your report server.
Go to Top of Page
   

- Advertisement -