If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Keep together subReports
Hi all
Well been working on this a while! How do you get subreports to stay together on a page and stop half of a 3 line report starting on one page and finishing on another. I have everything I can see set to keep together but it just ignors me (and laughs) and continues to do exactly what it likes. The three lines are separate fields with one line per field and i am printing a report in two columns A4 landscape. Help |
#2
|
|||
|
|||
Keep together subReports
Derek Brown wrote:
Well been working on this a while! How do you get subreports to stay together on a page and stop half of a 3 line report starting on one page and finishing on another. I have everything I can see set to keep together but it just ignors me (and laughs) and continues to do exactly what it likes. The three lines are separate fields with one line per field and i am printing a report in two columns A4 landscape. Don't forget that you can only use KeepTogether for a single instance of a single section. This means that the main report section that contains the subreport is where you need to use the KeepTogether property. If the mainreport detail section has a bunch of other stuff before or after the subreport that you don't need to keep together, then use Sorting and Grouping on the detail's primary key field to split the data across three sections. Maybe(??) there's another way that can be done in the subreport. Create a group in the subreport on the expression =1 and set the **groups** KeepTogether property to Whole Group. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Keep together subReports
Hi Marshall
Tried last suggestion, I have inserted a new group cut and pasted three fields to the new sextion (=1) and set group keep together as whole group, but still have problem. Am I doing something wrong?? The three fields are in the same section with its keep together as yes but it does not. Help "Marshall Barton" wrote in message ... Derek Brown wrote: Well been working on this a while! How do you get subreports to stay together on a page and stop half of a 3 line report starting on one page and finishing on another. I have everything I can see set to keep together but it just ignors me (and laughs) and continues to do exactly what it likes. The three lines are separate fields with one line per field and i am printing a report in two columns A4 landscape. Don't forget that you can only use KeepTogether for a single instance of a single section. This means that the main report section that contains the subreport is where you need to use the KeepTogether property. If the mainreport detail section has a bunch of other stuff before or after the subreport that you don't need to keep together, then use Sorting and Grouping on the detail's primary key field to split the data across three sections. Maybe(??) there's another way that can be done in the subreport. Create a group in the subreport on the expression =1 and set the **groups** KeepTogether property to Whole Group. -- Marsh MVP [MS Access] |
#4
|
|||
|
|||
Keep together subReports
Sorry for the delay, but I am having trouble finding the
time to set up a report to duplicate your situation. I hope to get to it later today or tomorrow. -- Marsh MVP [MS Access] Derek Brown wrote: Tried last suggestion, I have inserted a new group cut and pasted three fields to the new sextion (=1) and set group keep together as whole group, but still have problem. Am I doing something wrong?? The three fields are in the same section with its keep together as yes but it does not. Derek Brown wrote: Well been working on this a while! How do you get subreports to stay together on a page and stop half of a 3 line report starting on one page and finishing on another. I have everything I can see set to keep together but it just ignors me (and laughs) and continues to do exactly what it likes. The three lines are separate fields with one line per field and i am printing a report in two columns A4 landscape. "Marshall Barton" wrote Don't forget that you can only use KeepTogether for a single instance of a single section. This means that the main report section that contains the subreport is where you need to use the KeepTogether property. If the mainreport detail section has a bunch of other stuff before or after the subreport that you don't need to keep together, then use Sorting and Grouping on the detail's primary key field to split the data across three sections. Maybe(??) there's another way that can be done in the subreport. Create a group in the subreport on the expression =1 and set the **groups** KeepTogether property to Whole Group. |
#5
|
|||
|
|||
Keep together subReports
Well, you can scrap that last suggestion and use the first
one. Set the main report detail section's KeepTogether property to Yes. If you only want the subreport to be kept together and don't care about any other stuff in the detail section. Create a main report grouping on a unique field in the main report's record source table/query. Set the Group Header and/or Footer properties to Yes. Then move the other stuff to the header/footer as desired. The subreport will then be the only thing still in the detail section and will stay together. -- Marsh MVP [MS Access] Derek Brown wrote: Tried last suggestion, I have inserted a new group cut and pasted three fields to the new sextion (=1) and set group keep together as whole group, but still have problem. Am I doing something wrong?? The three fields are in the same section with its keep together as yes but it does not. Derek Brown wrote: Well been working on this a while! How do you get subreports to stay together on a page and stop half of a 3 line report starting on one page and finishing on another. I have everything I can see set to keep together but it just ignors me (and laughs) and continues to do exactly what it likes. The three lines are separate fields with one line per field and i am printing a report in two columns A4 landscape. "Marshall Barton" wrote Don't forget that you can only use KeepTogether for a single instance of a single section. This means that the main report section that contains the subreport is where you need to use the KeepTogether property. If the mainreport detail section has a bunch of other stuff before or after the subreport that you don't need to keep together, then use Sorting and Grouping on the detail's primary key field to split the data across three sections. Maybe(??) there's another way that can be done in the subreport. Create a group in the subreport on the expression =1 and set the **groups** KeepTogether property to Whole Group. |
#6
|
|||
|
|||
Keep together subReports
thank you Marshall
"Marshall Barton" wrote in message ... Well, you can scrap that last suggestion and use the first one. Set the main report detail section's KeepTogether property to Yes. If you only want the subreport to be kept together and don't care about any other stuff in the detail section. Create a main report grouping on a unique field in the main report's record source table/query. Set the Group Header and/or Footer properties to Yes. Then move the other stuff to the header/footer as desired. The subreport will then be the only thing still in the detail section and will stay together. -- Marsh MVP [MS Access] Derek Brown wrote: Tried last suggestion, I have inserted a new group cut and pasted three fields to the new sextion (=1) and set group keep together as whole group, but still have problem. Am I doing something wrong?? The three fields are in the same section with its keep together as yes but it does not. Derek Brown wrote: Well been working on this a while! How do you get subreports to stay together on a page and stop half of a 3 line report starting on one page and finishing on another. I have everything I can see set to keep together but it just ignors me (and laughs) and continues to do exactly what it likes. The three lines are separate fields with one line per field and i am printing a report in two columns A4 landscape. "Marshall Barton" wrote Don't forget that you can only use KeepTogether for a single instance of a single section. This means that the main report section that contains the subreport is where you need to use the KeepTogether property. If the mainreport detail section has a bunch of other stuff before or after the subreport that you don't need to keep together, then use Sorting and Grouping on the detail's primary key field to split the data across three sections. Maybe(??) there's another way that can be done in the subreport. Create a group in the subreport on the expression =1 and set the **groups** KeepTogether property to Whole Group. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
calling subreports in subreports | ramadevi k via AccessMonster.com | Setting Up & Running Reports | 6 | March 25th, 2005 06:04 AM |
calling subreports in subreports | ramadevi k via AccessMonster.com | Setting Up & Running Reports | 0 | March 24th, 2005 04:45 AM |
Displaying subreports with more than one record | franciscan | Setting Up & Running Reports | 10 | March 17th, 2005 09:31 PM |
header of main report and detail (subreports) splitting | jenn | Setting Up & Running Reports | 0 | December 30th, 2004 04:40 PM |
Opening Subreports with dates | Don Sealer | Using Forms | 1 | December 28th, 2004 02:19 AM |