By default, only assets in the "Active" state will be displayed in the reports. In the reports themselves, this is indicated with
Where tblAssetCustom.State = 1.
Every state has their own specific code, alternatively you can add tblState and the field tblState.Statename to use the names of the field instead of the number.