Custom Report - Assets by User with Cost
Good Afternoon,
I am looking for a report that would display any assets that are assigned to a user and would display the cost of those assets. I've created something similar using the Wizard, but there are two issues.
1) I have to go into the report and manually select which users are displayed in the report. This is troublesome because
- it's a manual process to add/remove someone when they join/leave the company
- the box that lets me choose names has been broken ever since we got this product (which is a whole other issue).
Is it possible to do something like "only display user if they have something assigned to them"?
2) Using the wizard, I am unable to select Resource Cost as a column. I would like to add this and (if possible) total the cost of assets per user.
Any help would be appreciated. Thanks.
~James Murphy
ServiceDesk 8.0.0 Build 8003
I am looking for a report that would display any assets that are assigned to a user and would display the cost of those assets. I've created something similar using the Wizard, but there are two issues.
1) I have to go into the report and manually select which users are displayed in the report. This is troublesome because
- it's a manual process to add/remove someone when they join/leave the company
- the box that lets me choose names has been broken ever since we got this product (which is a whole other issue).
Is it possible to do something like "only display user if they have something assigned to them"?
2) Using the wizard, I am unable to select Resource Cost as a column. I would like to add this and (if possible) total the cost of assets per user.
Any help would be appreciated. Thanks.
~James Murphy
ServiceDesk 8.0.0 Build 8003