Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report
Message
From
27/08/2008 23:43:49
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
 
 
To
27/08/2008 22:37:37
Muthu Vel
Sty Company
India
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Re: Report
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01342441
Message ID:
01342449
Views:
28
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!
Previous
Reply
Map
View

Click here to load this message in the networking platform