All geek questions in one place

Crystal DataSet schema update for VS2008

I create a report using the Crystal Reports built-in module in Visual Studio 2008, and for this I have added a DataSet containing several DataTables. At the moment, there are a certain number of fields in DataTables that can grow in the future, so the next person updating my report will need to update the DataSet schema.

The problem is that whenever I add new fields to Datatable, these Datatable fields are not updated in Crystal Reports. Each time I tried to do this, I had to completely remove the DataSet and add it again in order to have an updated schema, which is a very bad solution, because all the fields in the reports are already lost.

Is there an easy way to get it to update the structure? (I already clicked Verify Database in the Expert database).

+4
source share
1 answer

After talking with a friend, we both figured out how to overcome this problem, but the solution is not very elegant:

  • Add Columns to DataTable
  • Close Visual Studio
  • reopen visual studio
  • right click DataTable to update
  • click Set Datasource Location
  • add your DataSet again and update the DataTable against the one present in the new connection

Note. If you try to upgrade again, you must close the visual studio again and try again.

Hope this helps someone with the same issue.

+8
source

Source: https://habr.com/ru/post/1339242/

More articles:


All Articles