I’ve found one way to do this is to have the FSCompany_c field hidden in the detail section. That way you don’t have to use the First function.
Then in the header you can use ReportItems!HiddenFSCompany.Value to do the logo.
Unfortunately in one field in the header you can’t reference more than one ReportItems value. So you may have to put that logic in the hidden field if possible.
This is a problem I hate about with certain reports - like ARForm.
When you print multiple invoices it’s still just one report. These types shouldn’t use Headers or footers, as they’d be limited to using fields like: report params, First(…), or built-in values (like page num date, etc…). Headers are practically useless. Their sole advantage is that it can be surpressed on just the first page (or do I have that backwards and that it can be surpressed on non-first pages?)
I thought that Epicor added this to the standard functionality. Now maybe you’re running multiple companies in a single Epicor company but in Report Style Maintenance, there is a place to to place conditional images based on company. I’ve never used it and not sure which release it started.
Not sure about that. Interesting. I’ll have to check it out. But this “company” is really a brand, so they could have invoices with three different logos and contacts in the same invoice group.
I did get it working with Doug’s suggestion of ReportItems.
Using a Hidden row works some of the time. If you have a subreport that spans more than one page the hidden row will not be updated and your fields will be blank.
Using the Code snippets is the best way to handle ARInvoice Header references.
What I wound up doing (thanks to Kent Reardon) was to create a new parent group on InvoiceNum (above the name and address) that will show on every sheet. Then changed the groups so the invoice will break and reset the page number on the new group.
I didn’t hide the row, but made the text boxes very short and set them not to grow.