.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

SSRS Report rendering issue

Posted By:      Posted Date: September 19, 2010    Points: 0   Category :Sql Server

Hi All,

i have a chart report and deployed in server and created a subscription for sending email with webarchive type. I can see the chart in out look and it is perfect. when i see the same report in blackberry the fonts are not showing properly(blured).

I have tested via attachement as a pdf file then i can see the clear report in both outlook and blackberry but when make a mode as webarchive i getting the font problem in blackberry.

I am looking for the solution.





- Thiru

View Complete Post

More Related Resource Links

SSRS Reporting Services issue with Rendering Report.


I have created a report that has a tablix with a single cell.  The tablix is set to a dataset that has multiple records, and for each record I am running another subreport inside the tablix cell.  I have the subreport creating a page break for each record, and when printed out the report is perfect, but in the interactive rendering mode with the SSRS Web Viewer, one of my pages comes out blank except for the header being present.

It is not adding an extra page, because in the print out that particular page is rendered with the correct data, but in the interactive mode it is completly missing. 

I would appriciate any advice someone might have.

Thanks in advance.

SSRS Report issue blank page is coming

I have a report with 2 pages, some time the second page doesnot contain the data at that time i want to get only 1 page report. but as of now if second page does not have data it is coming as blank, can anyone help on this. I am using ssrs 2008Jeeva Jacob

SSRS Issue with reloading Report

Dear all, I have developed a couple of reports and could deploy them to different servers. All reports are working fine at all servers and test computers, however I cannot reload any of the reports on my own PC. I tried with IE7 and IE8 but nothing. Scenario: 1. Go to the report 2. Run the report 3. Change any of the paramters 4. Press View Report Button 5. No reloading nothing changes.   It seems like the system could not pass the new parameter value.   Could you please help me out? Thanks in advanc, Zoltan

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).<

SharePoint 2010 Security (Prompts for Login) Issue with SSRS report with Out of Box Web Part


Hi All,

I have a SSRS Customized Report (.RDL). I have a web part with association on one of the report. When I try visit the page I am prompted for credenatial.

My Data Source Properties are as per below

Use this user and Password

  user name: domain\myadminuser


Selected: use as win auth

Selected: Impersonate


How Can I get rid of prompt?






SharePoint 2010 Security (Prompts for Login) Issue with SSRS report with Out of Box Web Part


Hi All,

I have a SSRS Customized Report (.RDL). I have a web part with association on one of the report. When I try visit the page I am prompted for credenatial.

My Data Source Properties are as per below

Use this user and Password

  user name: domain\myadminuser


Selected: use as win auth

Selected: Impersonate


How Can I get rid of prompt?






SSRS Report Sorting issue in Dashboard created usign Performance point services in sharepoint 2010


I have created a report in SSRS and this report is integrated within a dashboard created using performance point services in sharepoint 2010.

The report is a simple tabular report with 5 coulmns and interactive sorting is enabled on each of them.

Sorting works when the report is viewed separately but gives "Report Server Error" when I try to sort (on any column) inside the dashboard.

I have user IP instead of host name in the report server url.

Please help.



Table rendering Bug: Setting Background color for SSRS report (RDLC)



I am facing the issue while trying to create a Report Definition Language Client-side (RDLC) report. I want to set background color to the textbox (used in table) depending on the value. I have used conditional formatting to achieve this. But i am facing issue in setting background color for Some of  the fields like

  1. EnduranceYoYo
  2. Endurance5MinRun

The General Format of the Conditional format is

=iif(<Varchar Field>.value="NA",Gray.iif(<Integer Field> < 600,"Red",iif(<Integer Field> >=800,"Green","Gold")))

I have used this conditional formatting in Textbox (Properties) --> Background (Expressions)

 I have tried the following options to rectify the issue

Option 1 :

This is the format i have used in Conditional formatting in Expression (In Textbox properties -- background -- Expressio

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







Data source not found issue in subscribed report (subscribed in ssrs 2005) , with shared data source


Recently we have upgraded from SQL 2005 to SQL 2008. Following is the issue am facing in some reports in SSRS 2008. More details are below. Any solution/ cause for the issue would be of great help.

 1) Reports having issue are the ones which were deployed in SSRS 2005 through SUBSCRIPTION (Listed under My Subscriptions) and now tried to view in SSRS 2008.

2) The reports use a shared data source with name ‘Test Center’

3) After upgrading to 2008 and when we try to open the report data source not found error is thrown. “An error occurred during client rendering. An error has occurred during report processing. The data source ‘Test_Center’ cannot be found". Why does it have ‘_’ added in the data source name !!

4) When we go to the report Properties – Data sources and check the path of the shared data source, the path is correct and the data source do exists in the path.

5) If we go to report Properties – General – Report Definition – select Edit and save the RDL. Immediately select Update and browse the saved RDL and upload. The report works fine. However the data source reference still remains same.

6) Also if we deploy a report fresh referring the same data source, that too runs fine with no issues.

- Thanks & Regards, RaSuHe

SSRS R2s report issue


We migrated to R2s in our production reporting environment and we have facing some issues with the reports which used to run normally in 2008 SP1.

For some of the report I am getting the below error.

  • An error occurred during rendering of the report. (rrRenderingError)
    • An error occurred during rendering of the report.

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index.


I tried a workaround based upon this URL http://connect.microsoft.com/SQLServer/feedback/details/537919/kjtap-cybersavvy-index-out-of-range-error but this did not help. Can any one please help?

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

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?

SSRS 2005 setup compare - report performance issue



I have a SQL stored procedure that is a data source for the SSRS 2005 report. I use two servers with identical hardware, let’s call them Server1 and Server2. When I run SP directly on the Server1(SQL 2005) and Server2(SQL 2005) within SQL Server Management Studio, SP runs for 10-11 seconds on each server. When I run my SSRS report that is using the procedure within BIDS or SharePoint sites (each server has its own SharePoint site with supposedly identical setup), it runs for 20 seconds on Server1 SharePoint site and for about a minute on Server2 SharePoint site as wel as witin BIDS. There is no network traffic.

When I traced performance on both servers with SQL profiler while running report within BIDS or SharePoint, I didn’t notice anything unusual; it just takes more time to process statements on Server2. I also tested several other reports and they all perform the same on both servers with maybe only a few seconds difference (Server1 is a bit faster). I suspect that SSRS for Server2 has a different setup as the performance declines only

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

Share Point integrated SSRS reports rendering when access from external site


Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

An unexpected error occurred while connecting to the report server. Verify that the report server is avai

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 ,


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