Generate Asset Report by User

Good Afternoon,

I am looking for a way to generate an Asset Report by Requester. We really like how most of the asset tracking works, but every so often in our company, we print out reports from our Asset Tracking System (now ServiceDesk) to confirm with users that we have the correct information. Here's what I'd like:

One report that takes all users that have assets associated to them and compiles them to 1 page per user
One report that is a single user and the assets associated to him/her

I was able to create the latter of the two using the following query:

SELECT resource.RESOURCENAME "Resource Name",resource.ASSETTAG "Asset Tag",product.COMPONENTNAME "Product",productType.COMPONENTTYPENAME "Product Type",resFields.UDF_CHAR1 "Make",resFields.UDF_CHAR2 "Model" 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 SDUser sdUser ON rOwner.USERID=sdUser.USERID LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID LEFT JOIN Resource_Fields resFields ON resource.RESOURCEID=resFields.RESOURCEID WHERE (aaaUser.FIRST_NAME = N'Users Name' COLLATE SQL_Latin1_General_CP1_CS_AS)

Where 'Users Name', of course, is the requester in question.

When I attempt to create a report of all users and their assets, it puts everyone on one page at a time (i.e. about 5 or 6 users per page), rather than one user to each page.

Let me know if you'd like/need any other information. Thank you.

~James Murphy