Sub-summeries with continuing Label

[Tissot]

Hi,

I'm working on a report with 2 Sub-summaries and a Body. I need to get FM to reprint the Label after each page break and add „continued“.

Eg.

USA

Los Angeles

Joe Miller

Joe Miller

Joe Miller

Joe Miller

Joe Miller

Joe Miller

(Page brake)

Los Angeles continued

Joe Miller

Joe Miller

Joe Miller

Joe Miller

Joe Miller

NC

Joe Miller

Joe Miller

Joe Miller

Your help would greatly be appreciated.

If a demo file is required, please let me know.

Regards

Edited May 30, 2007 by Guest

[comment]

Try an unstored calculation field (result is Text) =

Case (

City = GetNthRecord ( City ; Get ( RecordNumber ) - 1 ) ;

City & " continued"

)

Put this field in the Header part.

[Tissot]

Thanks Comment,

thats awesome. Works great. Except its got a gap there now. can I some how get it together?

Regards

[comment]

Not sure what you mean by 'gap'. Try to elaborate - perhaps attach a demo file.

[Tissot]

Sorry..

I mean where there is no "continued" there is a Gap now. I've got info like company name, dates etc. in the header and now there is a gap underneath all that info before the sub-summary.

Regards

[comment]

OK, I see (I think). Unfortunately, you cannot shrink a header part.

I would suggest you find a 'creative' solution for this, i.e change your design to make it look good. I wouldn't try to imitate a sub-summary - just add a note that the current part is continued.

Because the next alternative is very labor-intensive to set up, slow to execute, and may not work at all in some circumstances.

[Tissot]

"Alternative" You mean with a BIG Script? (I think I've got you -)

Thanks!

[comment]

Yes, I meant something along the lines described here and here.

But if you happen to also have trailing sub-summaries, I don't think it would work well.