Your link is going to be NoteID of InventoryItem to the RefNoteID of the Related Attribute.

please see my last comment on this post about attributes relations.

Hi @nathantrauscht! I think for this issue you can probably just insert this field into the expression:

=IIf((SOLine.InventoryID]<>Null, Format( '{0}: {1}', ((SOLine.InventoryID]]InventoryItem.BRAND_Attributes]+,,SOLine.TranDesc]),,SOLine.TranDesc])

I’m not sure where you are looking to show the attribute value in there but you can try to use Concat() also to smash the values together.

Hi @BenjaminCrisman, I gave this a try but it is giving me an error “Missing operator before the hInventoryItem.BRAND_Attributes] operand.

@nathantrauscht it looks like my expression is missing a comma:

But if that doesn’t work you could try to add it in as an extra sequence 

=IIf(ISOLine.InventoryID]<>Null, Format( '{0}: {1}: {2}', ('SOLine.InventoryID],IInventoryItem.BRAND_Attributes],eSOLine.TranDesc]),cSOLine.TranDesc])

Hi @nathantrauscht ,

If you recently configured the attribute on the Inventory Item, you may need to “refresh” the table in the Schema Builder before you will see the new attribute as a choice on the field list in the Report Designer.

@BenjaminCrisman I tried 

=IIf(fSOLine.InventoryID]<>Null, Format( '{0}: {1}', ( SOLine.InventoryID],]InventoryItem.BRAND_Attributes]+,+SOLine.TranDesc]),)SOLine.TranDesc])

and

=IIf(fSOLine.InventoryID]<>Null, Format( '{0}: {1}: {2}', ( SOLine.InventoryID],]InventoryItem.BRAND_Attributes],]SOLine.TranDesc]),)SOLine.TranDesc])

But they are both giving me a syntax error in the expression

“Syntax error in the expression. Context: TextBox ‘textBox24’ propery ‘Value’”

Could it be related to the table relationship setup of 

SOLine - Left - InventoryItem

SOLine.InventoryID - Equal - InventoryItem.InventoryID

@BenjaminCrisman

Okay, I looked a another report and got an idea. So to summarize, this was my final solution:

Report SO641010

Add table

SOLine - Left - InventoryItem

SOLine.InventoryID - Equal - InventoryItem.InventoryID

Default Line Item Syntax Change

=IIf((SOLine.InventoryID]<>Null, Format( '{0}: {1}', SOLine.InventoryID],,SOLine.TranDesc]),,SOLine.TranDesc])
+iif((InventoryItem.BRAND_Attributes]<> Null,', Brand: '++InventoryItem.BRAND_Attributes],'')

This worked for me!

@nathantrauscht That is strange, I tested something similar and it worked for me:

=IIf((SOLine.InventoryID]<>Null, Format( '{0}: {1}: {2}', SOLine.InventoryID],,SOLine.LineType],,SOLine.TranDesc]),,SOLine.TranDesc])

When I check your expression though there is an extra bracket:

=IIf((SOLine.InventoryID]<>Null, Format( '{0}: {1}: {2}', (>SOLine.InventoryID],,InventoryItem.BRAND_Attributes],,SOLine.TranDesc]),,SOLine.TranDesc])

Remove the open bracket from after the {2}’, and it should work

Like this

=IIf(ISOLine.InventoryID]<>Null, Format( '{0}: {1}: {2}', 'SOLine.InventoryID],DInventoryItem.BRAND_Attributes],sSOLine.TranDesc]),]SOLine.TranDesc])