SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reporting services


Reporting services

Author
Message
Mh-397891
Mh-397891
Mr or Mrs. 500
Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)

Group: General Forum Members
Points: 560 Visits: 1514
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.
david.tyler
david.tyler
Old Hand
Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)

Group: General Forum Members
Points: 338 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
sohelnax005
sohelnax005
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 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.
mysorian
mysorian
SSC Journeyman
SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)

Group: General Forum Members
Points: 84 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.
Lampahuil
Lampahuil
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 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
lanex.z
lanex.z
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 286
did you check this page yet on the MSDN? https://msdn.microsoft.com/en-US/library/bb522824.aspx
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search