Skip to Content
author's profile photo Former Member
Former Member

Paging slow reloads report


I have a crystal report 2008 in a 3.5 web page.

The report loads and work ok.

The problem is that every time you change page it is reloading the report then displaying the page.

So if a report takes a minute to load initially then every time you change page it will take a minute.

Please advise.

Thank you for your help

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Sep 21, 2010 at 06:58 PM


    Do you see the same behaviour when you run the report in designer?

    Please provide

    Patch level of CR?

    Database used?

    Connectivity method?



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you for your reply.

      I am using an SQL Server 2005

      When i run the report in Crystal Reports 2008 Designer paging is very fast.

      When i run it in my 3.5 C# page then paging is slow.

      Crystal report verion: CrystalDecisions.Web, Version=12.0.2000.0

      Please find below my code.

      Thank You for your help


      public ReportDocument MyReportObject = new ReportDocument();

      string strTitle;

      string strMenu;

      string strDatabase;

      protected void Page_Load(object sender, EventArgs e)


      if (!IsPostBack)


      //Connect to database

      var crConnectionInfo = new ConnectionInfo();

      SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["TheConnection"].ConnectionString);


      crConnectionInfo.ServerName = csb.DataSource;

      crConnectionInfo.DatabaseName = csb.InitialCatalog;

      crConnectionInfo.UserID = csb.UserID;

      crConnectionInfo.Password = csb.Password;


      TableLogOnInfos mytableloginfos = new TableLogOnInfos();

      mytableloginfos = CrystalReportViewerMain.LogOnInfo;

      foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos)


      myTableLogOnInfo.ConnectionInfo = crConnectionInfo;




      protected void CrystalReportViewerMain_Unload(object sender, EventArgs e)





      protected void CrystalReportViewerMain_OnInit(object sender, EventArgs e)



      CrystalReportViewerMain.ReportSource = MyReportObject;

      CrystalReportViewerMain.HasCrystalLogo = false;

      //CrystalReportViewerMain.HasToggleGroupTreeButton = false;

      CrystalReportViewerMain.DisplayGroupTree = false;

      CrystalReportViewerMain.HasRefreshButton = true;