DataLine Filter by Page?

English Forum
1

I am using version 21:

I did try and search the forum but I couldn’t find the answer to this.

I can’t seem to figure out how to restrict an individual dataLine to only appear once per page

I’m looking for some kind of function that is the pseudocode equivalent of PrintOncePerPage

Thank you

2

Hi CombitUser,

does it have to be a data line or can you use a header or footer line for this request? A header or footer line will be printed only once per page, hence my question.

If it has to be a data line, could you describe a little bit more detailed, why this line only needs to be printed once? Are there other objects after this data line, that are supposed to be printed on the same page? Also is the value supposed to change per page, for example with your data line → page 1 = value 1, page 2 = value 2?

With kind regards,

Leon

3

Thank you for your reply.

Unfortunately,

In this case, I cannot use a header or a footer due to the table structure which is generated via a complex set of unions driven by VBA

I could possibly duplicate the table then filter out all but the desired info and then put that duplicate in a header.

Or conversely, edit the VBA code to put a FirstRecord Yes/No toggle into the table.

I had hoped there might be a native Combit function such as FirstRecordOnPage or something like that already existed.

4

You could use the condition LL.FCountPrintedDataThisPage=1. It might be necessary to use 0 instead, though; unfortunately, I can’t verify it at the moment since I’m using my mobile. :slightly_smiling_face: