I have field RowNo in details section of rpt
how can i add blank lines if rowno 1,2 is there and after 2 directly rowno 5 comes from table then there should be 2 blank lines between the next and current record
Printable View
I have field RowNo in details section of rpt
how can i add blank lines if rowno 1,2 is there and after 2 directly rowno 5 comes from table then there should be 2 blank lines between the next and current record
1) Create this Formula
Local numberVar X := 0;
Local stringVar Result := "" ;
For X := {Table.RowNo}+1 To Next({Table.RowNo})-1 DO
Result := Result + chr(13);
Result
2) Add another Detail section and put the formula in this section. Set the Formula's CanGrow option.
3) Suppress this Detail section with this Formula
{Table.RowNo} + 1 = Next ({Table.RowNo})
Thanks a lot brucevde