Below is the expression to export a database in presorted order and only have the endorsement line export for the first record in each package.
You’ll want to put this in the Export setup screen’s expression area next to the field Endorse:
IIF(!EMPTY(traymark_),ALLT(PADL(TRANSFORM(VAL(cont_id)),3," "))+"*"+ALLT(PADL(TRANSFORM(VAL(gpb_id)),3," "))+PADL(ALLT(Endorse),30,"*"),SPACE(40))
Exporting Endorsement for 1st piece in a Package
Moderators: Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Chrissy, Geoff, Vince