How to make chart clickable? RRS feed

  • Question

  • User-47461065 posted


    My storedprocedure query is as follows:

    Select Sum(Case When EntryDate between DATEADD(dd, -7, GETDATE()) AND GETDATE() Then 1 Else 0 End) As 'onetosevendays'
    ,Sum(Case When EntryDate between DATEADD(dd, -14, GETDATE()) AND  DATEADD(dd, -7, GETDATE()) Then 1 Else 0 End) As 'seventofourteendays',
    Sum(Case When EntryDate between DATEADD(dd, -21, GETDATE()) AND DATEADD(dd, -14, GETDATE()) Then 1 Else 0 End) As 'fourteentotwentyonedays',
    Sum(Case When EntryDate between DATEADD(dd, -30, GETDATE()) AND DATEADD(dd, -21, GETDATE()) Then 1 Else 0 End) As 'twentyonetothirtydays',
    Sum(Case When EntryDate< DATEADD(dd, -30, GETDATE()) then 1 else 0 end) as 'thirtyandabovedays' From Master

    I am having the storedprocedure query result as :

    onetosevendays    seventofourteendays    fourteentotwentyonedays    twentyonetothirtydays    thirtyandabovedays
       6                                   11                                 7                                    1                                 3

    These are the list of records in table which are according to Dates entered from current date.

    Now I need to display these values in chart.

    Please help me how to get the chart output as:


    and when I click on the 1-7 Days column on chart, the 6 records under it should be displayed in GridView.

    Is it possible?

    Please help me !!!

    Its Urgent!!!

    Thursday, February 14, 2013 2:48 PM

All replies

  • User1519735232 posted


    Thursday, February 21, 2013 10:37 PM