Showing posts with label area. Show all posts
Showing posts with label area. Show all posts

Wednesday, March 7, 2012

keep together table groups

Hi.
I have a table containing two groups and a detail area.In the preview tab ,on some pages the second group and the detail area splits to different pages.I want them to be always on the same page.How can I do that?I don't know of an explicit way of keeping them together. However bear in mind that paging in the preview tab and the web will probably be different to exported or printed reports. You can try to control the paging by forcing a page break in the group properties tab.|||

Hi,

Did you have any luck with this. I have many reports that I need to keep the groupings together, but have yet to find the solution. Thanks.

|||Thanks Adam.
But if I use a page break in the group properties, there will be one group per page.And this is not a thing I want.|||

This is amazing to me also.

I've used Crystal Reports and Visual FoxPro's report writer, and both have simple checkboxes to "Keep Together" that you can set for any group.

I haven't tried it yet, but what I'm wondering is if there's a way to use a subreport (or a table inside a table row?) because you can apparently set a table to keep together...

Somebody please post if you've found a way...

Thanks.

keep together table groups

Hi.
I have a table containing two groups and a detail area.In the preview tab ,on some pages the second group and the detail area splits to different pages.I want them to be always on the same page.How can I do that?
I don't know of an explicit way of keeping them together. However bear in mind that paging in the preview tab and the web will probably be different to exported or printed reports. You can try to control the paging by forcing a page break in the group properties tab.|||

Hi,

Did you have any luck with this. I have many reports that I need to keep the groupings together, but have yet to find the solution. Thanks.

|||Thanks Adam.
But if I use a page break in the group properties, there will be one group per page.And this is not a thing I want.
|||

This is amazing to me also.

I've used Crystal Reports and Visual FoxPro's report writer, and both have simple checkboxes to "Keep Together" that you can set for any group.

I haven't tried it yet, but what I'm wondering is if there's a way to use a subreport (or a table inside a table row?) because you can apparently set a table to keep together...

Somebody please post if you've found a way...

Thanks.

keep together

Hi. I have two groups and a detail row in a table.First is ProductGroup, second is ProductSubgroup and the detail area's name is ProductName.
My problem is that I want to keep the detail and the ProductSubgroup (second group area) together.For example sometimes ProductSubgroup is written at the end of the page and the detail area is on the next page or the ProductGroup (first group area) is written at the end of page and the ProductSubgroup (second group area) is written on the next page.And I don't want this.But for example the ProductSubgroup area contains too many detail rows and this time I want to split the records two pages.I hope you help me.Thanks!There are a couple way that you can mitigate this issue--at least part of it--of table groups being split across pages.

The first way is to use nested Lists, where

the inner list is set to be kept together on the same page, if

possible. Unlike Tables where only the Table itself can be set to be kept together, each of the nested lists can be set to be kept together. This is a checkbox at the bottom of the general tab of the

List properties dialog in the ReportDesigner.

The second potential resolution would be

enable RepeatGroupHeaders and/or footers, so that at

least the continuation of the group on subsequent pages will contain the header and/or

footer on all pages the group spans. This is a checkbox at bottom of the

general tab of the Grouping and Sorting property dialog.|||

Hi Ian,

What would be the overhead in terms of performance for processing the nested lists ?

I tried adding a nested table for a similar issue and the performance overhead was about 10mSec for processing a report that contained that had about 44 Rows (rows returned by the query). I got this figures using the Report Execution Log.

Regards,

Ashish

keep together

Hi. I have two groups and a detail row in a table.First is ProductGroup, second is ProductSubgroup and the detail area's name is ProductName.
My problem is that I want to keep the detail and the ProductSubgroup (second group area) together.For example sometimes ProductSubgroup is written at the end of the page and the detail area is on the next page or the ProductGroup (first group area) is written at the end of page and the ProductSubgroup (second group area) is written on the next page.And I don't want this.But for example the ProductSubgroup area contains too many detail rows and this time I want to split the records two pages.I hope you help me.Thanks!There are a couple way that you can mitigate this issue--at least part of it--of table groups being split across pages.

The first way is to use nested Lists, where

the inner list is set to be kept together on the same page, if

possible. Unlike Tables where only the Table itself can be set to be kept together, each of the nested lists can be set to be kept together. This is a checkbox at the bottom of the general tab of the

List properties dialog in the ReportDesigner.

The second potential resolution would be

enable RepeatGroupHeaders and/or footers, so that at

least the continuation of the group on subsequent pages will contain the header and/or

footer on all pages the group spans. This is a checkbox at bottom of the

general tab of the Grouping and Sorting property dialog.|||

Hi Ian,

What would be the overhead in terms of performance for processing the nested lists ?

I tried adding a nested table for a similar issue and the performance overhead was about 10mSec for processing a report that contained that had about 44 Rows (rows returned by the query). I got this figures using the Report Execution Log.

Regards,

Ashish