Showing posts with label reporitng. Show all posts
Showing posts with label reporitng. Show all posts

Saturday, February 25, 2012

Reporitng Services Web Service and Credentials

I have developed an asp.net, vb.net web app and have integrated reporting services. Right now I am using url access but am not to crazy about showing the parameters in the querystring. I am using a dynamic stored procedure to get client data. I would like to use the rs web service to programatically set the parameters and send them invisably to the web service. Since the web app is not using windows authentication I would like to pass the parameters using a hard coded account that has been set up with browse privilages in the report manager. Is it possible to hard code the credentials that are sent to the reporting service instead of the System.Net.CredentialsCache.DefaultCredentials? The report returns a bar graph which I am hoping to display on the page. Reading some posts about some problems returning images I might be posting some more questions.

Are there any good walkthroughs or code examples using reporting services web service other than MSDN's limited supply?

Thank you for your time!
--
- preisifigured out the first part

rs.Credentials = New System.Net.NetworkCredential("username", "password", "domain")

Now when i try and render my graph the image can't be found.|||this is not an answer to your question but infact a question to you. can you share with us about how far you have gotten in getting this RS thing to work. i mean i have created some reports which accept a couple of parameters. now i need to create a windows service that calls the reportservice everyday, and prints the report. which is a little similar to what you have done. xcept for the windows service part. so could you share some of your xperience ?

thanks.
dinakar

REporitng Services for 2005 Express Advanced

Good day,

I have recently downloaded the SQL Server 2005 Express Advanced. According to the site Reporting Services is included with this and when installing one can see Reporting Services installing so all seems fine.

Well, after many days of pulling my hair out I am stuck. All I am trying to do at the moment is view the http://localhost/reports page and I can't. I keep getting an error saying the following:

Server Error in '/Reports' Application.


Failed to map the path '/Reports/App_GlobalResources/'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Failed to map the path '/Reports/App_GlobalResources/'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:

[InvalidOperationException: Failed to map the path '/Reports/App_GlobalResources/'.]

System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull) +3521404

System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate2(StandardDiskBuildResultCache diskCache) +306

System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate(StandardDiskBuildResultCache diskCache) +46

System.Web.Compilation.BuildManager.RegularAppRuntimeModeInitialize() +418

System.Web.Compilation.BuildManager.Initialize() +235

System.Web.Compilation.BuildManager.InitializeBuildManager() +228

System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +310

[HttpException (0x80004005): Failed to map the path '/Reports/App_GlobalResources/'.]

System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426887

System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88

System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Please is there anyone that can help me. I can;t see what is causing this. I have read I need to give the local ASPNet account write access to a whole bunch of folders which I have done but no change. I ran the config tool that installs to set up new Report Manager and Server Virtual Directories and nothing seems to work.

Please someone help me.

I would love to test and try and develop using this, but if I can't even get the Report Manager Server part working I am a long way from development.

Thanks in advance.

Can you use regmon and filemon to see if there are any access denied error for you ASPNET account?|||

Hi James,

Thanks for your help. Yup, I have regmon and filemon and no access denied errors are coming up at all. Sorry I should have mentioned that.

Any other ideas?

Thanks again

|||

Hi - Did you solve this issue? I am still going through this. I have tried installing Reporting services at least 4-5 times now, still having the same issue.

I have IIS 5 installed - but am able to run ASP web sites using 2.0 Framework.

Thanks for your time.

|||

I did but I cannot remember what I did. I had all the good intentions of posting my results here but then got caught up in the next project.

One thing I did note is that I upgraded IE to Ver. 6, but more than that I cannot remember.

I am sorry

REporitng Services for 2005 Express Advanced

Good day,

I have recently downloaded the SQL Server 2005 Express Advanced. According to the site Reporting Services is included with this and when installing one can see Reporting Services installing so all seems fine.

Well, after many days of pulling my hair out I am stuck. All I am trying to do at the moment is view the http://localhost/reports page and I can't. I keep getting an error saying the following:

Server Error in '/Reports' Application.

