hi,
when I try to execute dataset query it is giving me the errot
select Standard, Total, MonthName
from (SELECT Standard, COUNT(Standard) AS Total,
datename(month, ReportDate) as [MonthName],
datepart(month, ReportDate) as [Month]
FROM CPTable where
ReportDate >= @ReportDate and ReportDate < @ReportDate
GROUP BY Standard,
datename(month, ReportDate),
datepart(month, ReportDate)) ReportData
ORDER BY [Month], [Standard]
Reportdate=8/1/2015
then it is giving the error
reportdata.Month is not valid dataname
Go to the complete details ...