Search the Community
Showing results for tags 'filtered'.
I'm trying to create a report of all the smart lights I have added to the data base so that I can insure that I got all the serial numbers, and other details correctly recorded. I've created a new category called "Smart Light" and applied it to each light added. But I cannot figure out how to do a simple filter of the data in the report designer, where Category = "Smart Light". Second problem. I reviewed the video on YouTube about creating reports. I followed the steps in the video to select the fields that I wanted in the report, but found that the field selector (Available Fields, I think), excludes many fields, including several that I want to include in the report. Is there another way to create the report I want with all the fields I need? The filter I want to use and the fields I want to include are listed below: Filters: Category = "Smart Light" Fields for Smart Light report Asset # Image 1 Brand Name Model Number Status Invoice/PO # Date Bought Serial Number MAC Address (wireless) Location/Room Field 1 Name = "HomeKit Code" (this is a user-defined field: User Field 20) Field 1 Value (this is a user-defined field: User Field 21) Field 2 Name = "Host Name" (this is a user-defined field: User Field 22) Field 2 Value (this is a user-defined field: User Field 23) Field 3 Name (this is a user-defined field: User Field 24) Field 3 Value (this is a user-defined field: User Field 25) The bold labels are the names I gave to user-defined fields listed to the far right of the field name above within parentheses. TIA David