I'm using CR 2016 for SAGE. The report I'm using can take up to 7 minutes to print. I chatted with another CR expert recently who said the more tables I add, the slower it'll print and that I needed to move all the fields to a work table, which I did.

I placed all the fields that are used in the report in the report header b so I can see if the data is coming to the report ok and it is. The issue is that none of the formulas involving any of those fields work. It's like there is not data there, but I can see it in the header.

Here's an example:

The header displays
{PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} as "PLY"

In this case:
{PM_WorkTicketWrk.UDF_SHIP_LOC1} = PLY
{PM_WorkTicketWrk.UDF_SHIP_PALLET1} = ISPM28X36

Here's the formula (it's in the group header 2a section):
if {PM_WorkTicketWrk.UDF_SHIP_LOC1} = {PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} then {PM_WorkTicketWrk.UDF_SHIP_PALLET1}
else if {PM_WorkTicketWrk.UDF_SHIP_LOC2} = {PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} then {PM_WorkTicketWrk.UDF_SHIP_PALLET2}
else if {PM_WorkTicketWrk.UDF_SHIP_LOC3} = {PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} then {PM_WorkTicketWrk.UDF_SHIP_PALLET3}
else if {PM_WorkTicketWrk.UDF_SHIP_LOC4} = {PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} then {PM_WorkTicketWrk.UDF_SHIP_PALLET4}
else if {PM_WorkTicketWrk.UDF_SHIP_LOC5} = {PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} then {PM_WorkTicketWrk.UDF_SHIP_PALLET5}
else if {PM_WorkTicketWrk.UDF_SHIP_LOC6} = {PM_WorkTicketWrk.UDF_LINE_SHIP_TO_CODE} then {PM_WorkTicketWrk.UDF_SHIP_PALLET6}
else ""


I won't bore you with the other 6 values since the formula should generate a value of ISPM28X36 since it matches in the first if statement.

I put the fields {PM_WorkTicketWrk.UDF_SHIP_LOC1},
{PM_WorkTicketWrk.UDF_SHIP_PALLET1} in the same report section as the formula is in and it doesn't display that either.

The report is very technical and I don't want to re-create it. We print multiple times a day and at 7 minutes per instance it gets aggravating.

I'd appreciate any help! Thank you!