Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Itzon
Starting Member
4 Posts |
 Posted - 2008-05-15 : 14:24:25
|
| I have a report that returns multiple tables in a group. I'm grouping by project manager which has multiple projects, each project contains data in a table. My problem is that when I print, my tables are being cut off so that the headers and first few rows are on one page and the rest of the table and totals are on the next page. There was a command in access that would allow me to keep my tables together so that if a table wouldn't fit on a page it would move the whole table to the next page. No table is larger that a page, but I'll get 2 and 1/2 tables on page 1 and 3 and 1/3 on the second page, I'd like to have 2 on the first page, move table 3 to page 2 and move on from there. Is this possible?? Thanks for any help you can give me. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-15 : 14:47:19
|
| Not sure you can do that. However you could check the option place a page break after this table so that you could get each table on different page.or you could try putting the two tables in a rectangle and check the property put a page break after rectangle as true. |
 |
|
|
Itzon
Starting Member
4 Posts |
Posted - 2008-05-15 : 15:59:11
|
| I only have on table and I'm trying to avoid printing 1 table per page. I'm replacing an access DB and access reports with SQL 05 and SSRS, so the current access report does this just fine, no tables are split across pages. They aren't liking the answer that SQL can't do that... |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2008-05-15 : 16:25:50
|
| It's not that SQL can't do it. It's that the feature might not be in SSRS. I would be willing to bet there is a way in SSRS. It's just a matter of learning SSRS and figuring out the equivalent or coding it a new way. I'm not well versed in SSRS but maybe someone else here knows exactly what to do. I'd be willing to bet there's a property for it. As Visakh16 said, you could try putting a rectangle around it and set the pagebreak property. That way if it doesn't fit on the page, it might carry it all to the next page. |
|
|
|
|
|
|
Help Stop tables from spanning multiple pages