We have modified our MtlTag report to function as our non-conformance tag.
We are trying to create a similar tag for printing inspections on receipts. The data we are looking for is
packslip / line / rel / dmr if one already exists. Originally we linked parttran to the nonconf on company = company and tranid = nonconftranid. This will only populate the data if a non-conformance already exists.
We also tried to pull in a preexisting data set within the MtlTag report called MtlQueue. This dataset lists Packslip / packline / etc. The problem is anytime we try to reference it within the report we get an error with the preexisting groups on the report. If we attempt to create a new tablix and a group for it to see if there is any data within this dataset it also errors out and the report refuses to run.
I would like to hear if there is a way to pull the data we require into the report without a preexisting non-conformance.
Is there another table reference/relationship we can use to bring this data in?
If your first goal is to test if the dataset has data, I’d suggest picking a report retention (archive period) of at least a day and then looking in SSMS at the report database (by guid).
If I had a guess, there is probably a table name conflict - i.e using the same table more than once in the report. If so, I wonder if you could use table aliases to get around it.
@dgreenEA Another way to go after this is in this link. We use this to add other information to the comment and print it on the tag. They added a few fields in 11.1 You could probably also fill it and then parse it in SSRS. @Chris_Conn may not remember but once upon a time he helped me get the nonconformance id on that tag.
