Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: SAGE WrkTable formulas not working Post Reply Post New Topic
Author Message
jlindquist23
Newbie
Newbie
Avatar

Joined: 06 Jun 2019
Location: United States
Online Status: Offline
Posts: 4
Quote jlindquist23 Replybullet Topic: SAGE WrkTable formulas not working
    Posted: 23 Feb 2024 at 9:11am
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!
Thanks,
Jennifer
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.