SAP Knowledge Base Article - Public

1219251 - Data from ADO.NET dataset is not reflected in the report

Symptom

An application uses Crystal Reports for Visual Studio .NET as the reporting development tool.

An ADO.NET dataset is generated to provide data for the report. The 'SetDatasource' method is then used to pass the dataset to the report.

When the report is displayed or exported, the data from the dataset is not reflected in the report.

Why does this behavior occur and how do you resolve it?

Resolution

This behavior occurs because the report was not created against an XML schema file that represented the dataset.

To resolve this behavior, create a schema file to represent the dataset by using the 'WriteXMLSchema' method.

Once the schema file is created, set the datasource location of the report to the newly created schema file.

When you now display or export the report, the data from the dataset is reflected in the report.

====================

NOTE:

For information on creating a schema file, refer to knowledge base article c2010929.

====================

Keywords

DOTNET ADO NET DATA SET REFRESH OLD C2010929 XI R2 Crystal Reports for Visual Studio ADO.NET Dataset , c2018277 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports, version for Visual Studio .NET 2005 ; SAP Crystal Reports, version for Visual Studio .NET 2008 ; SAP Crystal Reports, version for Visual Studio .NET 9.1