Reporting services

Question

Reporting services

Mh-397891

SSCertifiable

Points: 6704
More actions
November 4, 2008 at 9:36 pm

#383304

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.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

david.tyler SSCrazy Points: 2206 More actions · Answer 1

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

sohelnax005 SSC Enthusiast Points: 113 More actions · Answer 2

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.

mysorian Ten Centuries Points: 1048 More actions · Answer 3

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.

Lampahuil Valued Member Points: 53 More actions · Answer 4

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

lanex.z SSC Enthusiast Points: 102 More actions · Answer 5

did you check this page yet on the MSDN? https://msdn.microsoft.com/en-US/library/bb522824.aspx