Dataset Refresh

[Former Member]

Hi

I created a test dataset(test.xsd) with 3 fields, and i develop a report based on this dataset.

now i added two colums in same dataset . but new colums which i created are not updated to dataset in the report.

give me sloution.

Thanks

[Former Member · Accepted solution]

Hi

Need more information-

CR version?

VS version?

Web or Windows application?

Regards,

Amit

[Former Member]

Hi

Thanks for your response.

I am using visuval studio 2003, web application

[former_member208657]

The steps will depend on how you designed the report in the first place.

1. When you use the ADO.NET (XML) driver you can design the report on a schema file (.xsd or .xml) or from a DataSet in your project. If you designed the report on a schema file you'll want to set the datasource location to your updated schema. In order to get your schema you'll need to write it out to disk.

- Write out your DataSet schema to disk using the WriteXMLSchema() method

- Open the Field Explorer

- Right click on Database and select Set Location

- Find the new XML schema file you wrote to disk and update the location

2. If you designed your report based on the DataSet in your project you should be able to simply perform a Verify Database. This will tell the report engine to refresh the data definition from the original source. In your case a DataSet in the project. You can do this by right clicking on the Database Fields in the Field Explorer and selecting Verify Database.