I try this SP
SELECT distinct
SUM(total) total,
S.Month
FROM
(
SELECT
DATENAME(MONTH,tblReg.StartDate) as [Month],
count(tblVV.VName) as total
from
tblVV
inner join tblRV
on tblVV.MID=tblRV.ID
inner join tblReg
on tblRV.RID=tblReg.RID
WHERE
tblReg.StartDate >= DATEADD(MONTH, -3, GETDATE())
AND tblReg.EndDate <= GETDATE() and
tblRV.RegNo ='782'
AND VName <> ''
and
tblVV.VName <>''
GROUP BY
DATENAME(MONTH,tblReg.StartDate)
) S
group by
S.Month
above SP shows this data
total Month
5 August
12 July
10 June
1 May
whEN I ADD VName in SP this show like this
SELECT distinct
SUM(total) total,
S.Month,S.VName
FROM
(
SELECT
DATENAME(MONTH,tblReg.StartDate) as [Month],
count(tblVV.VName) as total,
tblVV.VName
from
tblVV
inner join tblRV
on tblVV.MID=tblRV.ID
inner join tblReg
on tblRV.RID=tblReg.RID
WHERE
tblReg.StartDate >= DATEADD(MONTH, -3, GETDATE())
AND tblReg.EndDate <= GETDATE() and
tblRV.RegNo ='782'
AND VName <> ''
and
tblVV.VName <>''
GROUP BY
DATENAME(MONTH,tblReg.StartDate), tblVV.VName
) S
group by
S.Month,
S.VName
this show result like this
total Month VName
1 July DDSB
1 June DPSB
1 June DSB
5 August MV
11 July MV
7 June MV
1 May MV
1 June PSB
and code
string data1 = "[";
var mdata = new TrackDataEntities1().spsumdata(RegNo)
.Select(s => new {s.Month }).ToArray();
foreach (var c in mdata)
{
data1 += "'" + c.Month + "',";
}
data1 = data1.Substring(0, data1.Length - 1);
data1 += "]";
string data2 = "[";
var sdata = new TrackDataEntities1().spsumdata(RegNo)
.Select(s => new { s.VName,s.Month, s.total }).ToArray();
foreach (var s in sdata)
{
data2 += "{VName:'" + s.VName + "',";
data2 += "month:'" + s.Month + "',";
data2 += "data:[" + s.total + "]},";
}
data2 = data2.Remove(data2.Length - 1);
data2 += "]";
return data1 + "*" + data2;
When i select 782 record this show like this
data1 shows
['July','June','June','August','July','June','May','June']
data2 shows
[
{VName:'DDSB',month:'July',data:[1]},
{VName:'DPSB',month:'June',data:[1]},
{VName:'DSB',month:'June',data:[1]},
{VName:'MV',month:'August',data:[5]},
{VName:'MV',month:'July',data:[11]},
{VName:'MV',month:'June',data:[7]},
{VName:'MV',month:'May',data:[1]},
{VName:'PSB',month:'June',data:[1]
}]
and jquery
<script type="text/javascript">
$(function () {
$('#tabledata').on('click', 'tr', function () {
var row = $(this);
var regno = row.find('td')[0].firstChild.data;
var obj = {};
obj.RegNo = regno;
Getsumdata(obj);
return false;
});
});
function Getsumdata(obj) {
$.ajax({
type: "POST",
url: "WebForm1.aspx/summarydata",
data: JSON.stringify(obj),
contentType: "application/json;charset=utf-8",
dataType: "json",
async: true,
cache: false,
success: function (result) {
alert(JSON.stringify(result.d));
console.log(JSON.stringify(result.d));
var data1 = result.d.split('*')[0];
console.log(JSON.stringify(data1));
var data2 = result.d.split("*")[1];
console.log(JSON.stringify(data2));
alert(data1);
alert(data2);
$('#sum').highcharts({
title: {
text: 'Combination chart'
},
xAxis: {
categories:eval(data1),
title: {
text: null
}
},
labels: {
items: [{
html: 'Total fruit consumption',
style: {
left: '50px',
top: '18px',
color: (Highcharts.theme && Highcharts.theme.textColor) || 'black'
}
}]
},
series: eval(data2)
});
}
});
}
</script>
chart display like this

i try this highchart
http://jsfiddle.net/gh/get/jquery/1.9.1/highslide-software/highcharts.com/tree/master/samples/highcharts/demo/combo/
Whereas i want this result in data2 to display data in chart
[{VName:'MV',month:'May',data:[1]},
{VName:'DDSB,MV,DPSB',month:'July',data:[1,11]},
{VName:'DPSB,DSB,MV,PSB',month:'June',data:[1,1,7,1]},
{VName:'MV',month:'August',data:[5]},
]"