Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The last detail (redux)
Message
From
10/02/2017 18:06:43
 
 
To
10/02/2017 14:43:56
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2016
Network:
Windows Server 2016
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01647847
Message ID:
01647849
Views:
68
>Hi All,
>
>I'm trying to get the report to output a specific no. of lines (20) by using this filter
>expression on the pass-through cursor:
>
>
>set filter to recno()=^((_pageno-1)*20)+1 .and. recno()v=(_pageno*20)
>
>
>placed in the On Entry field of the header (it's actually a call to an external .prg
>because the field won't accept it).
>
>It works fine on the first page, but that's (obviously) as far as it gets. If I place a
>SET FILTER TO statement in the footer, or anywhere else for that matter, it
>fires before the page runs, so I'm back to square one. Where can I place the
>SET FILTER TO statement such that it fires after a given page runs, but before
>the next page runs? Or better still, is there somewhere I can place that expression
>in the report so that it works.
>Thanks.
>
>Luke

Create a data grouping based on the expression INT((RECNO() - 1) / 20) and set the group to start at a new page. Each page will print 20 detail bands.
----------------------------------
António Tavares Lopes
Previous
Reply
Map
View

Click here to load this message in the networking platform