Updating a dataset in Crystal Reports

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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

A WordPress.com Website.

Up ↑

%d bloggers like this: