I'm using SSRS 2008 and I have a report that has a tablix matrix and renders properly in BIDS. However, when I select it from the Report Manager Report's website (or view it through my web application using Report Viewer 2010), it doesn't render completely and doesn't show the last table column of the tablix or any of the matrix columns of the tablix. For example, in my tablix I have the columns: Physician, Address, City, State, Zipcode, and Month (a matrix group). In BIDS I correctly see all the columns and all the months for the date range I entered. In BOTH Report Manager (http://myserver/reports) and on my websites which use Report Viewer 2010 I only see data for Physician, Address, City, State. There is a column for Zipcode but no data in any of the rows for it. There's also a blank column to the right of Zipcode but no column header and no data. I did upgrade from SSRS 2005 to 2008 and I am going against a SQL Server 2005 database engine. I don't think this matters though. Could my computer or my web servers be missing some component that's needed for displaying a tablix matrix in Report Manager or through Report Viewer? Any ideas? Thanks in advance, John

Hi John, I suspect that there is an issue with the report layout post upgade. Try to arrange the tablix and ensure that there is enought width to hold data in the same page. We generally tend to see similar effect while rendering to pdf. The table gets split across multiple pages when the lay out width does not have enough spacing to hold data. Regards,Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

I have tried recreating the report from scratch in BIDS 2008 and deploying it to my server. That didn't solve the problem. I tried changing the width of the report, interactive size, and body separately and together and that didn't solve the problem either. When I run the report I don't see extra pages for the missing zipcode column or the matrix portion of the tablix. I'll keep trying different things. Are there any Microsoft guys out there who might have an idea what's going on here?

I tried recreating the report in BIDS 2008 and also just creating a simple Matrix report but in either test the matrix columns are not showing up at all. Just a single empty column for the matrix. I also tried changing the width of the report, then changing the interactive width, then changing the body width, then changing the column widths to make them larger, then all the possible combinations and still the report will not show the matrix on my report server. The report renders correctly when previewed from BIDS 2008 but not when I've deployed it to my report server and accessing it from there. Are there any Microsoft guys out there who have an idea what could possibly be going on? Any ideas?

Hi John, Based on your description and testing. I need to confirm the issue is caused by the Report Server. So I also created a simple matrix report which works fine on my Report Server. It is available at http://cid-1e189c82ae92dfd8.office.live.com/self.aspx/.Public/Reporting%20Services/TestMatrixReport.rdl. The data source for the report is the AdventureWorks2008 sample database (download). Please correct the connection string in the report, and then deploy it to your Report Server and test again. If the matrix columns of the report are not showing up on your Report Server, I would recommend you contact Microsoft Customer Support Services (CSS) via telephone, so that a dedicated Support Professional can assist you in a more efficient manner. Please be advised that contacting phone support will be a charged call. However, it will be free if this is a product issue. To obtain the phone numbers for specific technology request please take a look at the web site listed below. http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS If you are outside the US please see http://support.microsoft.com for regional support phone numbers. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Tony, When I add TestMatrixReport.rdl to my project (I'm using BIDS 2008) I cannot open the report in the report designer. It just shows up as XML. Just a thought... Even though I have SSRS 2008 running I am running SQL Server 2005 for my database server. The ReportServer database shows up on the SQL Server 2005 database server. Everything I've found says there's no problem with this since it's just the metadata for the report definition... but I have to wonder if you won't get any of the SSRS 2008 features like Tablix and such with this type of setup? When I setup SSRS 2008 it asked me to create an instance name but I don't see another instance for that server since it's not another database server instance. Does that make sense? Thanks, John

To view Tony's test report in BIDS, you need to add it to a project. You do this by opening BIDS and going to the Solutions Explorer and right click Reports > Add > Existing Item... Then navigate to the .rdl file location. If you're running SQL Server 2005 as your database, you may not be able to the the AdventureWorks2008 sample database to load though... JasonJason Long

Ok, your report and my report show up fine on my development box. But, when I run these same reports on my production server the matrix doesn't show up. I don't understand it. There must be something the production server needs.

Hi John, So far we can say the issue is caused by the Report Server but not reports. You also mentioned you upgraded from Reporting Services 2005 to 2008, and this might cause the issue. As I suggest in my first reply, please connect Microsoft Customer Support Services (CSS), so that a dedicated Support Professional can assist you in a more efficient manner. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

It turns out my stored procedure on my production server was out of date. I updated it and it works fine now. Since it didn't report an error I had no idea that it was missing the columns. I finally found the report server log files and noticed a rather cryptic error message about fields not being found.