C# – Update DataSet in Crystal Reports

ccrystal-reportsdatasetnet

I have little to no experience in using Datasets and Crystal Reports so please don't bash me if the answer is really obvious, I didn't manage to find the answer on-line.

I have a C# Winforms application, containing a Crystal Report that takes its data from a DataSet. I populate the DataSet dynamically from inside the application.

In the past, if I added another column to the DataSet, I could right click the DataSet in the Crystal Report and click "Verify Database" to make the new columns available in the Report.

Now, if I do this the following window pops up:

enter image description here

There is no item available in the Class Name combobox, and if I check the checkbox, another combobox appears which is also empty.

Please note that I populate the DataSet from inside the program, so there is no connection.

How can I update the DataSet in the Crystal Reports, so that the new columns become available?

Thank you.

P.S.: I have tried the following solution but it didn't work: Update DataSet Schema On Crystal Reports for VS2008 because I am presented with the same window as above.

Also, this is what I see, might be useful:

enter image description here

Edit1: The fields appear in the Data Sources but do not appear in the Field Explorer.

I already have some Formula Fields that have the same name as the newly added Columns but removing them didn't help either.

Best Answer

I finally managed to solve it by myself. There are three things I did and I'm not quite sure which one did the trick since I can't seem to manage to recreate the problem.

  1. I renamed the Formula Fields that had the same name as the DataTable columns I added.
  2. I clicked the " ... " box and reselected the same file.
  3. I added the Internal Connection ID {294de39c-3e3c-4748-9138-53d4be2a74a6} in the Class Name textbox.

The first two probably didn't help since they didn't work before. It did work when I added the string so that's probably the solution, but this didn't work the first time either.

Hopefully my wasted hours would save someone's time.

Related Topic