Report with item taxes

I edited the Items - Price List report the following way

First make the Tables Queried section also query the tax table, so it reads.... LEFT JOIN Supplier WITH(NOLOCK) ON Item.SupplierID = Supplier.ID LEFT JOIN Tax WITH(NOLOCK) ON Item.TaxID = Tax.ID"

Then add this column on your report

Begin Column FieldName = "Tax.Description" DrillDownFieldName = "" DrillDownReportName = "" Title = "Item Tax" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2115 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Save your changes - re-run the report, it will show the tax associated with your items. H> Does anyone know where to find a report that shows item taxes for all items?

Does anyone know where to find a report that shows item taxes for all items? I need a way to make sure all my items have the right tax schedules without having to manually open each one.

-- Steve

Thanks for your input. It helped to get the job done.