Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Report Builder integrated in Asp.net? Expand / Collapse
Author
Message
Posted Monday, May 11, 2009 1:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, May 12, 2009 2:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:06 AM
Points: 337, Visits: 1,981
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
Posted Tuesday, May 12, 2009 3:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, May 12, 2009 3:19 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:06 AM
Points: 337, Visits: 1,981
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
Posted Tuesday, May 12, 2009 3:23 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:06 AM
Points: 337, Visits: 1,981
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
Posted Tuesday, May 12, 2009 3:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, May 12, 2009 3:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:06 AM
Points: 337, Visits: 1,981
are these going to be internal or external users?
Post #714819
Posted Tuesday, May 12, 2009 4:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:49 AM
Points: 1,391, Visits: 608
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
Posted Tuesday, May 12, 2009 4:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, May 12, 2009 4:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:06 AM
Points: 337, Visits: 1,981
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 »

Add to briefcase 12»»

Permissions Expand / Collapse