Field to repeat on each page of invoice report header

[mlp]

Hello~!

I am having an issue…

I successfully, thanks to the help of the people of this forum, pulled in CustID and attached it to ARForm invoice. But I am being asked to have it repeat on every page, as if it were part of the header. When I put it in the header, it works UNTIL accounts receivable goes to print a group of invoices. Then it just provides the first Customer ID on every page. The invoice number changes, but not the CustID.

How can I get it to repeat every page toward the top with the correct CustID corresponding to its proper invoice number? I don’t care if it’s in the header or in the table in the body, but it needs to be at least “header like”.

I’ve tried building it into the Company query, various expressions, repeating the column in the table, etc. Nothing is working.

Thank you.

[Randy (Randy Stulce)]

I’d be it into the SoldTo section

[mlp]

I thought about that, but if the invoice is longer than one page, my AR team wants to see it on top of that page too.

[mlp]

Like here with the invoice # repeating on each page:

[Randy (Randy Stulce)]

@mlp

my AR team wants

Tell your AR team it’s good to have wants but they may not always been fulfilled.

Look at the code required to get the Invoice Number to print up there. You may be able to copy and modify it to get it to work.

[JMPCONJ (John Magee)]

@Randy

Tell your AR team it’s good to have wants but they may not always been fulfilled.

Yeah, that usually works out well when they run to management and pull one of these

[mlp]

Haha. I told them I’d try my hardest!

I did try to do that. By default it’s:

=Code.GetValue("RptLiteralsLInvoice") & ChrW(160) & Code.GetValue("varInvoiceNum")

But fiddling with that using CustID did not work. I am not sure what/where it’s referencing when it says Code.GetValue, or where var comes into play. I am very much a newb with coding, even just SQL. ChatGPT gives me ideas but I can’t get the right execution.

Interestingly enough, I am able to have it differentiate between whether or not it’s a credit memo… this works:

=iif(CBool(code.GetValue("boolCreditMemo")) = True, Code.GetValue("Label_Calc_CreditMemo"), "")

[mlp]

Additionally, they were able to do it on the Crystal report version.

[Randy (Randy Stulce)]

Crystal Reports work totally differently than SSRS. Generally what is possible in one can be done in the other but it’s not always as easy.

The field code is calling code in the Report Properties so you’ll need to make your own public functions. Also there is a hidden field setting the value that the “Get” pulls