Asset Status Report is corrected...at long last.

Renamed to ASSETS CURRENTLY AT A PROJECT.

While the report has been operating correctly, a recent inquiry has revealed that the report was mis-leading in the data it returned. Text on the report now addresses this issue and the report has been renamed to better reflect the data it returns.

The report's logic is as follows:
COMPARE TODAY'S DATE WITH ALL PROJECT OPEN/CLOSE DATES. AN ASSET IS INDICATED AS OUT AND NOT AVAILABLE FOR USE ONLY WHEN TODAY'S DATE CONFLICTS WITH ANY PROJECT'S ACTUAL SHOW DATES.

The underlying business logic is that if it is not "in use" on a floor the Asset could be redirected to another use.

You can use the date range search criteria in View/Edit/Select to search for Conflict for a selected Asset at for a given date.