ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.Filter RDLC (Local SSRS) Report Data using CheckBoxes in ASP.Net<p>Ref:<a title="RDLC (Local SSRS) Report ASP.Net Example using DataSet or DataTable in C# VB.Net and Visual Studio 2010'a" href="http://aspsnippets.com/Articles/RDLC-Local-SSRS-Report-ASPNet-Example-using-DataSet-or-DataTable-in-C-VBNet-and-Visual-Studio-2010.aspx">RDLC (Local SSRS) Report ASP.Net Example using DataSet or DataTable in C# VB.Net and Visual Studio 2010</a></p> <p>Download the sample from above link and modify the HTML form:</p> <pre class="brush: xml">&lt;form id=&#34;form1&#34; runat=&#34;server&#34;&gt; &lt;asp:CheckBoxList ID=&#34;chkCountryDemo&#34; AutoPostBack=&#34;true&#34; OnSelectedIndexChanged=&#34;ProductsType_Changed&#34; runat=&#34;server&#34;&gt; &lt;asp:ListItem Text=&#34;Mexico&#34; Value=&#34;0&#34; /&gt; &lt;asp:ListItem Text=&#34;Germany&#34; Value=&#34;1&#34; /&gt; &lt;asp:ListItem Text=&#34;Sweden&#34; Value=&#34;3&#34; /&gt; &lt;asp:ListItem Text=&#34;France&#34; Value=&#34;4&#34; /&gt; &lt;/asp:CheckBoxList&gt; &lt;asp:ScriptManager ID=&#34;ScriptManager1&#34; runat=&#34;server&#34;&gt; &lt;/asp:ScriptManager&gt; &lt;rsweb:ReportViewer ID=&#34;ReportViewer1&#34; runat=&#34;server&#34; Width=&#34;600&#34;&gt; &lt;/rsweb:ReportViewer&gt; &lt;/form&gt;</pre> <p>Add this Event in code:</p> <pre class="brush: csharp">protected void ProductsType_Changed(object sender, EventArgs e) { string query = &#34;SELECT * FROM customers&#34;; query += &#34; WHERE Country IN (&#34;; foreach (ListItem item in chkCountryDemo.Items) { if (item.Selected) { query += &#34;&#39;&#34; + item.Text + &#34;&#39;&#34; + &#34;,&#34;; } } query = query.Substring(0, query.Length - 1); query += &#34;)&#34;; Customers dsCustomers = GetData(query); ReportDataSource datasource = new ReportDataSource(&#34;Customers&#34;, dsCustomers.Tables[0]); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(datasource); }</pre> <p>Thank You</p>https://www.aspforums.net:443/Threads/163351/Filter-RDLC-Local-SSRS-Report-Data-using-CheckBoxes-in-ASPNet/https://www.aspforums.net:443/Threads/163351/Filter-RDLC-Local-SSRS-Report-Data-using-CheckBoxes-in-ASPNet/Thu, 09 Jan 2014 07:10:56 GMT