how to pass parameters to crystal reports / .rdlc reports using asp.net | Passing Parameters from ASP.NET Application to Crystal Report using asp.net

Introduction:

In this article I will explain how to pass parameters to crystal reports using asp.net.

Description:

In Previous post I explained clearly about how to create crystal report using asp.net. Now I will explain how to load crystal reports based on parameters using asp.net. This post is continuation of previous post Create crystal report using asp.net. if you didn’t read previous post crystal reports please check that one then come to this one because I am continuing from previous post in that I explained clearly to create the database tables and bind the reports and display it on page. 

Now Open Default.aspx page and add one textbox, button in your aspx page because by entering username in textbox we will search for the records for that we need to add textbox and button control on top of report by using below code

<div> Enter UserName: <asp:TextBox ID="txtUserName" runat="server"/> <asp:Button ID="btnSubmit" runat="server" Text="Submit" onclick="btnSubmit_Click" /> </div>

After add Textbox and button above the report design will be like this 

Now Open MySampleDBDataSet.xsd file in that select Fill data and right click on it and select Configure

Now one window will that contains select query like this

Now our requirement is to pass the parameter and get the values based on that parameter for that we need to modify the query

SELECT UserId, UserName, FirstName, LastName, Location FROM UserInformation

                                                 To

SELECT UserId, UserName, FirstName, LastName, Location FROM UserInformation WHERE (UserName LIKE '%' + @Name + '%')

After modify our query select query window will like this

After enter the query click Next and Next and click Finish. Now open our Default.aspx page in design mode and select objectdatasource and click on smart tag in right side and click on Configure Data Source

After click on Configure Data Source one window will open in that select TableAdapter and click Next

After click on Next button now we will see available Data Methods in select Tab select GetData Method and click Next

After click Next button Define Parameters window will open in that we need to specify parameters for GetMethod. In this window First select ControlName in Parameters box after that Parameters Source and ControlID Options will enable now select Control in Parameter Source dropdown and select your textbox controlID in ControlID dropdown that would be like below figure.

After fill all options click Finish button we completed set everything to send parameters now open Default.aspx page and double click on your Submit button and write the following code in codebehind

protected void btnSubmit_Click(object sender, EventArgs e) { ReportViewer1.LocalReport.Refresh(); }

Now build and run your application and check the output initially it won’t display any data once we type username in textbox and click on Submit button it will display the resultant data.

Demo

Please give your comments regarding above topic is it ok or not and if you like the post please share it.

  

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email