Crystal Report: how to detect if two section are on same page?

Question

i have reporting layout problem in Crystal Report. the user have required that the two sections be in one page, and those two sections should have enough space in between them. so i put a new section in between them, around half inch. the problem is when the first section occupied the whole space of first page, then the second section will have that in-between section(the one that facilitates the half inch spacing) before it. they don't want the extra space on top of second page

my idea is to create a suppress formula for that in-between section:

pagenumber(first_section) <> pagenumber(second_section)

is there a function which could aid this conditional suppression?

Answer 1

You could put a formula field in the section header containing something like:

shared numbervar sectionOnePageNum := PageNumber;

Then, make a suppress formula for the blank section like:

shared numbervar sectionOnePageNum;
PageNumber <> sectionOnePageNum;

That might work.