.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

Report Builder 3.0 renders empty page for Reports with Matrix (column group) in Landscape orientatio

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

I need some help.


If I create a Report with a Matrix Tablix (with row Groups and column groups) in landscape layout and preview it in print layout, the report generates me some extra empty page every 2nd page.

I don't understand the rule, why it's doing that.


My Report settings are:

  • PageSize: width: 29.7 cm, height: 21 cm
  • InteractiveSize: width: 29.7cm, height: 21 cm
  • Margins : 0cm,0cm,0cm,0cm
  • Report Body : widht: 25cm, height: 10cm

According my Report settings this shouldn't happen, should it. The width of my Tablix is max 22cm.

What I noticed is, that when I shrink the width of my Report Body to 21 cm (to the width of the portrait layout) or less, the emtpy pages disappear.

Or when I delete the column group, it also renders the report without some empty pages.

I think this problem has something to do with column groups.


Is this a bug or am I missing a setting?

View Complete Post

More Related Resource Links

Empty/blank group at top of matrix table

I'm having trouble creating a report with matrix tables.  I've got all the data showing up properly, but the first line in the preview is always blank.  If I subtotal the groupings, I get a blank Total line as well.  How can I stop this from happening? I'm using SQL 2005, report designer.  Data is coming from a stored procedure.  I've executed the sp in management studio as well as in the data tab of the report and it comes back with the correct data (no completely blank/null lines).  I'm new to SSRS and I've tried googling for a solution, but haven't found anything similar.  Below is the sp and the output data. SP: SELECT s.Status_Name + ' (' + CAST(CAST(s.Status_Weight*100 AS int) AS varchar(50)) + '%)' AS Status, s.Status_Order, CASE WHEN co.Company_Name IS NULL THEN '' ELSE co.Company_Name END AS Company_Name, co.Est_Income FROM tblStatus AS s LEFT OUTER JOIN tblCompany AS co ON (co.Status_ID = s.Status_ID AND co.New_Upsell = @NewUpsell) GROUP BY co.Company_Name, s.Status_Order, s.Status_Name, s.Status_Weight, co.Est_Income ORDER BY s.Status_Order, co.Company_Name Output (mgmt studio): Still Connecting (0%),1,Company1,400000.00 Still Connecting (0%),1,Company2,3000000.00 Clear Future (0%),2,Company3,250000.00 Clear Future (0%),2,Company4,250000.00 Appointment (10%),3,,NULL Proposal (40%),5,,NUL

Report Builder 2.0: duplicate rows do not show on reports

Hello,Created a report using a report model.the problem is that duplicate rows do not show on the report.Why?And also how can this be fixed?the report shows product ids, that may or may not have serial numbersticket numbers can have mulitple products associated with them and they may or may not have serial numbersthe report data row is as follows:example:order number, ticket number, product id, manufacturer id, serial number123                  456               dsl_router 12  cisco123                  456               dsl_router 12  ciscothe above data shows as one row on the report, thus, showing it to be one product, but really there are 2 products and there should be 2 rows.is this a bug?how can this be fixed?Thanks.

Report Builder 2.0 and Matrix Sub totals

Hi All, Hope someone can assist... I am busy building a complex Financial report and have to deal with lots of Sub Totals etc. I basically have 2 questions: 1. I have 2 Matrixes and wan't to "SUM" the sub total from one matrix with the sub total from another (both will have seperate groupings, is this even possible. 2. How do i add the Value of "TextBox1" to the value of "TextBox2", the expression will be appriciated ? Regards  

is it possible to make 2 column name badges with Report Builder 2.0?

I am starting the process of moving reports from Crystal to SSRS and I am trying to build what I beleive should be a simple two, column (Avery 74461) name badge report.. It should look like this...       NAME                           NAME FULL NAME                   FULL NAME  COMPANY                    COMPANY Yet I cannot find anything in the forums or help system... Basically it is a 4 up by 2 wide name badge page.. i need different names on each badge.. Is this something it can do or no? and if so can I have some type of example on page layout field system to use? (ie: matrix, text boxes, etc)   Thanks!  

matrix including zero values in report builder

I have a user that has created a matrix and they are wanting the row to return even if the data value is 0.  Basically the Matrix calculates the number of students enrolled in 10 buildings and 2 of the buildings have no students, so those 2 buildings are excluded in the output.  Nick

