September 6, 2012 at 3:54 am
Dear All,
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
September 6, 2012 at 4:18 am
I have an idea of this type of solution.. please guide.
Solution(Please Guide):
1)POST THE DATA TO A REPORT SERVER
2)CONVERT THE DATA INTO XML files
3)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
September 7, 2012 at 5:41 am
Hi i got this reply from other sources:
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Posted - 09/07/2012 : 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.
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply