SQL Server Performance

Reporting Services: Line Graph MBs over Time

Discussion in 'SQL Server 2005 Reporting Services' started by L0st_Pr0phet, Oct 7, 2008.

  1. L0st_Pr0phet Member

    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
  2. gurucb New Member

    if I understand your query this may help you
    Drop
    [Date] from dataset onto area that indicates "Drop Category Fields here"[Name] from dataset onto area that indicates "Drop series Fields here"
    and
    size from dataset onto area that indicates "Drop data Fields here"

Share This Page