Failed to map the path '/Reports/App_GlobalResources/'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Failed to map the path '/Reports/App_GlobalResources/'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:

[InvalidOperationException: Failed to map the path '/Reports/App_GlobalResources/'.] System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull) +3521404 System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate2(StandardDiskBuildResultCache diskCache) +306 System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate(StandardDiskBuildResultCache diskCache) +46 System.Web.Compilation.BuildManager.RegularAppRuntimeModeInitialize() +418 System.Web.Compilation.BuildManager.Initialize() +235 System.Web.Compilation.BuildManager.InitializeBuildManager() +228 System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +310 [HttpException (0x80004005): Failed to map the path '/Reports/App_GlobalResources/'.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426887 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Please is there anyone that can help me. I can;t see what is causing this. I have read I need to give the local ASPNet account write access to a whole bunch of folders which I have done but no change. I ran the config tool that installs to set up new Report Manager and Server Virtual Directories and nothing seems to work.

Please someone help me.

I would love to test and try and develop using this, but if I can't even get the Report Manager Server part working I am a long way from development.

Thanks in advance.

Can you use regmon and filemon to see if there are any access denied error for you ASPNET account?|||

Hi James,

Thanks for your help. Yup, I have regmon and filemon and no access denied errors are coming up at all. Sorry I should have mentioned that.

Any other ideas?

Thanks again

|||

Hi - Did you solve this issue? I am still going through this. I have tried installing Reporting services at least 4-5 times now, still having the same issue.

I have IIS 5 installed - but am able to run ASP web sites using 2.0 Framework.

Thanks for your time.

|||

I did but I cannot remember what I did. I had all the good intentions of posting my results here but then got caught up in the next project.

One thing I did note is that I upgraded IE to Ver. 6, but more than that I cannot remember.

I am sorry

REporitng Services for 2005 Express Advanced

Good day,

I have recently downloaded the SQL Server 2005 Express Advanced. According to the site Reporting Services is included with this and when installing one can see Reporting Services installing so all seems fine.

Well, after many days of pulling my hair out I am stuck. All I am trying to do at the moment is view the http://localhost/reports page and I can't. I keep getting an error saying the following:

Server Error in '/Reports' Application.


Failed to map the path '/Reports/App_GlobalResources/'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Failed to map the path '/Reports/App_GlobalResources/'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:

[InvalidOperationException: Failed to map the path '/Reports/App_GlobalResources/'.]

System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull) +3521404

System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate2(StandardDiskBuildResultCache diskCache) +306

System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate(StandardDiskBuildResultCache diskCache) +46

System.Web.Compilation.BuildManager.RegularAppRuntimeModeInitialize() +418

System.Web.Compilation.BuildManager.Initialize() +235

System.Web.Compilation.BuildManager.InitializeBuildManager() +228

System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +310

[HttpException (0x80004005): Failed to map the path '/Reports/App_GlobalResources/'.]

System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426887

System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88

System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Please is there anyone that can help me. I can;t see what is causing this. I have read I need to give the local ASPNet account write access to a whole bunch of folders which I have done but no change. I ran the config tool that installs to set up new Report Manager and Server Virtual Directories and nothing seems to work.

Please someone help me.

I would love to test and try and develop using this, but if I can't even get the Report Manager Server part working I am a long way from development.

Thanks in advance.

Can you use regmon and filemon to see if there are any access denied error for you ASPNET account?|||

Hi James,

Thanks for your help. Yup, I have regmon and filemon and no access denied errors are coming up at all. Sorry I should have mentioned that.

Any other ideas?

Thanks again

|||

Hi - Did you solve this issue? I am still going through this. I have tried installing Reporting services at least 4-5 times now, still having the same issue.

I have IIS 5 installed - but am able to run ASP web sites using 2.0 Framework.

Thanks for your time.

|||

I did but I cannot remember what I did. I had all the good intentions of posting my results here but then got caught up in the next project.

One thing I did note is that I upgraded IE to Ver. 6, but more than that I cannot remember.

I am sorry