or
<
add
assembly
=
"Telerik.ReportViewer.WebForms, Version=5.1.11.928, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"
/>
<
add
assembly
=
"Telerik.Reporting, Version=5.1.11.928, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"
/>
<
add
assembly
=
"System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"
/>
<
telerik:reportviewer
id
=
"ReportViewer1"
report
=
"QuotationReportClassLibrary.SpecificQuote, QuotationReportClassLibrary, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"
runat
=
"server"
style
=
"border:1px solid #ccc;"
width
=
"800px"
height
=
"1000px"
/>
<%@ Register assembly="Telerik.ReportViewer.WebForms, Version=5.1.11.928, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>
Dim fs As New QuotationReportClassLibrary.SpecificQuote()
private
void
monthlyservicesales_NeedDataSource(
object
sender, EventArgs e)
{
var report = (Telerik.Reporting.Processing.Report)sender;
using
(var mySql =
new
MySQL(App.ConnString))
{
var data =
mySql.QueryDataset(
@"SELECT servicetable.Name,count(*)
as
Total,0
as
BWTotal
FROM axxess.axstable axstable
JOIN
axxess.servicetypetable servicetypetable
ON (axstable.ServiceTypeId = servicetypetable.ServiceTypeId)
join axxess.servicetable ON servicetypetable.ServiceId = axxess.servicetable.ServiceId
WHERE (date_format(axstable.DateCreated,
'%Y%M'
) = date_format(?0,
'%Y%M'
))
and axxess.servicetable.Name not like
'%*%'
Group by servicetypetable.ServiceId
order by count(*) desc",
report.Parameters[
"datetime"
].Value);
var objectDataSource =
new
Telerik.Reporting.ObjectDataSource();
objectDataSource.DataSource = data.Tables[0];
// GetData returns a DataSet with three tables
report.DataSource = objectDataSource;
}
}