Suppressing First Record on Each Page 1

[hoagieryder]

I am going to simplify my problem so its easier to understand...

I have details section a and b. My section A is just a solid horizontal line, my section b is a record. I am trying to suppress the solid line unless its first record on the page and fieldA = "first".

I have created:
@counter (to be placed in details section b)
whileprintingrecords;
shared numbervar counter :=counter +1;

and

@counter_reset (to be placed in page footer)
whileprintingrecords;
shared numbervar counter := 0

When I add those formula,s the counter seems to be working correctly. However when I add the following formula to the suppression x-2 next to details section A, it does not work and the 1st number in the counter on the 2nd page is null.

counter > 1 or fieldA <>"first"

Any idea what I am doing wrong?

 

[hoagieryder]

Yea, that is what I was afraid of. I can't do that because the fields can grow so it would not look consistent. Either way, thanks for the help!

 

[lbass]

Well, if the rule has to do with the current record and the next, if you set it up correctly, you can control the line on the bottom of the page, using the next(). I just can't reproduce your dataset to show you how.

-LB

 

[hoagieryder]

I just don't understand how it could work with just the next function. I am currently using the next function in my suppression formula. If this report were on one continuous page it would work perfectly. If I don't know the last record of the page, what is stopping the suppression formula from putting a Db record if there is room for it?