reports and weird sorting of resource names
hi
running version 7018 and i created a custom report to show all resource names starting with the number 5.
the resource names are identical to the 4 digit asset numbers on my physical asset names, and all of them start with 5
when i run the report the first 400 or so resource names are listed in numerical order 5000, 5001, 5002 ... 5400 but at some stage the resource names just seem to appear in a random fashion. the last 6 items read as 5527, 5532,5536,5535,5546,5544
is there any way to force this report to show the resource names in numerical order all the way thru the report?
many thanks
ps i have pasted the search query below from the report area
SELECT resource.RESOURCENAME 'Resource Name',resource.ASSETTAG 'Asset Tag',product.COMPONENTNAME 'Product',productType.COMPONENTTYPENAME 'Product Type', rToAssetResource.RESOURCENAME 'Associated To',aaaUser.FIRST_NAME 'User',resource.SERIALNO 'Serial Number' FROM Resources resource LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID LEFT JOIN ComponentType productType ON product.COMPONENTTYPEID=productType.COMPONENTTYPEID LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID LEFT JOIN Resources rToAssetResource ON rToAsset.ASSTTORESOURCEID=rToAssetResource.RESOURCEID LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID WHERE ( resource.RESOURCENAME LIKE '5%')
running version 7018 and i created a custom report to show all resource names starting with the number 5.
the resource names are identical to the 4 digit asset numbers on my physical asset names, and all of them start with 5
when i run the report the first 400 or so resource names are listed in numerical order 5000, 5001, 5002 ... 5400 but at some stage the resource names just seem to appear in a random fashion. the last 6 items read as 5527, 5532,5536,5535,5546,5544
is there any way to force this report to show the resource names in numerical order all the way thru the report?
many thanks
ps i have pasted the search query below from the report area
SELECT resource.RESOURCENAME 'Resource Name',resource.ASSETTAG 'Asset Tag',product.COMPONENTNAME 'Product',productType.COMPONENTTYPENAME 'Product Type', rToAssetResource.RESOURCENAME 'Associated To',aaaUser.FIRST_NAME 'User',resource.SERIALNO 'Serial Number' FROM Resources resource LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID LEFT JOIN ComponentType productType ON product.COMPONENTTYPEID=productType.COMPONENTTYPEID LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID LEFT JOIN Resources rToAssetResource ON rToAsset.ASSTTORESOURCEID=rToAssetResource.RESOURCEID LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID WHERE ( resource.RESOURCENAME LIKE '5%')