Skip to Content
avatar image
Former Member

Dataset Refresh

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 20, 2008 at 12:49 PM

    Hi

    Need more information-

    CR version?

    VS version?

    Web or Windows application?

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 01:06 PM

    Hi

    Thanks for your response.

    I am using visuval studio 2003, web application

    Add comment
    10|10000 characters needed characters exceeded

    • 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.