Filtering Crystal Report's Data Based on Textbox Value Without Logon Prompt

Introduction

This article demonstrates how to filter Crystal Report's data based on textbox value without logon prompt using ASP.NET with C#. Here I have created two web pages and a Crystal Report. One web page for a textbox value and a button and another web page for displaying Crystal Reports.

Problem with single web page

By using a single webpage, the Crystal Report's options export, print, zoom, etc. will not work properly, so this article can shows how to do that with two web pages for proper functionality without a logon prompt.

Database for this sample

I have used the database name "EmpDetails", in that the table will be an "empno" and other columns as follows:

Creating first web page

Create the first web page for the Textbox value for filtering the Crystal Report data. In this add a textbox and a button. See the following designer code:

<title>.: Filter The Data Here :.</title>

</head>

<body>

<h1>Filtering Crystal Report Data based on TextBox Value without Logon Promt</h1>

Enter Designation : <asp:TextBox ID="TxtDesig" runat="server"></asp:TextBox><br />

<asp:Button ID="BtnReport" runat="server" Text="Show Report" onclick="BtnReport_Click" />

</div>

</form>

</body>

</html>

Now write the code in the button click event to take a textbox value in the session and redirect to another page. The code will be as shown below:

protected void BtnReport_Click(object sender, EventArgs e)
{
Session["JOB"] = TxtDesig.Text;
Response.Redirect("ReportPage.aspx");
}

Then create the Crystal Reports report.

Creating Crystal Report

First create the Crystal Reports report with Create New Connection -> OLE DB(ADO) -> Select SQL Server provider -> Enter Server Name, User Name,

Password, Database Name -> add table (I used Emp table) -> add columns (I used EmpNo, Name, Job, Sal, Deptno) -> Finish.

Now Field Explorer -> Parameter Fields -> Right-click -> New -> Enter details like below -> Click OK.

Now select Crystal Reports -> Crystal Reports Menu -> Report -> Select Expert… -> select emp.job (Which was filtering column) like below:

Click OK -> in first drop down list select "is equal to" then select Parameter field {?JOB} then click OK as shown below:

Then create the second web page.

Creating second web page

Create the second web page and add a CrystalReportViewer and Source as shown in the following code:

<title>.: See The Report Here :.</title>

</head>

<body>

<h1>See the Report Which was Filtered By the value of TextBox</h1><br />

<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"

AutoDataBind="True" DisplayGroupTree="False" EnableDatabaseLogonPrompt="False"

EnableParameterPrompt="False" Height="1039px"

ReportSourceID="CrystalReportSource1" ReuseParameterValuesOnRefresh="True"

Width="773px" />

<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">

</Report>

</CR:CrystalReportSource>

</div>

</form>

</body>

</html>

Then write this code in page load event like in the following.

Namespaces

using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;

Code

protected void Page_Load(object sender, EventArgs e)
{
ReportDocument rd = new ReportDocument();
rd.Load("Full Path of Your Report\EmpReport.rpt");
rd.SetDatabaseLogon("UserName", "Password", "ServerName", "Database");
rd.SetParameterValue("JOB", Session["JOB"]);
CrystalReportViewer1.ReportSource = rd;
}

Finally Build and run the first page; provide input then click the button then it shows the report and all the options like export, print, etc. will work normally.
Enjoy Programming.

Summary

In this article, I discussed how we can filter the Crystal Report data based on a textbox value without logon prompt. As I discussed previously the problem with Crystal Reports controls will be solved through this method of creating two web pages. And also I have used a simple session element creation and pass this value from one page to another page.