.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 Reporting Services issue with Rendering Report.

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

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.

View Complete Post

More Related Resource Links

SSRS Report rendering issue


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

SQL 2008 Reporting Services Report Parameter and Analysis Services issue after upgrade

I have upgraded my SQL 2000 database and analysis server and SQL 2005 reporting services server to a new instance of SQL 2008 running database engine, analysis services and reporting services.

The analysis services database migrated successfully and I have got the database into a state where it processes fine but I am having the following problems.

- My Reports show in reporting services but the drop down list parameters are all empty.
If I change the parameter in report builder to use the display name instead of the uniquename then the drop down list populates and works until I select a value that contains a space character and then it reports a problem with the dataset used by the report.

Query for the dataset used to populate my parameter.
with member [Measures].[GroupUniqueName] as '[Site].CurrentMember.UniqueName' member [Measures].[GroupDisplayName] as'[Site].CurrentMember.Name' select { [Measures].[GroupUniqueName], [Measures].[GroupDisplayName] } on columns, { [Site].[Group].members } on rows FROM [Invoice Reporting]

Query used by the report, filtering on the selected parameter value from the drop

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.



Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

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

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

Coloring sql reporting services report depending on the change of value of a certain field

Hey guys, I have an SSRS report that looks something like this: Column1 Column2 Row1 2 A Row2 2 B Row3 2 C Row4 6 A Row5 11 E How can I color the rows with the same value in Column1 with the same color? for example Row1 to Row3 would have one color, Row4 would have a different color, then I'd go back to Row1's color for Row5? note: I don't know in advance the numbers returned in Column1. I query for them and then I hide them from the user so Column1 shouldn't show on the report, but I want to use it for the coloring only.

Kerberos issue with SQL Reporting Services 2005 on Server 2003 R2

Hi Guys,apologies if this is the incorrect forum, so moderators, feel free to move it to SQL/IIS/SharePoint as appropriate... [Windows Server Security moderator pushed me this direction]I have a test environment that I'm trying to get SQL Reporting Services 2005 SP3 working in integrated mode with SharePoint 2007 SP2.The environment is all in VMWare, running Server 2003 R2 x86 and is layed out like this:SERVER A:AD/DNS/DHCPSERVER B:SQL 2005 SP3 CU8SERVER C:SharePoint 2007 SP2 Dec 09 CU- Central admin on port 9000- SSP on port 9001- MySite on port 81- Main Content on port 80SQL Reporting Services 2005 SP3 CU8- Reporting Service website on port 82SERVER D:SharePoint 2007 SP2 Dec 09 CU- Central admin on port 9000- SSP on port 9001- MySite on port 81- Main Content on port 80SQL Reporting Services 2005 SP3 CU8- Reporting Service website on port 82Through the use of DNS and (SharePoint) Alternate Access Names, SERVER D is used to deliver the Main Content in SharePoint and the Reporting Service website.  SERVER C is used to deliver the Central Admin, SSP and MySite.I've set up SPN's for the SharePoint App Pools, using the following: [main content] setspn -S HTTP/SERVERA DOMAIN\AppPoolUserA setspn -S HTTP/SERVERA.FQDN DOMAIN\AppPoolUserA setspn -S HTTP/SERVERB DOMAIN\AppPoolUserA setspn -S HTTP/SERVERB.FQDN DOMAIN\AppPoolUserA [repor

"An error occurred during printing. (0x8000405)" eror - reporting services issue

We are getting this error: "An error occurred during printing. (0x8000405)" from time to time - 70% of the time when we are trying to use a printer button within report manager. It happens if we preview report or just print it. We noticed if we restart RS services, the error will stop for a little bit and then starts again. We don't print that much and it will come back after just a few reports printed. Let me know if you had a similar issue. thanks!

SharePoint 2010 Reporting Services report on sharepoint list rsExecutionNotFound

