Hi,

 

I need help creating a custom report. I've tried looking at the SQL but i can't get this to work

 

I need a report with the following columns

 

Asset Tag      Resource Category      Product Type      Product      Vendor Name                                        

 

Resource Name       Location      Cost      Replacement Cost

 

Where cost is the purchase cost of the item and replacement cost is a custom numeric field of assets

 

I need the report grouped by site e.g.

 

site1

xx      xx

 

site 2

xx      xx

 

and I need the rows ordered by Location then Asset Tag then Product

 

Thank you