I'm creating a report using the built-in module of Crystal Reports in Visual Studio 2008, and for that I have added a DataSet containing multiple DataTables. As for now, the DataTables have a certain quantity of fields which may 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 a Datatable, that Datatable's fields isn't updated in Crystal Reports. Every time I tried doing this I was forced to remove the DataSet completely and add it again in order to have the updated schema, which is a very bad solution because all fields already on the reports get lost.
Is there a simple way to make it update the structure? (I've already clicked Verify Database under database Expert).
After having a conversation with a friend, we both figured out how to overcome this problem but the solution is not very elegant:
DataTable
DataTable
to updateSet Datasource Location
DataSet
connection again and update your DataTable
against the one present in the new connectionNote: if you try to update again, you must close visual studio again and repeat everything.
Hope this can help someone with the same problem.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With