User-47461065 posted
Hi,
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:
http://www.mediafire.com/view/?9d9y4lac5mjpxs7
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!!!