Report Builder 3.0 issue - can view existing rdl files but cannot create new reports

I have Report Builder 3.0 deployed on my local machine pointing to a remote SQL Server 2008 R2 instance outside of my local domain.  Within this local Report Builder 3.0 instance I am able to open up previously created rdl files from the remote SQL Server 2008 R2 instance that I am connecting to.  However, if I try to create a new report on my local instance of Report Builder 3.0 and attempt to use the same data source as was used to create these existing rdl files, I receive the error: "Unable to connect to data source. The user credentials provided in the connection string do not have permission to connect to Reporting Services."  So why can I open existing rdl files from this remote SQL Server 2008 R2 instance, but not create new ones even though I'm using the same data source as the existing rdl files?  Thanks, Mark

save reports in Private and Public folder using Report Builder 2.0




I have a report builder built on RB2.0. Users are able to create their reports and browse them.

Now, Users wants these reports to be saved in their Private folder and public folder.


Also, I have a UI developed in .Net 3.5 from where I am calling this report builder.  In the UI, I need to show the users those reports that they have created in a drop down list. And when the user clicks on any report (that they created should) open.


I have searched a lot but not getting any clue how to allow the business user to save a report

Hide static Column in matrix report


I created one matrix report. i have 2 static columns and some dynamic (PIVOT) coulmns.

I have one boolean variable. If it is true need to hide first column else hide second column.

For matrix report Column visibilty property is disabled.

How to do this?

kindly help me.

Report Builder 2.0 Strange column when using model

Hi, We have build a simple dsv and model and are writing reports in report builder. Every time we add in a linked table we are getting a column appearing with strange values e.g. "AH.gEAAA=" these appear to come from no where and have a column name the same as the table, Can anyone please explain what they are and how to get rid of them please.

I'm getting exception while running Report builder 2.0 for SSRS Reports

I'm getting Exception like Failed to Preview Report "The request failed with HTTP status 401: Unauthorized." for SSRS Reports from Report Builder 2.0 application? May i know the reason?
Also please inform any other way to Preview Reports On SSRS through Report Builder.?

Note : I'm Using the Report Server as remote machine.


Crystal reports group wise printing in new page




i have one problem in crystal reports.i made one group with accounthead.i want to print each account head in new page.please give me the best solution for this task.

Thanks in advance,


in crystal report i need to print each group in new page



i have one problem in crystal reports

i want print  group details ,for each group it should print in new page.

some thing like this




Transaction Number                Date                           Amount                           Remarks

   1111                                   10/1/2007                    300.00                                 JE999

   2222               &nb

Group report splitting into multiple pages Need it in 1 page


1) Few of my group reports which have more than 500 rows are splitting into many pages without column header. (eg, page 1, page 2... etc.) I would like configure it to be in one page however large it may be.

2) I tried setting column header in group reports which are splitting into multiple pages but its not working.

Either I need achieve point 1 or point 2

Could you please help me how to achieve it?


Report Builder returning #Error value in empty fields and working with Date field


Hey guys,

I am trying to build a report using the date field from CRM and only wanting to return the date I am using this expression "=Fields!new_date.Value.ToShortDateString()" but when there is an empty fiel I get #Error. How do I solve this?

Also is there anyway to return the date field with the actual month showing instead of the numerical value? i.e. instead of 1/31/2010 Have it show January 31, 2010 (Doesn't have to be exactly in that format, but want the name value for the month.)

Report Builder 3.0 Can NOT see 2005 built reports, report models or datasource


We have 2005 bids but have installed 3.0,  thought I would be able to use datasources and report models and retrieve RDL for review or changes.  Is this possible?  I sort of understand that If I want to republish these reports it would have to be on an 2008 installed instance of visial studio.

How far off am I and can any help or point me in the right direction,

Thanks in advance,


SSRS-2005 Repeat Matrix On Each Report Page

I am using two matrix controls in my report. Both use different data sets. I want the first matrix to repeat on all the report pages. Can someone help me with this? Thank you in advance.

SQL Server 2008 r2 Report Builder 3 problem with "landscape" orientation


 I am trying to format a report that is oriented in 'landscape'.  I have set the report properties page setup for 'landscape' but the program formats the report in 'portrait' mode.  The program recognizes the margin settings but does not recognize the 'landscape' orientation.  Has anyone else had this problem?

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