none
crystal reports 2003 RRS feed

  • Question

  • Hello all.

    I maintain an ASP.NET application in VS.NET 2003.
    I have a report that don't show data anymore.
    The report runs for 2-3 minutes (the time to get data from the database) and when finished shows in the viewer 2 pages with empty tables.
    This happens when i run the report on the period 1.01.2006-4.09.2009.
    If i run the report on 1.01.2006-31.12.2006 or on 1.1.2007-4.09.2009 the report shows data normally.
    So i think the problem is linked on the amount of data returned.

    There are times when the report shows 1800 pages of data as it shoul do but this happens very rarely.
    I debugged and the problem is tha

    DataSet filterDataSet = GetDataset() - gets 10572 records
    crReportDocument.SetDataSource(filterDataSet.Tables[0]);
                   
    System.IO.Stream osReportStream = crReportDocument.ExportToStream(ExportFormatType.PortableDocFormat);
    at this line when the report is working osReportStream.Length = 1.698.593
    and when not working osReportStream.Length = 51867

    So i think the problem is on
    crReportDocument.SetDataSource(filterDataSet.Tables[0]);

    Anybody runned into this?
    Friday, September 4, 2009 11:25 AM

Answers

All replies