.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

Problem deploying custom report item. Items shows in preview screen in VS, but not in server deploye

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server

I have developed a custom report item that works fine in design and preview mode while in Visual Studio. I cannot get it to show up on my deployed reports. Here's what I have done so far:

1. Deployed the report using Visual Studio

2. updated the rsreportserver.config file with the following entry:

      <ReportItem Name="PedigreeChart" Type="Uabr.Rap.PedigreeChart.PedigreeChartRenderer, Uabr.Rap.PedigreeChart" />

3. Updated the rssrvpolicy.config file with the following entry.

                    Description="This code group grants Uabr.Rap.PedigreeChart.dll FUllTrust permission. ">
                                Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\Uabr.Rap.PedigreeChart.dll" />

I've also tried using the StrongNameMembershipCondition

View Complete Post

More Related Resource Links

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

A connection could not be made to the report server - Problem deploying an SSRS report from Business

I’m having trouble with what seems to be a common issue for people, regarding deployment of an SSRS report from Business Intelligence Development Studio. Unfortunately none of the solution I have seen posted here (and elsewhere) have been able to help me so far.   Two of my collegaues can both deploy with no problem, and I am using exactly the same Target destinations as them (TargetDataSourceFolder, TargetReportFolder, TargetServerURL).   I have posted the error message below, which from my basic understaning would indicate, I think, a security issue (perhaps something local to my PC, or user account)   Has anyone experienced this particular issue who might be able to help?   Best wishes, Jamie TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://turpin-net.turpin-bg.local/Reportserver. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <HTML dir="ltr"> <HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; c

Deploying custom Web Parts on SharePoint 2007 production server

I would like to develop a custom SharePoint 2007 Web Part for a client. Currently I'm using Visual Studio to deploy my solution to a test environment (since it's a SharePoint Project I choose just Build -> Deploy from the menu). What are the appropriate steps to deploy it to the production server?

I'd like keep it simple and safe (i.e. use the principle of least privilege). Therefore (if possible) avoid using stsadm, achieve this through web interface, or avoid using administrative rights.

Also, can I specify the scope of my Web Part, i.e. choose on which Web Application or Site Collection will it be installed?

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

Problem with Report parameter inside SSRS Report Viewer webpart with deployment from one server to a

Hi all,I've got this problem.me and my team have developed a lot of reports by using a SSRS configured in Sharepoint Integration Mode.For accessing these report we are using the Sql Server 2008 Report Viewer Webpart.One of its parameter is the Report ur that is an absolute url so the problem is when I move our solution from server1 to server2 I have to re-editing all pages where I've added the Report Viewer webpart for updating the report url with the new servername otherwise it's impossible to view the report.Is there any official or unofficial way to solve this problem ?many thanks

Data Driven Subscription problem - sub runs slowly, has 40 errors out of 300, but report server trac

I have two report servers and a single separate SQL Server 2008 server hosting the data source database and the report server catalogues. There is a data driven subscription that runs off a sproc that returns 300 rows with email addresses for this report to be emailed to. The report itself contains around 30 subreports each with its own sproc to retrieve data. As the report is executing there are long pauses between the times when emails are actually sent out, and the subscription status will finally end with something like "Done: 300 processed of 300 total; 40 errors." I am not sure how to go about troubleshooting this problem. Details: I kicked it off at (say) 2:00 PM. Within 3 minutes in the report server execution log I saw 300 entries. There were exactly 300 people who should receive reports, so the master report should have executed 300 times and sent out 300 emails. So this looked good in the execution log. But when I checked report manager's status page for the subscription it was listed as processing 50 out of 300... Then all activity stopped, about 15 minutes some more reports started emailing out, and now I see there are around 590 rows in the execution log and maybe 97 emails sent out... Then finally I get a grand total of 846 rows in the execution log and a grand total of 260 of 300 emails sent out with 40 errors so 260+40=300 exactly. The time betw

Deploying report from Visual studio 2008 to report server

Hi, When I try to deploy report from visual studio 2008 into report server in dev. enviroment, I am getting error messag saying ...specified data source is not found and permission granted to user is insufficient. But I am a content manager in specified report. Please any help ful suggestions!

Deploying TFS2010 work item custom controls in Sharepoint portal

HI I have created work item custom controls for Web Access. I have placed the Dlls in Team Foundation Server 2010 -> Application Tier -> WebAccess -> Web -> WorkItemTracking -> Custom Controls. now, i am able to view the custom controls if i access through Team Web Access 2010. But i am unable to view the custom control when i acces through sharepoint 2007 portal. I have copied the dll and wicc file to following location C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\Tswa\CustomControls but i got the following error system.IO.FileLoadException: Could not load file or assembly. Please share me if the deployment procedure of custom controls in Sharepoint are different. Regards, Sekhar

problem deploying report model to wss3 site

hi, im having trouble deploying my report model. when i click on deploy i have to enter a user name and password (i asume that it is the username and password i use to enter my wss 3 site) after that it begin to deploy then i get these 2 errors: Error 1 The required field UserName is missing from the input structure. c:\documents and settings\administrator\my documents\visual studio 2005\projects\essreportproject\essreportproject\ESSP.ds 0 0  Error 2 The path of the item '/Data Sources/ESSP' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. c:\documents and settings\administrator\my documents\visual studio 2005\projects\essreportproject\essreportproject\ESSP.smdl 0 0  when i go to my page in wss3 i can see the datasource and model directory, but i cant use them can someone help me with this and explain it for me.  

Reference Custom Assembly on Report Server

I have built the Custom Assembly and asked System Admin to deploy it on Report Server in the ReportServer/bin folder. Now System Admin has deployed this Cusomt Assembloy on Rpeort Server and sent me an URL http://mycompany/. But I am not sure how to reference this Custom Assembly using a URL in Reporting Services 2008. Please help!!!    

