I am trying to add a filter in a report so if in the item table - blocked or inactive is 1 then it will not show in the report.
can i do this with the table filters, if so how. I am pretty green to nav reports, I usually program my reports in sql
View the properties of the Item DataItem line when designing the report. Use the edit button (the … button) on the DataItemTableView property and set your filters from there.