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 |
|
Tedh98
Starting Member
3 Posts |
 Posted - 2005-03-24 : 16:40:43
|
| Does RS have anything like "keeptogether" that will try to keep all records within a group on the same page?I currently have a table report that has several groups. With one of my groups, I will have 2 records show up on page 2, and the other 2 records on page 3. I would prefer to push all 4 records to page 3.Any ideas or help would be appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-24 : 16:46:57
|
| You might try the Page break at start in the groups general properties.Tara |
 |
|
|
Tedh98
Starting Member
3 Posts |
Posted - 2005-03-24 : 16:50:49
|
| Thanks.I tried that, but it makes final report look odd. Many of the groups will contain only 2-7 records. So when employees export the report in .pdf, they get 7-8 pages with each page containing just a few lines.I was hoping that RS had a built in way to try to better manage the final output. |
|
|
|
Tedh98
Starting Member
3 Posts |
Posted - 2005-03-24 : 16:56:14
|
| I need to modify my original question. RS does have a KeepTogether option, but it appears to be limited to the table. I was hoping their was a Group level KeepTogether option. |
|
|
|
graabein
Starting Member
16 Posts |
Posted - 2007-03-26 : 05:13:09
|
| This don't work for me at all. I have five tables on my report and they all have keep-together checked. When I present the report in Internet Explorer it pagebreaks in the middle of tables as it feels like. I cannot use pagebreak at start/end because the number of rows in each table varies from 3 to 15 + table header. Want I want is all tables on one page when it's a low row number and pagebreak before a table when it won't fit at the end of a page. This should be basic functionality. Is it a bug? I'm running SQL Server 2000.I also tried putting the tables in rectangles but that produced the same result. This is very frustrating. Otherwise I like SQL Reporting Services just fine. |
|
|
|
|
|
|
Keep Together functionality?