That's what I was afraid of!!!  Our Help Desk staff had typed in the name of all of our offices (locations) in each of our 'regions'  for the queires to be run for all open calls per region.  Our location names change and locations are dropped and added more often than we would like so the mainteance on these queries is very high.  I thought I might be able to use a view that I created in the Altiris database that produces a list of the location name and the region so that the logic on the reports could be reduced.  Is there any tool available within the Help Desk Solution where I can add data from additional tables? 

I have offered to write queries or reports outside of the Help Desk Solution but the staff needs the ability to pull the results up within the Help Desk software. 

Thanks for your help and, in advance, for any advice....