Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The last detail (redux)
Message
From
10/02/2017 14:43:56
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
The last detail (redux)
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:
01647847
Views:
91
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
Next
Reply
Map
View

Click here to load this message in the networking platform