Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anuraag205
Yak Posting Veteran
58 Posts |
 Posted - 2012-09-06 : 06:18:00
|
| Dear All, Below is my pattern of finding a solution for this please guide.I am working on Report Builder 3.0, and i have a doubt. Please Help.I am successful in generating a report using report builder 3.0, But exporting to Word or Excel formats only. I have one data source and 5 - 6 data sets. Is there any possibility that to open my report (created in report builder 3.0) in web application? I need to have web site application, where people from anywhere can just log-in and give particular data (select a date range ) and get the required data.Is any such thing possible, if yes please guide me with required materiel. I hope some integration would help me . but don t know how to proceed.Please help...Thanks ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::Solution(Please Guide):1)POST THE DATA TO A REPORT SERVER2)CONVERT THE DATA INTO XML files3)mention the filers what you wanted to the developer.So the developer creates a web page with the help of my XML Files and connect it to sql data base server(reporting server). When we o to the link, Give the condition for filter (dates) and you get the data populated.Thanks |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-07 : 07:09:03
|
Anuraag, I am responding not because I have anything new to offer or suggest above and beyond what I had described in a previous post, but only because I don't see anyone else responding to it. As I see it, you have couple of options. 1. The simplest is to publish the report to a report server site and give your users access to that site. SSRS allows fine-grained control over who can access the web page. If required, you can add additional permissions in the database as well (by passing in the userid to your stored procedures).Setting this up is very simple - should take only a few minutes if you know the steps. There are tutorials on MSDN site.It is also the least flexible, because the SSRS reports have a pre-determined way of presenting the parameters and the layout; there are not many customizations you can do.2. Embed the report in an ASP.Net page (or in anything else that can host it - WinForms for example). The tutorials and links that I had posted in a previous posting show those. For example, this Channel9 tutorial: http://channel9.msdn.com/Learn/Courses/SQL2008R2TrainingKit/SQL10R2UPD01/SQL10R2UPD01_HOL_04/Exercise-1-Embedding-Reporting-into-an-ASPNET-Application If you work through the tutorial you will see that it is relatively easy to implement that.Does either of the above help? If not, I will shut up and say no more  |
 |
|
|
anuraag205
Yak Posting Veteran
58 Posts |
Posted - 2012-09-07 : 07:29:50
|
No...its my turn, To shut up and follow your solution...Will update once that's done...quote:
Originally posted by sunitabeck
Anuraag, I am responding not because I have anything new to offer or suggest above and beyond what I had described in a previous post, but only because I don't see anyone else responding to it. As I see it, you have couple of options. 1. The simplest is to publish the report to a report server site and give your users access to that site. SSRS allows fine-grained control over who can access the web page. If required, you can add additional permissions in the database as well (by passing in the userid to your stored procedures).Setting this up is very simple - should take only a few minutes if you know the steps. There are tutorials on MSDN site.It is also the least flexible, because the SSRS reports have a pre-determined way of presenting the parameters and the layout; there are not many customizations you can do.2. Embed the report in an ASP.Net page (or in anything else that can host it - WinForms for example). The tutorials and links that I had posted in a previous posting show those. For example, this Channel9 tutorial: http://channel9.msdn.com/Learn/Courses/SQL2008R2TrainingKit/SQL10R2UPD01/SQL10R2UPD01_HOL_04/Exercise-1-Embedding-Reporting-into-an-ASPNET-Application If you work through the tutorial you will see that it is relatively easy to implement that.Does either of the above help? If not, I will shut up and say no more
 Thanks |
|
|
|
|
|
|
|
|
MS Report Builder 3.0 Integration to Web Applicat