SQLTeam.com | Weblogs | Forums

Blank page generated between two tablix in SSRS report

sql2008r2

#1

I have two tables in my report.
First tablix, should be shown on first page
Second tablix, should be shown on second page.
Second tablix should be on second page even if first tablix entries finish at the half of the first page.
I added a tablix between first and second tablix, with a single textbox, font color white and with no borders.
I added page break on this third tablix with page break property start.
There is a blank page coming in the report between first and second tablix. How to fix this?

I am using SQL2008R2 BIDS.
I tried using page break for first Tablix, with break location ‘end’, it was showing a blank page at the end.
That is why I introduced Third Tablix, between first and second Tablix.
For third Tablix, I tried page break, with break location ‘start’, it was showing a blank page at the end.
Then I tried with break location ‘end’, it was showing a blank page at the end.
So I desperately need a solution.


#2

Get rid of the third Tablix. Bump the 2nd as close to the first as you can. Set the page break on the SECOND tablix using BEFORE. Remove any page breaks from the first one.