Next page after 10 details 2

[mimiotoko]

Hi,
after writing 10 details my report has to change to the next page. Now I need a formula to do this in area-assistant. I can't handle it with my layout. The only way is to use a formula. It's urgent. Who has a tip?

regards Rainer

 

[MJRBIM]

Insert the following Formulas in the sections as defined.

PAGE HEADER[/blue]

Name : {@SetRecordCountZero}
Formula : WhilePrintingRecords;
numberVar RecordCount := 0;

DETAIL[/blue]

Name : {@AddRecordCount}
Formula : WhilePrintingRecords;
numberVar RecordCount;
RecordCount:= RecordCount + 1;

PAGE FOOTER[/blue]

Name : {@DisplayRecordCount}
Formula : WhilePrintingRecords;
numberVar RecordCount := RecordCount;

Use the Section Expert to conditionaly set "New Page After" on the DETAIL[/blue] section where -

{@AddRecordCount} = 10

Hope it Helps...

 

[mimiotoko]

I've got the answer by myself.

I inserted an summary field with a count-number. The fomrmular in the area-assistant is:

(@summary) in [10,20,30...]

regards
Rainer

 

[bdreed35]

A nice way for your formula to work without have to list every possible option would be to change something like this:

{@summary} Mod 10 = 0

This basically says that if the remainder of @Summary divided by 10 equals 0, then force a new page. May not be a big deal if you have only 30 or 40 pages, but if you have hundreds, it makes life easier.

~Brian

 

[mimiotoko]

thanks, but my User only needs about 2 pages. So I use the other way.

best regards
Rainer