By using this website, you agree to our Terms of Use (click here)
I have added 2 attributes to a production order. I want to print these on the production order ticket report AM625000.
I added AMProdAttribute to the report with the following relationship.

I then added 2 new Text Boxes to the report with the following values:
=IIf( [AMProdAttribute.AttributeID]='STARTCASE', [AMProdAttribute.Value], '' )
the second box has this value
=IIf( [AMProdAttribute.AttributeID]='ENDCASE', [AMProdAttribute.Value], '' )
The first box prints as desired, but the second does not print anything.

Here are the only records in AMProdAttribute:

Any suggestions are greatly appreciated!!!!!
STARTCASE and ENDCASE are from different records. At the point you are printing them on the report, both records can't be active at the same time. I think you need to save the data in variables and print the variables in the report.
Actually the better approach would be to join AMProdAttribute twice, one for each Attribute ID. In the join conditions, and the criteria for AttributeID value - then you will only have one record per Production Nbr. With your current approach you are duplicating data for Production Nbrs due to the multiple Attribute ID values - this just makes things difficult.
Thanks for the reply Royce.
I got around this by making an attribute with a format of xxxx-xxxx. The first 4 characters are the starting number and the second four numbers are the second number.
Sincerely, thank you for taking the time to respond and what you said makes sense.