Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 271 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Reporting Services report with three tables
Normajm
Member Posts: 82
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
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
0
Best Answer
-
OptionsNormajm
Member Posts: 82
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")5
Answers
Franz Kalchmair, MVP
Alias: Jonathan Archer
please like / agree / verify my answer, if it was helpful for you. thx.
Blog: http://moxie4nav.wordpress.com/
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.
I needed to use this expression:
=Last(Fields!Comment.Value, "DataSet_Result")
not =Fields!Comment.Value or =First(Fields!Comment.Value, "DataSet_Result")