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

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

Issue with toolbar when loading the RDL (upgraded to ssrs 2008 R2) via report viewer in MOSS 2007 se

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#
Our front end server is Office SharePoint Server 2007 and the RS is SSRS 2008 R2 (native mode).

The toolbar is different when loading the same RDL (upgraded to SSRS 2008 R2) through report viewer and report manager. In report manager, the toolbar is color blue while when displayed through report viewer the color of the toolbar is light brown/yellow. Color blue indicates it is using the latest version of SSRS while the other color for previos version. Aside from that, the font of several texts in a table has increased to one point when viewed via report viewer compare to when viewed via report manager.  Is there an existing fix for this?

View Complete Post

More Related Resource Links

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

SQL 2008 servers and MOSS 2007 with SSRS


I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS.  Here is the run down:

  • I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server.  In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
  • Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server.  The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)?  Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?

Graphs stop displaying in Report Viewer Control after upgrade to SSRS 2008 R2

We are seeing an issue where certain graphs and guages are not being displayed within a report rendered in the report viewer control after we upgraded from SSRS 2008 to SSRS 2008R2.  You can see the graphs and guages render and then disappear from the screen when two other graphs are rendered.  When I export the report to Excel or PDF then all of the graphs and guages are rendered properly. There are a total of 3 graphs and 2 guages on the report - when it completes the rendering process, you can only see two of the graphs displayed in the report viewer control - as I said before, you can see all 3 graphs and 2 guages when exporting to Excel or PDF.  Using Internet Explorer v8.  This problem manifest itself right after the upgrade. Has anyone seen a similar issue? 

Font/letter spacing issue when printing from SSRS 2008 report page


We are developing reports in SSRS 2008.  When printing from the SSRS report page, we are seeing that that some text is "clumping" together or spaced oddly. I have tried a variety of printers so it's not printer-specific. If you export from the SSRS page to PDF or to Word and then print, everything prints as expected.

Nothing is as good as real text/names/data, but to reproduce, simply create several text boxes with...

I used several common fonts...
Arial, 10 pt (SSRS 2008 default)
Times New Roman, 12 pt (Office 2003 default)
Calibri, 11 pt (Office 2007 default)
Verdana, 11 pt
Tahoma, 11 pt

In the example above, I used normal weight, nothing fancy... If you use bold and underline, which is common for a page/column header or footer, this issue is even more apparent.

It feels similar to the following issue: https://connect.microsoft.com/SQLServer/feedback/details/482312/ssrs-report-font-rendering-issue

A workaround would obviously be to export to PDF and then print, but these are steps that our end users shouldn't have to (and won't want to) put up with to produce reports/invoices/etc. that ultimately go

Strange issue with a huge SSRS 2008 report (supposed to return 3 million records)



NOTE: The strange part (as mentioned in title) will come in the end.

I am running a SSRS 2008 report which fetches 3 million records from a remote server. After around 1 hour the report processing stops and I see an error icon on the lft bottom of the browser window. When I click on that to see the error details it shows some PageRequestManagerSQLErrorException with an unknown error message with code 12029 (sometimes 12002).

When I see the reportserver logs there is an error message logged in it which says "Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached."

The <DatabaseQueryTimeOut> value in the report server configuration file is already having a value set to 7200 seconds(2 hours).<

Report Viewer Web Part - MOSS 2007




     I am working with the Report Viewer webpart on sharepoint 2007 to display reports from another server (native reports). So now i am showing around 4 RS reports on the sharepoint site side by side. The reports seem to appear fine.


Now when i try to change the title of the Report Viewer webpart to display the name of the report it just dosent seem to change for more than one. Every time i click 'Modify Shared Webpart' the title of the report viewer webpart reverts back to the default 'Report Viewer'.


I also tried opening the sharepoint page using the 'Sharepoint Designer'. The titles seem to reflect the entries i have entered. But the titles just dont appear on the sharepoint page.


I have been trying to figure out if there is some autogeneration of webpart titles taking place but just cant seem to figure that out. Any help would be greatly appreciated as i have been stuck on this for quite some time.








SSRS 2008 R2 Sub Report Issue


Hi ,

I have two reports . F102  and F103. We need to make F103  as a sub report to F102.

Issue is facing with the sub report.

Getting the following error.


