I just did a project for a client who has an accounting package that uses Crystal Reports. He was having problems with orphaned footers. Much to my surprise, it seems that this is a common problem with Crystal Reports. It was easy to find forums where people were wrestling with this issue. Folks were discussing all kinds of different solutions, but I didn’t see any mention of putting a simple BASIC statement in the ‘Page Before’ event of the Detail section to limit the number of rows:
shared numbervar nRow;
if (nRow < 30) then
(nRow := nRow + 1;
false)
else
(nRow := 0;
true)
It seems to work pretty well. I have to say, though, that I don’t regret not having used Crystal Reports for several years. It’s pretty clunky.
Leave a Reply