Reporting Services report with three tables

Normajm

Hi all,

I'm attempting to create a report based on the assembly order header, assembly order lines and the comment line table. The assembly order header is the top table, assembly lines is indented with standard link between the two tables, comment lines is at the same indent level as assembly lines and is linked to the assembly header table based on the item no. (No. = Item No.) The comment line table is prefiltered to table: Item and Line no. 10100. I placed the Comment field in the report. I would like the comment on line 10100 for the item to show up on the report, but it doesn't.

What step in the report setup am I missing?

Thank you,
JNM

Normajm

I figured it out. The structure was fine.
I needed to use this expression:
=Last(Fields!Comment.Value, "DataSet_Result")
not =Fields!Comment.Value or =First(Fields!Comment.Value, "DataSet_Result")

archer89

indent comment line dataitem 1 grade to the right. then try again.

Normajm

That didn't work -
A ')' is missing in TransferFormulaData. No.=Field(Item No.) Basically, I can't link the Comment Line to Assembly Lines because there is no relationship. The Assembly Lines table doesn't have the "Parent No." field.

Normajm

I figured it out. The structure was fine.
I needed to use this expression:
=Last(Fields!Comment.Value, "DataSet_Result")
not =Fields!Comment.Value or =First(Fields!Comment.Value, "DataSet_Result")