RDLC report showing item data and "primary associated file" data (properties).

[Anonymous]

Hi,

Is there a way using RDLC report to build a report showing item properties (Item number, rev and state) and part properties (part number, rev and state or any other prop).
The part properties should come from the Primary Associated File...

In addition, if it's possible to retrive primary file properties, is it possible to hide/show a section of the report based on file Category name value ?

Many thanks

Regards

Xavier

[Markus.Koechl]

Hi Xavier,

default report templates are related to a data set based on FLDR, FILE, ITEM, ITEM BOM, CO, CUSTENT.NAME. 

Your data set is a custom one combining ITEM data and (primary) linked FILE data. Custom programming is required to build this custom data set and push it to a specific report template. Doug Redmond posted a code sample doing this some time ago, that I am still keeping up to date on my sample pages: https://github.com/koechlm/Vault-Sample---Item-BOM-Report-Job.

The last part of your question is the easier one (if I got you right ;)): The training material (AKN: https://knowledge.autodesk.com/community/article/196571) Exercise 1, Step 6, instructs how to build expandable groups by category.