Wednesday, March 7, 2012

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

No comments:

Post a Comment