SSRS Report Data Def Missing Exclusion Fields - HELP

[jorel (Jakob Orel)]

Here are some screenshots of where you will need to edit the RDL dataset query in Report Builder:

Follow the syntax in the dataset already to get the field from the table you would like.
Then, you will have to add it in as a query field:

This post has some more info about editing MtlTag.

Modifying Mtltags Report - Add DMR number

@Tev @dustin.perkins See if this helps: (I tried for 2 whole days to make the standard RDD work with this report and nothing would work since its a temporary dataset so no matter how I joined with tables and relationships it would never work.) Modify your MtlTag Dataset in the SSRS report based on the last field in the query below with the (select statement) and try it. I recently modified my MtlTag while working on an autoprint method to include the Material Queue Sequence id in relation to th…

Like @gpayne said, make sure you create duplicate/new RDD and RDLs as to not affect other areas that use this MtlTag dataset.