Click here to Skip to main content
13,505,219 members
Click here to Skip to main content
Add your own
alternative version

Tagged as


14 bookmarked
Posted 10 Dec 2007

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

, 10 Dec 2007
Rate this:
Please Sign up or sign in to vote.
Crystal Reports with paging and navigation functionality with C# .NET.


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:
  2. using CrystalDecisions.CrystalReports.Engine;
    using CrystalDecisions.Shared;
  3. Declare a private report object in your main class:
  4. private ReportDocument reportDocument;
  5. Implement the Page_Init method in your web page with the following code:
  6. private void Page_Init(object sender, EventArgs e)
        reportDocument = (ReportDocument)Session["reportDocument"];
        crystalReportViewer.ReportSource = reportDocument;
  7. The method below will set the default logon information to the CrystalReportViewer:
  8. 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();
        crystalReportViewer.LogOnInfo = infos;
  9. Implement the code below for the button click event:
  10. protected void display_Click(object sender, EventArgs e)
        reportDocument = new ReportDocument();
        Session["reportDocument"] = reportDocument;
        crystalReportViewer.ReportSource = reportDocument;

    [Optional step]

  11. 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:
  12. crystalReportViewer.SelectionFormula = 
        "{Table.FieldName}=" + DynamicValue + "";

That's all!


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Software Developer (Senior)
India India
No Biography provided

You may also be interested in...


Comments and Discussions

QuestionDoes this work when parameters are passed? Pin
Steve P.19-Dec-07 2:13
memberSteve P.19-Dec-07 2:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.180417.1 | Last Updated 11 Dec 2007
Article Copyright 2007 by KennyPatel
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid