Monday, March 12, 2012

Reporting Services in Web Application

Hello,
Is it possible to have Reporting Services inside a web application? Or am I restricted only to have a seperate web application for Reports?
regardsReporting Services has its own Report Manager - a web app already built by the MS. Once you build the reports you upload the reports to that Report Manager. Then you can call any of those reports ( an rdl file) from your web app. check out the Rendering methods. There's a render by url method that could be of help to you. You can also use the RS webservice to get all the information programmatically.|||Thanks a lot. What I meant is that, the same as adding usercontrol,asmx, aspx files to a web application, can't I add that rdl file to thesame application?
regards
|||you can create a hyperlink pointing to the url of the report and include the parameters in the url. the report will however open in a new browser. you can have an IE plugin in your form and use that to show the report.|||I have been trying to launch my rdl file from within my web application like when you launch a aspx page. I created a folder in my wwwroot called reports which contains my rdl file. I created a hyperlink on a page I called reports. I set the url navig. to wwwroot/reports/...rdl file name. When I click on the hyper link I get a login on my screen first am I doing this right ? second why would I be getting a MS login on my webpage. How can I resolve this issue. Thanks|||

haidar_bilal:

Thanks a lot. What I meant is that, the same as adding usercontrol, asmx, aspx files to a web application, can't I add that rdl file to the same application?

regards

Do you mean that when you are developing you want to keep reports in the same solution as a web application?

If that's your question, then yes, you can do this. Open your web app, navigate to File -> Add Project -> New Project. Select the Business Intelligence Projects, name the project and finish the wizard. When you have finished the wizard, the project you just created will be under the open solution and you can now add existing rdl files or create new reports.

An alternate way of doing this is to open the web app, open the solution explorer, right click the solution node and navigate to Add -> New Project. Complete the wizard as in the above example and once you've finished, you've got your report project.

Hope this helps.

Mark

|||

Mark,

Nope thats is not what I mean. What I am having a problem with I cant get the reports to run on my webserver. They work ok from within the designer when I run a preview but when I deply the reports they will not run. I can even get thehttp://localhost/reportserver to open. I have configured it just like another machine that works but this one will not. zI need help getting this to work and I dont know where to start. I have look at every config I can think of but still can not get my reports to work. It shouldnt be the hard to produce a report. I have created crystal reports which save as aspx file I am able to connect to the aspx report page from my menu by using the url navigate or url postback. can you load the rdl file the same way should it work if not what do I need to do.

|||

cpowers:

Mark,

Nope thats is not what I mean. What I am having a problem with I cant get the reports to run on my webserver. They work ok from within the designer when I run a preview but when I deply the reports they will not run. I can even get thehttp://localhost/reportserver to open. I have configured it just like another machine that works but this one will not. zI need help getting this to work and I dont know where to start. I have look at every config I can think of but still can not get my reports to work. It shouldnt be the hard to produce a report. I have created crystal reports which save as aspx file I am able to connect to the aspx report page from my menu by using the url navigate or url postback. can you load the rdl file the same way should it work if not what do I need to do.

I was replying to the original poster's second post in this thread.

My first question to you would be why are you deploying to the localhost? My second question is have you looked at the Data Sources property for your reports. I've had a few of my reports lose the Data Source information on deployment and I had to go back and reset that information.

|||

I am sorry I have tried to deploy to bothhttp://<servername>/reportserver and to http://localhost/reportserver . The issue for me is I cant get the report manager up and running on this machine. I checked the Datasource and it look fine. the error I keep getting is

A connection could not be made to the report serverhttp://localhost/reportserver orhttp://<servername>//reportserver I know something is not configure right but have no clue to what it may be.

my datasource looks like this:

<DataSource>

< DataSource Name="ReportsServer1">

<rd:DataSourceID>6c3746297-8374-94837-a88e-83746473gd8</rd:DatasourceID>

<ConnectionProperties>

<DataProvider>SQL</DataProvider>

<ConnectionString>Data Source=Jombo;Initial Catalog =ReportsServer1</ConnectionString>

<IntergratedSercurity>true</IntergratedSecurity>

|||

cpowers,

Are you not able to navigate tohttp://localhost/reportserver in your internet brower? If so then you might want to check your IIS settings. Try restarting it and see if that works.

Also check to make sure your Reporting Service is up and running in Control Panel > Administrative Tools > Services.

|||

cpowers, do you get that error when trying to deploy or trying to run? Either way, that error leads me to believe it's a security issue.

|||

Yep I can not navigate to thehttp://localhost/reportsserver from my browser. I have check the IIS and checked the report Service is running. Here is the funniy thing If I open my vs.net reportproject1 and open a rdl file in the designer I can click on the previewer and it loads thehttp://localhost/rdl file ok but I can not run thehttp://localhost/reports orhttp://localhost/reportserver from the browser. Why?

|||

I think the same think but I have configured the sql security the same way as on my other machine. I just want to be able to run the report manager to test the reports.....I am very frustrated. I am not an expert with sql but have configured this serveral times and it always have worked for me

|||

i am unable to navigate tohttp://localhost/reportserver , can u guys plz help me. Thanks in advance

|||

have your Reporting Services problem been solved ?

No comments:

Post a Comment