Problems deploying Report in Local Server (localhost)


OK, I'm kind of new to SQL Server 2008 and I'm having issues trying to deploy a report in my local server.


Basically, I installed SQL Server 2008 R2 in my personal desktop and because of this, I thought no Service Account were necessary since I was going to be the only one accesing it; anyway; I've created a set of reports and everything works fine; but when I try to deploy them, they won't go through.

I open a browser and type http:\\localhost\reportserver and it actually requests me for a password; the username is already populated, which is the name of my computer, but then for the password, I didn't set up any password for anything, during the installation and if I put my computer password, it doesn'y work either, after three attemps, the browser simply goes blank.

I'm sure this might be a very basic issue, but I've been trying to look for answer, online, through forums etc; and no good luck yet...


Thanks in advanced for all your help!



Report shows correctly when viewed from report server, but not at all when viewed from DB server



I've set up SQL Server 2008 R2 on a Windows 2008 server ("SQLDB").  It includes the Reporting Services databases from the SSRS 2008 R2 files-only installation, also on Windows 2008 server ("SQLRS").  The problem I'm having is that reports are rendering when viewed on the report server SQLRS, but not when viewed on the SQL Server SQLDB via the same URL.  The error message is:

"An error has occurred during reporting processing. (rsProcessingAborted)  Cannot create a connection to data source 'SourceDB'. (rsErrorOpeningConnection)  For more information about this error navigate to the report server on the local server machine, or enable remote errors"

In Report Services Manager, I've added my login in "Site Settings" and assigned my login System Administrator and System User roles.  In Report Services Home folder, I've assigned all roles to my user account: Browser, Content Manager, My Reports, Publisher, and Report Builder.  In SQL Server, I've given my login execute permissions to all report stored procedures.

Assuming I'm logged into SQLDB with my regular login, shouldn't I be able to run the report server app and view the reports as if I were running the report server app as myself on SQLRS?


Generate a dynamic number of custom report item instances in a report


Are there any solid examples/tutorials/demos of how to dynamically generate custom report item instances in a report based on the amount of rows in a data set?

Additionally I would like to insert these custom report items in a particular order based on a field in the data set.

Any help/pointers/articles would be appreciated!

SQL Server Reporting Credentials work when I edit my DataSource but when I try to preview a report I


I have a 64-bit SQL Server 2008 SP1 installation with SSL enabled, Reporting Services, Analysis Services and Integration Services are all running.

When I go into Business Intelligence Studio (on a 32-bit Windows XP client) and create a DataSource it works fine when I click on "Test Connection" but when I try to use the same connection to run a report it fails with an error message of "Login failed for user sa". 

I have saved the password so it isn't something as simple as that.

I am obviously using the "sa" user, not passing through Windows credentials, the password is definitely correct as if I make it wrong on purpose it doesn't work when I click on "Test Connection" any more.

I have tried the OLE-DB connection type and also the "Microsoft SQL Server" connection type, both show the same behaviour.

On the server I can see in the SQL Server logs, "login failed for sa user, password does not match" type errors; loads of them.

I can connect to SQL Server Management Studio using the same credentials and it is all fine.  So this is just a problem with SSRS.

This DOES work for some users.  I can save the project, load it on another PC and it works fine.  Getting the same user to log on to my PC doesn't help so it must be something about my PC??

Problem with Reporting Services -- Report Hangs sometimes, need to restart server



We are having an application in which we generate several kinds of reports. We have one report- person addresses, through which we generate the report for all the people whom we have to deliver the cards. This is one of our most frequently used reports.

Some time back, we started getting problems of reports hanging on blank white page and nothing comes up. We restarted the server and everything wents fine. After some more days, the problem occurs again and again we restarted the server.

From that time the problem is coming up again and again and everytime we needs to restart server to make it work. But we cant do that every time ..Can anyone please suggest what may be causing it?

Database server: sql 2000

reporting services : Microsoft SQL Server Reporting Services Version 8.00.1062.00

operating system on which report is running: Microsoft Windows NT 5.2.3790.0

Application is build in .Net 2003

Sometimes the problem comes in 2 weeks, and sometimes it comes twice in a week.

Having Trouble deploying first report, I think it is permissions problem


I think I got SSR installed ok.  From the Configuration Manager when I click on Web Service URL and Report Manager URL, IE opens and returns the correct pages.  I see report manager screen etc.

In BIDS I created a solution and a report that previews fine.  The properties page of the solution has a targetServerURL the same as what is in the Configuration Manager, web service URL tab; " http://IMB-T22:8080/ReportServer ".  IBM-T22 is the name of my computer.  8080 is the port it is using.  Port 80 is used by IIS and not running.

The TargetFolder was created ok...AdventureWorks, but the report does not deploy correctly.  If I deploy it times out.  If I debug I get I get the name of my report can't be found or a permissions error. 

In the solution property page I have tried various differnt TargetServerURLs..Localhost/ReportServer...ibm-t22/ReportServer...ibm-t22:8080/ReportServer...Nothing seems to work.  Please help

I belive I am having permissions problem.  I can connect to database from BIDS and preview data in my report.

When I installed SQL Server 2008 SR2, I used an account name "NT Authority/Sytem"   I used this because it was in drop down and was having problems with "Owner"

In Reporting Services Configuration Manager I have the foll

Deploying Visual Web Part with Custom Server controls


I created a Visual Web Part with VizStudio 2010. In this web part I have a custom server control that exists in a project I added to the solution.


When I deploy from the menu can I tell Studio to deploy the Custom Library or do I install that manually?


It builds fine, but when I add the web part to a web part page I get an exception that the assembly cannot be found.

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