How to do paging and navigation with Crystal Reports using C# .NET

• Download source code - 1.65 KB

Introduction

This article will help you to learn how to bind a Crystal Reports file with the Crystal Reports Viewer and display it in a Web Page using very simple steps.

Using the code

The code is very simple. Follow the steps below or download the attached file. Create a report in your project under the Reports folder to try this out.

1. Reference these namespaces:

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

2. Declare a private report object in your main class:

private ReportDocument reportDocument;

3. Implement the Page_Init method in your web page with the following code:

private void Page_Init(object sender, EventArgs e)
{
    reportDocument = (ReportDocument)Session["reportDocument"];
    crystalReportViewer.ReportSource = reportDocument;
}

4. The method below will set the default logon information to the CrystalReportViewer:

public void setLogonInfo()
{
    //--------------------

    TableLogOnInfo logOnInfo = new TableLogOnInfo();
    //logOnInfo = oRpt.Database.Tables["Customers"].LogOnInfo;

    logOnInfo.ConnectionInfo.ServerName = "srvr";
    logOnInfo.ConnectionInfo.DatabaseName = "database";
    logOnInfo.ConnectionInfo.UserID = "sa";
    logOnInfo.ConnectionInfo.Password = "pwd";
    //logOnInfo.TableName = "table";

    TableLogOnInfos infos = new TableLogOnInfos();
    infos.Add(logOnInfo);
    crystalReportViewer.LogOnInfo = infos;
}

5. Implement the code below for the button click event:

protected void display_Click(object sender, EventArgs e)
{
    reportDocument = new ReportDocument();
    reportDocument.Load("C:\\myExample\\Reports\\OnlineTest.rpt");
    //reportDocument.Load(reportsList.SelectedValue);

    Session["reportDocument"] = reportDocument;
    crystalReportViewer.ReportSource = reportDocument;
    setLogonInfo();
}

[Optional step]

6. The code below can be used to retrieve conditional data through the CrystalReportViewer. This can be written wherever you want to implement it. Let's say, by clicking on Search By Employee Id, you want to display some employee data in the ReportViewer and print it:

crystalReportViewer.SelectionFormula = 
    "{Table.FieldName}=" + DynamicValue + "";

That's all!