How to make an overflowing chart list continue below instead of on the next page - Report Builder

[emme1995]

Hello everybody,

I have a list of charts that I want to display. I want this list to continue below on the same page instead of on the next page (the remaining space on the page is enough). The following image shows what I get.

While the next image shows what I want to achieve

I have tried modifying the various Tablix properties but to no avail. The data format is a 4x1 matrix with the graph in the last row and the graph data in the 'Column groups' section.

Thank you in advance!

[jla_92]

Hi,
I have the same problem and it seems not so straight forward to solve. I have tried the solutions above without success.
To simplify everything, I have created a new report, with a simple matrix.
The matrix has a column group "Windfarm ID" and a value (Count of Turbines).

The goal is that the Matrix displays as many columns -one for each Windfarm ID as it can fit in the page width. When the limit is reached, it should jump to the next available space under the table, and AVOID jumping to the next page. 

When I execute the code, it generates the following: 

Which initially looks good, but the problem is when I visualize the page layout: only two values fit. The empty space below the first row is not used, and instead, it jumps to the next page.

The expected result would be the following: 

So far, i have tried to use all possible settings with the page break parameters without success. Is there any other alternative?

[Bmejia]

There is a limit on the page layout.  You only allow to fit base on the paper size your going to print.  What i usually do if i need to print a report that is going to have lots of columns is to change my report properties, from portrait to landscape and change all the margins to the lowest settings your printer can print which is usually around .05 in my case.  That will give you extra space to work on.  Also change the font of your report to smaller font.   Also you can make everything smaller if you have visuals.  There is alot of playing around that has to occur during the design phase.

I think in your case make your matrix column narrow, even if you do not see the datasource fields, they still be there.

The last option is that this is done by the user when they download the file to excel they can do the page setup there.

[jla_92]

The problem is not the size, neither the limit of the page. The problem is that it jumps to the NEXT PAGE, instead of taking the space below in the SAME PAGE. 
I want to force it to use the space below.

[Bmejia]

Check the graphs or tables where there is a break that there is no start or end breaks.  Make sure you expand the view as below else will look like there is no page break while looking at it.  It should be none if you don't wanted to have any pagebreaks for all visual.

[emme1995]

Hello Bmejia and thynk you for your answer.

I already tried it and it didn't work. I really don't get where the error is.

[Bmejia]

When I generate my sample reports with graphs and none of my graphs have a page break I do not get the option to go to the next page.   if your data is enclosed inside other matrix then is possible that is set to move to the next page, sort of when you work with headers.  I even made the graphs larger and they are still on the same page.

If you are seeing this in Print Layout then that is different you will need to adjust the data to fit the size of your page meaning making them smaller and that they are not outside the margins.

Sorry can help you much,  I though maybe you had a page break that was causing it to move to next page.