Hi,

I am trying to build a report using the below dataset,

select database_name as [Name],
[Total_DB_Size(MB)] as Size,
Date_Captured as [Date]
from Admin..DB_Growth
order by Date_Captured Desc

 What I want is a line graph of the different db's with the axis being the MBs and the date. I cant seem to get this right each time I try it doesnt give me what I expect. Can anyone outline the steps?

cheers

if I understand your query this may help you 

Drop

[Date]  from dataset onto area that indicates "Drop Category Fields here"