I created an SSRS report that combines previously counted tags with current tags for Cycle Count. It’s designed for Recount use where you can see previous counts displayed on the same sheet as the recount tags that need to be filled out. It combines all locations as well onto this one combined variance sheet. Effectively, it combines the Variance Report with the Count Tag.
The problem I am running into is that my previously counted tags run on a direct SQL query in my SSRS Report. For whatever reason, blank tags (tags that were manually written in… BlankTag = true but PartNum != “”) do not get returned in my SSRS report. I copy/paste that query into SSMS and run the query and I get all the results I’d expect. Is there anything you can think of that might cause the SQL to behave differently when run through SSRS report?
I’ve troubleshot by checking any filters on the dataset, the grouping, the grid and haven’t found anything. There are no visibility rules on the rows in the tablix. Any other thoughts? Any other way I can accomplish this from a subreport within my PrintTag report?
SELECT T1.BinNum
,T1.BlankTag
,T1.PartNum
,T1.SerialNumber
,T1.TagNum
,T1.Plant
,T1.CountedQty
,T1.CountedBy
,T1.TagNote
,T1.EntryPerson
,T1.FrozenQOH
,T2.Aisle
,T3.ZoneDesc
,T4.PartDescription
,T4.IUM
FROM Erp.CCTag T1
LEFT OUTER JOIN Erp.WhseBin T2 ON T1.Company = T2.Company AND T1.WarehouseCode = T2.WarehouseCode AND T1.BinNum = T2.BinNum
LEFT OUTER JOIN Erp.WhseZone T3 ON T2.Company = T3.Company AND T2.WarehouseCode = T3.WarehouseCode AND T2.ZoneID = T3.ZoneID
LEFT OUTER JOIN Erp.Part T4 ON T1.Company = T4.Company AND T1.PartNum = T4.PartNum
WHERE T1.Company = 'VANAIR' AND T1.Plant = 'North' AND T1.WarehouseCode = 'NMFG' AND T1.CCYear = 2026 AND T1.CCMonth = 1 AND T1.CycleSeq = 1 AND T1.TagStatus = 3