Stock Report

[berickson]

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.

[Susan_A · Accepted solution]

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.