Hello Budianto


Sometimes if I get stuck trying make a report behave the way I want I can often fix the report by using the little function below which I store in my procedure library. In your case another data grouping is probably needed to trigger the new page you require.

FUNC execute
PARAM xcmnd
&xcmnd
RETURN ''

Using this function you can embed a very flexible counter anywhere you like on the report including your detail lines.
eg.

EXECUTE('giMyCounter=giMyCounter+1')

You can have a phantom data grouping that starts a new page whenever the data grouping changes so a new page can be triggered by something like.

EXECUTE('giMyGroup=IIF(giMyCounter=40,giMyGroup+1,giMyGroup)')

in certain rare circumstances an EXECUTE('eject') can be used


VFP report writer also has the ability to run functions on entering and exiting each detail line, however EXECUTE() is more flexible as it can be used all over the report.


Hope some of this helps




>Hi all,
>
>Did anybody know how to determine the amount of rows in a page when using data grouping, so when the records has exceed the limit it will go to the next page ?
>
>
>Budianto M.
>-----------