Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting services Expand / Collapse
Author
Message
Posted Tuesday, November 4, 2008 9:36 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 15, 2015 12:54 PM
Points: 264, Visits: 1,514
Here is my company's requirement: We want the user's to create their own reports, so I was thinking of using SQL server 2008 report builder(part of reporting services). Is report builder present in sql 2008? If so, can I use report builder of SQL server 2008 for my purpose? Thanks in advance.
Post #597082
Posted Thursday, November 6, 2008 9:21 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 22, 2016 7:13 PM
Points: 238, Visits: 663
Report Builder is present in SQL Server 2008 and sounds like the best choice for your requirement. If you are building a custom reporting environment, there is a component you can use to place Report Builder in an ASP.Net web app. Here is a link to get started:

http://www.microsoft.com/downloads/details.aspx?FamilyID=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en
Post #598290
Posted Monday, January 23, 2012 11:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 22, 2012 4:07 AM
Points: 5, Visits: 18
You can use report builder to give facility to your company user. First you have to create report model and publish them to report server site. you can create a report model by BI through create new report model project.

your company user must have appropriate permission to report server to create report from those report model.

I hope it will help some.

Zahirul.
Post #1240623
Posted Tuesday, June 11, 2013 7:09 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 25, 2015 10:15 PM
Points: 44, Visits: 101
You may want to use Power View in SQL Server Reporting Services 2012 assuming you have SharePoint available.

If you are using SSRS 2008 then you can create a Report Model which your permitted users can use to create reports.
Post #1462436
Posted Wednesday, October 28, 2015 7:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 26, 2015 7:09 AM
Points: 1, Visits: 55
Hello,

I have basically the same requirement. I have a range of SSRS reports that are embedded in a Java written web application used by several client companies with about 5 users each.
From these 5 end users, one or two must have the possibility to edit, with Report Builder, a template report we created for them. They need to be able to edit, save and share this report among the other users from their group/company without altering the template for other groups.

I struggle to understand the roles and permissions settings I need to achieve this. Can we create domains for SSRS users? Is this requirement even possible through SSRS user management? How works the MyReports role?
Can anyone give me a link to an article, a tutorial or better still, an example of the architecture I need?
SharePoint is not used in our solution.

Thanks
Post #1731517
Posted Tuesday, November 10, 2015 8:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 28, 2016 2:00 PM
Points: 2, Visits: 279
did you check this page yet on the MSDN? https://msdn.microsoft.com/en-US/library/bb522824.aspx
Post #1735415
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse