<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server Newbies
»
Report Builder integrated in Asp.net?
13 posts, Page 1 of 2
1
2
»»
Report Builder integrated in Asp.net?
Rate Topic
Display Mode
Topic Options
Author
Message
bubu-475971
bubu-475971
Posted Monday, May 11, 2009 1:30 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, June 22, 2009 2:15 AM
Points: 6,
Visits: 17
Hello,
I'm new into studying the SqlServer 2008 Reporting Services and I've been reading about this service and the Report Builder application, so I kind of have the basic idea of the service. My problem is that I need a Report Designer integrated into my asp.net application, so that the user could create his own reports from inside my web application. I'm using Visual Studio 2008, C# and of course Reporting Services 2008. I haven't found any clues about how this can be done or if it can be done. So if anyone knows how I could provide a report builder or something like that to my end user client from the aspx page, I would really appreciate the help
.
Thank you.
Post #713892
Samuel Vella
Samuel Vella
Posted Tuesday, May 12, 2009 2:40 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 2:22 AM
Points: 328,
Visits: 1,852
It can't be done... Report Builder is not a web application - it is a locally ran application that temporarily installs/executes on the users PC over the network
What you can do is provide a link to the report builder for the user to click, this will then enable the user to use the report builder. Any reports that they then save to the report server will appear in the Report Services as normal.
Post #714783
bubu-475971
bubu-475971
Posted Tuesday, May 12, 2009 3:09 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, June 22, 2009 2:15 AM
Points: 6,
Visits: 17
Thanks for the reply, I thought about that myself but then I was thinking about the rights the user will have on the server? How will he connect to the server to publish the reports.. will he connect through the Asp.Net user or how? considering that the application that launches the Report Builder is my web application. Thank you again.
Post #714795
Samuel Vella
Samuel Vella
Posted Tuesday, May 12, 2009 3:19 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 2:22 AM
Points: 328,
Visits: 1,852
bubu (5/12/2009)
Thanks for the reply, I thought about that myself but then I was thinking about the rights the user will have on the server? How will he connect to the server to publish the reports.. will he connect through the Asp.Net user or how? considering that the application that launches the Report Builder is my web application. Thank you again.
I assume you're building a custom front end for reporting services
I don't know what authentication model you're using for the ASP .NET application, I've done something similar in the past and used integrated windows authentication.
It works pretty smoothly, if the user does encounter anything which they don't have access to then they are prompted for a username and password - although if they can see something that they haven't got permission to then your application should handle it more elegantly than that!
To answer your question, if the user is authenticated on the domain then the authentication will be passed onto the report builder when they open that. Just as if they were using the http://[servername]/reports web page to view reports.
If you are using a different authentication model then you will encounter problems.
Post #714797
Samuel Vella
Samuel Vella
Posted Tuesday, May 12, 2009 3:23 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 2:22 AM
Points: 328,
Visits: 1,852
Try and get hold of this book... for £30 its possibly one of the best value books you can buy
SQL Server 2005 Reporting Services in Action
It is 2005 specific but most of it should work for 2008
Post #714799
bubu-475971
bubu-475971
Posted Tuesday, May 12, 2009 3:44 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, June 22, 2009 2:15 AM
Points: 6,
Visits: 17
Well the authentication will be done using an user name and a password for every user, different levels of authentication and of rights. That's why I'm a little confused, because I can't just grant access on the report server to every user that will access my web site and using a windows integrated authentication is not an option. Anyway I'll look for the book you recommended and see what I can do. Thank you for your help
Post #714813
Samuel Vella
Samuel Vella
Posted Tuesday, May 12, 2009 3:56 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 2:22 AM
Points: 328,
Visits: 1,852
are these going to be internal or external users?
Post #714819
Kishore.P
Kishore.P
Posted Tuesday, May 12, 2009 4:05 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, November 26, 2012 3:25 AM
Points: 1,389,
Visits: 596
bubu (5/12/2009)
Well the authentication will be done using an user name and a password for every user, different levels of authentication and of rights. That's why I'm a little confused, because I can't just grant access on the report server to every user that will access my web site and using a windows integrated authentication is not an option. Anyway I'll look for the book you recommended and see what I can do. Thank you for your help
SQL 2008 BOL, provides good authentication available, please have a look into the SQL BOL.
Post #714825
bubu-475971
bubu-475971
Posted Tuesday, May 12, 2009 4:10 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, June 22, 2009 2:15 AM
Points: 6,
Visits: 17
Samuel Vella (5/12/2009)
are these going to be internal or external users?
External users... is not an intranet application.
I will take a look at SQL BOL too thank you.
Post #714829
Samuel Vella
Samuel Vella
Posted Tuesday, May 12, 2009 4:17 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 2:22 AM
Points: 328,
Visits: 1,852
bubu (5/12/2009)
External users... is not an intranet application.
Ouch! Rather you than me
Are you sure that report builder is the best solution?... if you want users to be able to "customise" their reports then there are ways of showing/hiding columns, changing filters and determining if certain objects, tables/matricies/graphs etc should be displayed or not at run time.
It just means being clever with your report authoring rather than passing that responsiblity on to the user.
Post #714838
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
