Crystal Report not refreshing based on parameter values in asp.net

Introduction:

In this article I will explain how to refresh crystal reports based on parameter values to populate required data in asp.net

Description:

In Previous posts I explained crystal reports example in asp.net and pass parameters to crystal reports using asp.net. After create crystal reports with search option first time I entered text and click on search button at that time reports populate with required data after that again I entered text and click search button during that time report is showing only previous data that is not updating based on search text. 

I tried many ways to solve this problem but I didn’t find way to solve this problem. After long research I find solution to refresh crystal report and displaying data based on required search text.

Previously in button click I written code like this 

protected void btnSearch_Click(object sender, EventArgs e) { ReportDocument reportdocument = new ReportDocument(); reportdocument.Load(Server.MapPath("CrystalReport.rpt")); reportdocument.SetDatabaseLogon("", "", "SureshDasari", "MySampleDB"); reportdocument.SetParameterValue("Username", txtUserName.Text); CrystalReportViewer1.ReportSource = reportdocument; }

After research I added some extra code in button click like this

protected void btnSearch_Click(object sender, EventArgs e) { ReportDocument reportdocument = new ReportDocument(); reportdocument.Load(Server.MapPath("CrystalReport.rpt")); reportdocument.SetDatabaseLogon("", "", "SureshDasari", "MySampleDB"); reportdocument.SetParameterValue("Username", txtUserName.Text); CrystalReportViewer1.ParameterFieldInfo.Clear(); CrystalReportViewer1.ReportSource = reportdocument; }

If you observe above two code blocks only difference is one single line i.e.

CrystalReportViewer1.ParameterFieldInfo.Clear();

By adding this line in button click it will clear the previous parameter values and allow us to search for records based on new parameter values. I hope it helps someone.

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