To update a dataset in CR, without losing all the fields on the report do the following:
- Open the Field Explorer
- Expand Database Fields
- Right click the dataset and choose Set Datasource Location…
- Create New Connection
- ADO.NET
- Make New Connection
- Browse for updated XSD (Class Name and Use Dataset from Class not required).
- Click Finish
- Select the same level items in both the Current Data Source and Replace With trees and click Update
Review the database fields to ensure that the correct values have been passed through.
Leave a Reply