The Table which helps to get to know the Data Targets available for Reporting:
Table Name: RSSTATMANPART
Status: @0A@ (This is to Denote request status which is in red)
Executing with the above selections will give the List of Data Targets which has the red request.
Looked into one Data Target, You can see the request failed and also not available for Reporting.
Green Status: @08@ (This is to Denote request status which is in Green )
For the Successful Request you can see the Request available for Reporting.