Create a Report on Contracts expiring in 90 days by Asset Location

Create a Report on Contracts expiring in 90 days by Asset Location.
(Location is a choice field in Assets lookup list)

1. Create an additional lookup of Asset:Location field in the Contracts list.

Go to list settings of Contracts list, edit “Assets” lookup, select Location checkbox and click ok.  

This will create an additional lookup Asset:Location in Contracts list like below.  

2. Create a view “Contracts Expiring in 90 days” with condition like below:

3. Go to Report Center and configure a report like below:

 

Leave a Reply