or
private
void
report1_NeedDataSource(
object
sender, EventArgs e)
{
var query = ExtendedData.GetExtendedAgreements(_db, _ProgramAreaID,
null
);
table1.DataSource = query ToList();
//Setup Column Filters based on Querystring, Proof of concept, to be made Dynamic
//************************
this
.table1.Filters.AddRange(
new
Telerik.Reporting.Filter[] {
new
Telerik.Reporting.Filter(
"=Fields.Province"
, Telerik.Reporting.FilterOperator.Equal,
"Ontario"
)});
int
count = table1.Items.Count();
TotalRecords.Value = Convert.ToString(count);
}
Sample aspx from SSRS local report:
<asp:SqlDataSource ID="SqlDataSourceX" runat="server"ConnectionString="<%$ ConnectionStrings:ConnDB %>"
SelectCommand="SELECT * FROM [Jobs] WHERE ([DeptID] = @d)">
<SelectParameters>