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 |
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-08-04 : 10:58:40
|
Is it possible to have a page break base on groups?I have a query that will pull records, but I want it to start on a new page each time a category is different.For example I have all data in category 3, that will be in a page by itself. Then let say that it goes to category 4, I want that to start on a fresh new page.Any ideas? |
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2005-08-05 : 10:41:11
|
What reporting software is this? If it is Crystal 9 then you can go into the Section Expert for your group and check "New Page Before". AjHey, it compiles. |
 |
|
gcowhsu
Starting Member
38 Posts |
Posted - 2005-08-10 : 12:15:48
|
Yes if you click on the properties for the table then click on groups then click the groupthen click on edit group detailsyou will have the option to break before or after the group |
 |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-08-19 : 09:58:32
|
Thanks that works. |
 |
|
|
|
|