Loosing data in Group Footer 3 1

[MSBrady]

Oy!
CR 10
SQL Server 2005

Summary:
I have an Estimate report that drops data at a certain unknown threshhold.

Setup:
We have Projects and Functions w/in those Projects.
The RH is Suppressed, PH has 2.5" of data describing the Project, the RF is Suppressed, RF has 2" of data. There are 3 Groups. GH 1 contains a subreport called ProjectNotes which contains notes describing the Project. GH 2 contains 1 row of descriptive headers describing the Function Codes. GH 3 is Suppressed. Details are Suppressed. GF 3 contains the data fields that GH 2 describe plus a subreport call TaskNotes. GF 2 contains totals. GF 1 is Suppressed.
GF 3 contains Function Codes. The TaskNotes subreport contains the notes that are tied to a given Function Code.

Expected behavior:
All notes from TaskNotes subreport should print. If there are a lot of notes they should span pages.

Current behavior:
If the actual Function notes that the subreport contain reach an unknown height they aren't printed. It's like they are consumed by the Page Footer. As soon as the height of the notes falls under or goes beyond the threshhold they are printed.

Example:
(Header data)

Function Description Previous Amount Current Amount
12345 widgets $45.00 $55.00
(notes) This is an order for widgets

67890 gadgets $55.00 $35.00
(notes) Customer needs more gadgets than widgets and therefore has altered the order to reflect the desired change and we have changed the order b/c we like the customer and have bills to pay.

(Footer data)

Current Behavior:
The 67890 line will print, but the notes will not until I shrink them or expand them.

67890 gadgets $55.00 $35.00
(notes) Changed order

OR

67890 gadgets $55.00 $35.00
(notes) Customer needs more gadgets than widgets and therefore has altered the order to reflect the desired change and we have changed the order b/c we like the customer and have bills to pay. For example the lights, the water, the employees, the this, the that.

Please help.

 

[lbass]

Make sure that the subreport containing the notes is formatted to "can grow" on the common tab. Also check to make sure the notes field within the sub is formatted to "can grow". If this doesn't solve the problem, please select the subreport->format subreport->common tab and see whether "keep object together" is checked or not. See if changing that changs the behavior.

-LB

 

[MSBrady]

Can Grow was checked in both places. In looking at Keep Object Together, when I de-select this (it was selected) rather than losing the last couple inches of notes, I only lose 3 lines and the last line does print on the second page. So it helped but I still lost 3 lines from the last Function on the page. I added the following to the notes of the Function:

More...More...More
There weren't quite enough notes in the last entry so I need more.
Still not enough the force the page to scroll to the next item thing

More notes....


The "More...More...More" and "More notes...." lines print, the other do not. "More...More...More" is the last line of notes on the first page, "More notes...." prints on the 2nd page.

Previously none of those lines printed b/c they spanned the next page.

 

[lbass]

You could also try unchecking "keep together" on the group footer section.

It almost sounds like the report might be corrupted. You might want to check to see if the behavior is replicated in a new report.

-LB

 

[MSBrady]

I have tried all possible combinations of the Keep Together flag. I also thought that the report might be corrupt and so I recreated it from scratch and it still exhibits the same behavior. It's almost like a bug; if the height of the page header plus the height of the page footer plus the height of the contents of the group headers and footers equals n then bug. I have tried also setting up a few formulas to count the number of lines in the headers plus the number of lines in the notes and if it reaches 29, for example, then do a New Page After. I'm testing that now, but it doesn't seem to be working.

 

[lbass]

This is difficult to troubleshoot from here. Did you also check whether you had formatted the relevant group in report->group expert->options->keep group together. You might want to uncheck that.

Also remove any settings for "repeat group header on each page".

Also have you verified that you don't have "underlay following sections" set for any of the sections?

-LB

 

[MSBrady]

Thanks for your help LB. The workaround ended up being to unsuppress GF1 and place an empty text box in it. I'm still not convinced there isn't something else wrong but the text is now wrapping as expected whether I increase the function level notes or the project level notes.
BTW - thanks for the "repeat group header on each page" info. I didn't know where to find that and will help me out on other projects.