I only need to add a field to an SSRS report once in a blue moon so it seems I am always relearning the needed steps. For the Material Transaction Detail report I need to add the EntryPerson. In the RDD maintenance it is an excluded field so I have cleared the check marks on a new definition and referenced this in the new report style. But in SSRS Report Builder I don’t see the new field. In RB under the DataSet Properties for PartTran I added EntryPerson. Now I can add that field OK but when I run the new report style it contains no data although a quick BAQ shows names for all the transactions.
I feel that I am missing a step somewhere - possibly in a query but I can’t recall where to do this. I have a vague memory of a non-intuitive way to access the query code. Any hints?
Thanks,
Todd Caughey
Best answer by dan.ramirez
View original