Hi All,

I am having a problem with Crystal Reports 10 and .Net 2008.  I recently converted an asp.net app from 2003 to 2008.  Since doing so, all of my reports are empty (headers etc still show up, but no data is displayed). 

The reports worked fine in .net 2003.  Has anyone else encountered this problem or have any ideas how I can resolve this?  I've tried service packs already.

The report is loaded from a dataset, and stepping through the code the dataset is loaded fine.  Here is a snippet of what it's doing after the dataset has been loaded:

        Dim myExportOptions As CrystalDecisions.Shared.ExportOptions
        Dim myDiskFileDestinationOptions As CrystalDecisions.Shared.DiskFileDestinationOptions
        Dim myExportFile As String
        Dim myReport As New rpt_bill_ar_aging

        myExportFile = Request.PhysicalApplicationPath & Session.SessionID.ToString & ".pdf"
        myDiskFileDestinationOptions = New CrystalDecisions.Shared.DiskFileDestinationOptions
        myDiskFileDestinationOptions.DiskFileName = myExportFile

        With myReport.ExportOptions
            .DestinationOptions = myDiskFileDestinationOptions
            .ExportDestinationType = .ExportDestinationType.DiskFile
            .ExportFormatType = .ExportFormatType.PortableDocFormat
        End With

        myReport.SetDataSource(dsReport)
        crvReportViewer.ReportSource = myReport

        myReport.Export()
        Response.ClearContent()
        Response.ClearHeaders()
        Response.ContentType = "application/pdf"
        Response.WriteFile(myExportFile)
        Response.Flush()
        Response.Close()
        System.IO.File.Delete(myExportFile)

The code runs fine and there are no errors, but as I said the reports come up blank.  Any help would be greatly appreciated.

Hi Brian,
I did do a verify datasource, since the original problem I had was CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.

I tried Set Datasource and I get the following error messages:

Query Engine Error: crdb_adoplus: To access classes in your project at design-time please build your project first, then try again.

(I did build my project).  Then I get the message

'Some tables could not be replaced, as no match was found in the new datasource.  Please specify the table required for any unmodified tables.'

This seems weird since the dataset is the original dataset the report was generated from. 

After I click close on the Set Datasource window I get the messages Unknown Query Engine Error and The Operation Could Not Be Completed. 
Running the report returns the same result, no data...

I appreciate the help, have you got any other ideas of what I can try or why it would think the dataset is invalid when I try to set it?

I also wonder if you could delete the report from the project, and then add in the ORIGINAL report (from the previous version). Maybe it will do a clean upgrade if the rest of the project has already been upgraded and that is all it has to do (less things to screw up in the process).

Problem solved!

It turns out the problem wasn't with the reports conversion, but with the datasets.  I had to recreate the dataset for each report, and that seems to have solved the problem.  It seems that the conversion from 2003 to 2008 doesn't handle the conversion of datasets very well.  If you compare the xml code between 2003 and 2008 they are very different, but the conversion process doesn't update the xml, only recreating the dataset from scratch seems to have worked.

To make it easier for anyone else who may have to do this, copying/pasting data tables between the old and new datasets seems to update the xml just fine.

Thanks again for all your help and suggestions.