Data retrieval Failed for sub report sub report2.  Located at  /Example subreport. Please check the log file for more information


When checked the Microsoft, got the information that, it will be solved by Cumulative update package 3 for Sql server service pack1. Have downloaded the cumulative update package 3(KB971491) . But unable to install . It is showing the following error



There are no SQL SERVER instances or shared features that can be updated on this computer


I have installed sql server 2008 r2 in my system.  Already service pack1 (SP1) is installed in my system.

Questions are

1. Do I need to uninstall sp1 and reinstall sql server cumulative package 3 in my system?


Thanks & Regards







SSRS 2008 R2 Reportbuilder 3.0 and MOSS 2007


Hi all After installing integrating SSRS 2008 R2 with Sharepoint 2007 we are trying to implement the click once functionality for Report Builder 3.0 so that clients can download Reportbuilder. However I keep getting the following error: -

The remote server returned an error: (401) Unauthorized.

Reading through various articles most notably: http://msdn.microsoft.com/en-us/library/ms365173(v=SQL.105).aspx and http://msdn.microsoft.com/en-us/library/cc281309.aspx It seems the problem lies in the fact that the computers lie in different domains and the account being passed is that of the local client machine.

I have tried to implement the anonymous access as per the second article but this still fails with the same error, and the article is really only for native mode installs. Does anyone know a way around this when using Sharepoint Integration?

My clients will be accessing from the web so having then in the same domain is not an option and neither is anonymous access for the entire site as it is required that they authenticate.  This used to work with SQL 2005 SSRS and Reportbuilder but not for SQL 2008 R2 it seems.

Thanks for any help

Image not displaying in SSRS Report from moss 2007 list


Hi, I am generating SSRS report for one of sharepoint list, In this list one filed is picture type for KPI Indicators. After generating report i added picture field by using the below procedure:



Then it is displaying an image holder with RED CROSS image in it.

I tried a lot of things but not able to rectify this as Images for my report is mendatory.


how to use Report viewer and report Explorer web part in sharepont 2007 for ssrs


i have to show ssrs report in the sharepoint 2007 using report viewer and report explorer how to user this two web part to get the ssrs report in sharepoint 2007.

i am new to the ssrs with sharepoint 2007.


How to use report viewer 2010 in VS 2008


I downloaded report viewer 2010 from here


Now I want to actually use it in a website.  How do I do that?  Do I have to modify some part of web.config?  Specifically, what do I need to change?


Checkout/Chevk in issue in MOSS 2007 while connecting through VPN(virtual private network)


HI, I am using VPN connection . When I try modify a file and try to checkin the file in sharepoint document library it does not gets checked in. I get a message saying

"Unable to checkin the file, since File is being edited in Local Draft, please close the application or discard the checkout ".

Please do the needful....



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 ,


VS Studio WorkFlow Failed on Start in MOSS 2007 ON Windows Server 2008 64 Bit


I have created a sequential sharepoint workflow in WSP Builder in my Sharepoint Server and Deployed it.

But the workflows says Failed on start and retrying ans stops there forever says couldn't start the workflow.

I repaired .NET Framework 3.5sp1 installed

 tried this

 1. I tried again, in C Prompt:  Lodctr "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"  it says initiation file cannot be found

2   i again tried this C prompt Lodctr /R "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"

it says reloaded  from the system restored

i am still getting the same error.

When i manually go to my  C:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation i can see a folder for SQL that's it nothing more than that..

I dont know what is happening i am trying it from 2 days and still no solution.

any ideas would be real great help for me.

My system is 64 bit , Window server 2008, MOSS SP2, Visual Studio 2008 Version 9.0.30729.

.Net Framework 3.5 sp1

and WSP builder the one from Codeplex for 64 bit machines

Issue With MOSS 2007 Picture library



We have a MOSS 2007 publishing portal. We are currently facing issues with Picture library created with default picture library template.Whenever we have tried to upload an image to the picture library I am getting "acess denied" error message, though I have full permission to the site level as well as to the library level.I have seen the pictures are getting uploaded and in "checked out" state.It does not show the "edit properties" page on upload and does not even allow the owner of the image to edit the properties, gives the same access denied error message.

I have also tried to check in the image files through the "management and content structure", but the images are not getting checked in. Please let me know the root cause of this and how we can resolve this.





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,
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