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!