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


Report Builder integrated in Asp.net?


Report Builder integrated in Asp.net?

Author
Message
bubu-475971
bubu-475971
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 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.
Samuel Vella
Samuel Vella
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1053 Visits: 2144
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.
bubu-475971
bubu-475971
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 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.
Samuel Vella
Samuel Vella
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1053 Visits: 2144
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.
Samuel Vella
Samuel Vella
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1053 Visits: 2144
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
bubu-475971
bubu-475971
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 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 :-)
Samuel Vella
Samuel Vella
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1053 Visits: 2144
are these going to be internal or external users?
Kishore.P
Kishore.P
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1885 Visits: 619
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.



bubu-475971
bubu-475971
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 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.
Samuel Vella
Samuel Vella
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1053 Visits: 2144
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.
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