Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report
Message
De
27/08/2008 23:43:49
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brésil
 
 
À
27/08/2008 22:37:37
Muthu Vel
Sty Company
Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Re: Report
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01342441
Message ID:
01342449
Vues:
29
Hi Muthu!

>I have create a report "Bank wise report.FRX" in Report Designer.
>
>I want to print 30 Records in Every pages and after every Five records leave one line space and Print.
>
>Kindly give me reply?

One way:
- Create a variable (named r_countRecno) in report to count the records (Calculation Type = Count and Reset Value Base on = Page). (menu: "Report | Variables...").
- Create other variable (named r_group) to count the 30 records for each page. Thus: Value to Store = Iif(Mod(r_countRecno, 30) = 0, 1, 0) and Calculation Type = Sum.
- Create a group and put r_group in "Group on".
- In detail band, create your line with yours datas. Put the controls like label and field.
- In detail band, put a field that occupy one line and in "Print When" (field's property), check "Remove line if blank" and put IIFMod(r_countRecno, 5) = 0, "A", "") in "Expression". Set the field's color to White.
Good luck!
P.S.: Sorry my bad English.
Erick
Força Sempre!
Strength Always!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform