→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
berickson
Engaged Sweeper
How would I make a report that would do the following:

Scan Items in the "Stock" Asset State that would include the customfield1 field

For instance Toner would be listed under stock and the customfield1 would list the count so the report would list the asset name, the model, and the stock.
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
Do the following:
  • Open the report builder under Reports\Create New Report.
  • In the visual representation of the report in the upper section of the report builder, tick the Custom1 and Model fields in the tblAssetCustom database table.
  • In the expression list, replace the default = 1 filter in the Criteria column of the tblAssetCustom.State expression with = 9. A state of 9 means "stock".
  • Give your report a title and hit Save & Run.

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
Do the following:
  • Open the report builder under Reports\Create New Report.
  • In the visual representation of the report in the upper section of the report builder, tick the Custom1 and Model fields in the tblAssetCustom database table.
  • In the expression list, replace the default = 1 filter in the Criteria column of the tblAssetCustom.State expression with = 9. A state of 9 means "stock".
  • Give your report a title and hit Save & Run.