.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

call SSRS report in asp.net application

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
hi all I am using following code to call a report in a ap.net application but its output is " The request failed with HTTP status 401: Access Denied"........ kindly resolve..... ##############C O D E ################### Partial Class Report1     Inherits System.Web.UI.Page       Public Class ReportViewerCredentials1         Implements IReportServerCredentials         Private _userName As String         Private _password As String         Private _server As String         Public Sub New(ByVal userName As String, ByVal password As String, ByVal server As String)             _userName = userName             _password = password             _server = Server         End Sub         Public ReadOnly Property ImpersonationUser() As System.Security.Principal.WindowsIdentity Implements Microsoft.Reporting.WebForms.IReportServerCredentials.ImpersonationUser             Get   &n

View Complete Post

More Related Resource Links

SSRS Report Builder "Application cannot be started, contact application vendor"

Hi   In Report Manager, when i click on report builder its show me an error like "Application cannot be started, contact application vendor " I installed .net framework 2.0, I'm using windows 7,Sql server 2005 Can any one please help on this...   Thanks Sharon

Multithreading application to launch SSRS report muliple times

Hello, First of all, I am not a .net programmer but fortunately/unfortunately I have to create a scenario where I have to make multiple calls to SSRS report server. Is there a way to create a multithread web application whose threads will call the reports from the report server? I know how to execute a report from .net web application but I don't know how to do it when I have to launch many instances of the same report simultaneously. I believe that by creating multiple threads, I can make each thread to execute same report on report server. Moreover, I should be able to change the no. of threads (no. of threads should be the parameter) at the start of each execution. Since I am primarily a SQL developer and have no practical experience of implementing threading in .net, can anyone please help me out here? Regards.

How do I call an SSRS Report from a stored procedure, and pass parameters?


Hi all,

I have a Report, that I want to run ad-hoc from a Stored Procedure. 

I want to render this report to PDF format, and save it to a drive.

The difference between this post and most threads I've seen is I don't want to run a stored proc within the report and send parameters to the stored proc.

I DO want to call a report FROM the stored proc, and send parameters TO the report.

How can I do this?

Many thanks,


how to call multi-value parameters in SSRS from asp.net application?


hi all

i am trying to call an SSRS report (in VS 2005) from my asp.net (web application) implemented in VS 2008 (don't ask me why, i am kind of confused by this weird arrangement too). report has been deployed to report server and it contains a multi-value parameter.

when i call report from asp.net app, i set the value for this multi-value parameter as a string and all selected values are separated by comma. i.e. i have 5 options (a, b, c, d, e), and i selected first two, the string is then "a,b".

the multi-value parameter on the report side is defined as: Multi-value selected, Allow blank selected, Avaliable values are from query (a dataset that contains a, b, c, d, e) Value field and Label field are both mapped to dataset filed (there is only one field in the dataset). the default values are from query too (same dataset). value field is mapped also.

i have two problems:

1: it looks to me that all available values are selected on the report side, regardless what i really selected and passed over (when i turn on paramters).

2: when i turn off parameters, i need to display what values being selected as a string, the join statement, join(Parameters!TeamLead.Value), gives a list of all available values for the multi-value parameter, however, i only need selected values. h

Is there any Sharepoint 2010 Webservice call that I can point my SSRS Report at to retrieve an execu


I want to create an SSRS report that displays all the steps in an executing workflow along with its current stage.

SharePoint 2010 webpart shows the current state of the executing workflow but I want to display all the steps including ones that have been completed and ones that are still to come.

How can SSRS call to .net application....


 Dear sir/madam,

           I am amar patil I have try to SSRS call to used in .net application

so can you possible to the SSRS call to the .net application. any type of

solution please seng the link of url.


Thank's &Regrad's,

Amar Patil.

Mobile No:-9987721852


SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

SSRS Report viewer + Remove


I am running the report from SSRS report server in the view i am finding that the window title is Report Viewer - Windows Internet Explorer.

How to remove this name and get the name of the report over there.

I am using java at the back end to call the repot through url.

Please help me .

Thanks ,


SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft



Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.




Report printing problem(ssrs 2005)

HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

ssrs 2008 R2 - report parameter with no default set throws java script error

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

ssrs 2005 default value generates report

Hi, If all parameters have default value the report generates as soon as i load the report. Is it possible to only run the report when clicking on the view report button even if all parameters have default values? Thanks

Linked Report Subreport- Error: Subreport could not be shown on SSRS 2008r2

I've got 2 folders: /Finance /Japan In the Finance folder I have a Sales report that has 3 subreports, and a salesregion parameter. I created a linked report in /Japan to /Finance/Sales, hide the salesregion parameter, and set the default to Japan, so they can only see their region's sales data. But when a Japan user runs the Sales report, they get Error: Subreport could not be shown because they do not have access to the /Finance folder. Any ideas?

How to disable the Drop down that comes during the mouse hover over to the folder/report in SSRS 200

Hi All, Is there a way to disable the Drop down that comes (with options to Manage/Delete/Move etc.) during the mouse hover over to the folder/report in SSRS R2? Our users are getting confused and some of the smart users have tried to take certain actions that are offered in the drop down. Thanks.GBM

SSRS report exort to excel wrap text proplem

When i am exporting the ssrs report to excel the wrap text is not working properly. the cell containing large data are cutoff how to resolve this issue. since the data size is not fixed so the cell should wrap the text while exporting to excel. I am using java to call the report Thanks , Kamal.

Passing XML into a SSRS report from c#

I have a SSRS report that queries an XML file. I'm calling this report from c# and redering it as a PDF. The only way I can do this is to save the XMl into a path that is already defined in the report. My question is, can I send the XML into the report so that the report uses the parameterised report as the datsource?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend