This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Graphing a custom query

I am trying to create a custom SQL web-based report that graphs the number of UDT ports in use over time (I'm posting this in the NPM forum because this is a question about web reports)

SELECT 

       month

       ,Sum(apc) MaxPortCount

FROM   (SELECT DATEADD(month, DATEDIFF(month, 0, DateTime), 0) AS Month  

               ,upd.nodeid

               ,max(avgactiveportcount) mpc

        FROM   [dbo].[udt_portusage_daily] UPD

               INNER JOIN nodes N

                       ON N.nodeid = UPD.nodeid

        WHERE  Datetime >= '2013-01-01'

        GROUP  BY DATEADD(month, DATEDIFF(month, 0, DateTime), 0)

                  ,upd.nodeid) X

GROUP  BY month

ORDER  BY month 

I cannot get the report writer to display a graph of this data -- am i missing something?

it displays the information as a table, but I can't figure out why it will not draw a graph if the data.