Custom reports are relative easy with Jasperreports and CABI.
The start is a good example SQL query that has all information that you want/need in your report.
Example for origin aaa:
-----------------------------------
select tab10.source as 'DeviceName', tab10.target as 'Drive', tab10.origin as 'Origin',
(select max(tab5.samplevalue)
from v_qos_disk_usage_perc as tab5 with(nolock)
where tab5.sampletime <= getdate()-1
and tab5.source = tab10.source and tab5.target = tab10.target) as 'Perc Used',
(select max(main.samplevalue)/1000
from v_qos_disk_usage as main with(nolock)
where main.sampletime <= getdate()-1
and main.source = tab10.source and main.target = tab10.target) as 'GB_Used',
(select max(main2.samplemax)/1000
from v_qos_disk_usage as main2 with(nolock)
where main2.sampletime <= getdate()-1
and main2.source = tab10.source and main2.target = tab10.target) as 'GB_Total',
(select max(main.sampletime)
from v_qos_disk_usage as main with(nolock)
where main.sampletime <= getdate()-1
and main.source = tab10.source and main.target = tab10.target) as 'Lastpoll'
from v_qos_disk_usage_perc as tab10 with(nolock)
where origin = 'aaa'
group by tab10.origin, tab10.source, tab10.target
order by tab10.origin, tab10.source, tab10.target