I cannot get SQL Reporting Services 2008 R2 to work with a datasource that is a sharepoint list.  Reporting services seems to work fine setup in SharePoint 2010 Integrated mode. When I try and run a report that is based on a sharepoint list, I immediatly get the following error: The report execution tp15sp4515l3seqqo4do3e45 has expired or cannot be found. (rsExecutionNotFound) This seems to be something I am doing wrong with the sharepoint configuration, I would guess.  I haven't tried a regular database query, but they used to work when reporting services was configured for native mode.  So I assume this is just a problem connecting to sharepoint 2010 lists, with the new SharePoint 2010 List connection type. Edit This has got to have something to do with a permission setting for the app pool account of sharepoint.  I read something once where it said you had to grant it permissions, but every guide I've found since then doesn't mention anything about it. This log entry is where the problem seems to be occuring, I just don't know what permissions to give TESTDOMAIN\spweb which is the app pool account. library!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, tim

The report server instance is not configured correctly. Please use the Reporting Services Configurat

Hello All, I am having problem in configuring report server in SharePoint 2010 Central Administration. The Scenario is explained below: We have farm with two Servers with following components installed: 1. APPSERVER : SharePoint 2010, SSRS(2008 R2) and Reporting Services Add in (installed using credentials    (domain/sharepointuser)) 2.  SQLSERVER: SQL SERVER 2008 R2, Report Server Database (installed using credentials    (domain/sqluser)) Steps followed: a. Configured Report Server on APPSERVER with database in SQL SERVER. We browsed the report server url (http://localhost/reportserver) successfully b. Installed Reporting Services Addin on APPSERVER c. In SharePoint Central Administration, Under Reporting Services Integration, we gave the report server web server url as http://localhost/reportserver , authentication as Windows Authentication and credentials which are used to install SQL SERVER (domain/sqluser) d. We also added a new group called WSS_WPG Error is given below: The report server instance is not configured correctly. Please use the Reporting Services Configuration tool to create a report server database in SharePoint integrated mode before setting integration options for this SharePoint Web application. Thanks in Advance  

How to set the IP addresses for teh report server on sql server 2008 reporting services

How to assign IP address to report server on 2008 version, i don't see nothing on IIS. I have installed sql server / report server 2008 on windows 2003 server. I don't see no info in IIS, can you please help, Also how to check the configuration files i remember in 2005 version i still have to open teh configuration file in notepad and do some modifiications with teh http://local to http://IPaddress etc. Thanky ou very much for the help ful info.  

SharePoint and SQL reporting services. Report of access?

Hello,Can a report be created with SharePoint and SQL reporting services that shows who has accessed the document and when?Thanks in advanceSebastian  

Reporting services + report parameters and custom dropdown length

Hi, I have some report and plenty of parameters inside that report. One of parameter contains values stored inside dropdown list (that are downloaded from db). Is there any way I can set the maximum length of that dropdown control? The problem is that when I expand drop down list I have a horizonal scrollbar because some values inside that dropdown list are too long. How can I customize this parameter and dropdown control so there will be no horizontal scrollbar and values inside it will always be visible?

Permission Errors for Users on Home Page only of SQL Server Reporting Services Report Manager

I have spent days now investigating this problem, so any help very much appreciated! I have a remote web server 2003 running SQL Server R2 Express Edition with Reporting Services installed. I use Report Builder 3.0 locally to build report. If I login via Internet to Report Manager Web Page as an administrator I can perform all the expected and required actions, creating new folders and assigning permissions for users etc. I have added a new user "ReportUser" as a Browser of a child folder. If ReportUser longs on to home page, he receives the all too familiar error: User 'XXXXXXXX\reportuser' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. However, if the user starts at the child folder of home page, and then logs in, he sees the expected page, and can run the report!  This is not very satisfactory. How can I allow user to see home page, without an error message, but not be allowed to click on any folders to which he is not entitled? I am now aware that SQL Server R2 Express Edition has many limitations compared with full Editions (fixed roles, cannot manage Report Service from Management Studio etc) , and many of the "solutions" offered on the web just do not apply.   John Walton

sql server reporting services issue

Hello, I have an issue with the sql server reporting services. I make a report , which uses alternate background color for each row. when i preview all seems to be done good. but when i deploy this report on report server , which is a configure as  localhost/ReportServer. when i use http://localhost/ReportServer , "Reports"  directory display which contains all the reports. then i click on my report. Problem is that alternate color for rows not refelected on first column. I do my best to sorted out this problem but in vain. please help me thanks & Regards Rajiv

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