ReportViewer arguments

I have a ReportViewer on a page, but I need to be able to set variables such as StartDate and EndDate inside the query for the report, but can seem to find any examples of how to set a query in code.

The field names will remain the same, so hopefully I dont need to re-design the report, all I really need to do is something like ReportViewer1.query = "select * from myTable where startDate < = 22/09/2010"

Any suggestions or examples would be great if anyones done anything like this before?

Thank you in advance!

Tony Cross
Who is Participating?
aibusinesssolutionsConnect With a Mentor Commented:
If you are setting the datasource in a ASP.NET web page, then just use a SelectParameter.  In the example below, I'm using a QueryStringParameter.  
<rsweb:ReportViewer ID="ReportViewer1" runat="server" ExportContentDisposition="AlwaysInline">
            <LocalReport EnableExternalImages="True" ReportPath="Design.rdlc">
                    <rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="DataSet1_tblContracts" />
        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}"
            SelectMethod="GetData" TypeName="DataSet1TableAdapters.tblContractsTableAdapter">
                <asp:QueryStringParameter Name="contactID" QueryStringField="id" Type="Int32" />

Open in new window

I think it's good time for you, to choose some leading solution for reporting.
I was using many of different reporting tools but for me the best so far is FastReport.
If you can't switch, please send us more code - then somebody will help you quicker.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.