Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The last detail (redux)
Message
De
10/02/2017 18:06:43
 
 
À
10/02/2017 14:43:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2016
Network:
Windows Server 2016
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01647847
Message ID:
01647849
Vues:
69
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform