ASP.NET C# reportviewer Parameter

Question

I am new to report viwer, I wanted to know that how to pass the select parameter to report viewer and also to data source? I need to pass the start date and end date to the data source for filtering data and also show in report viewer. Anyone suggest?

>     <rsweb:ReportViewer ID="Log_ReportViewer" runat="server" Height="545px" Width="962px" Font-Names="Verdana" Font-Size="8pt"
> WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt">
>         <LocalReport ReportPath="Reporting\ReportRDLC File\LogReport.rdlc">
>             <DataSources>
>                 <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="Log" />
>             </DataSources> 
>         </LocalReport>
>     </rsweb:ReportViewer>
>     <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:InvControlConnectionString %>"
> ProviderName="<%$
> ConnectionStrings:InvControlConnectionString.ProviderName %>"
> SelectCommand="SELECT * FROM logs WHERE log_createDate >= startDate AND log_createDate >= endDate">
>         <SelectParameters>
>             <asp:QueryStringParameter Name="endDate" QueryStringField="endDate" />
>             <asp:QueryStringParameter Name="startDate" QueryStringField="startDate" />
>         </SelectParameters>
>     </asp:SqlDataSource> </asp:Content>

Thanos Markou · Accepted Answer · 2015-11-27 08:20:44Z

1

Through the code behind, like that:

ReportParameter[] parameters = new ReportParameter[yournumberofparamaters];
parameters[0] = new ReportParameter("name", value);
parameters[1] = new ReportParameter("name", value);
parameters[2] = new ReportParameter("name", value);
this.Log_ReportViewer.LocalReport.SetParameters(parameters);

answered Nov 27, 2015 at 8:20

Thanos Markou

2,6344 gold badges27 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

codecodeNinja Over a year ago

Hi i try this code before but it show me LocalProcessingException at the last line of code.

Thanos Markou Over a year ago

@FirionRedfield Share the exception message please.

codecodeNinja Over a year ago

An exception of type 'Microsoft.Reporting.WebForms.LocalProcessingException' occurred in Microsoft.ReportViewer.WebForms.dll but was not handled in user code

Thanos Markou Over a year ago

This isn't the exception message.

codecodeNinja Over a year ago

I got only got this message

|

Collectives™ on Stack Overflow

ASP.NET C# reportviewer Parameter

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related