Update DataSet in Crystal Reports

Question

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.

Have you tried typing the name of your class into the field? — Joshua Drake
You could also look at Crystal Report VerifyDatabase not working and tables not found during Verify Database for other things to try. — Joshua Drake
I do not use any classes for this (none that I'm aware of). Also, none of the articles you provided help, but thank you for trying. — Vlad Schnakovszki
Maybe, Adding a column to a DataSet (xsd) for a Crystal Report? — Joshua Drake
Updating Crystal Reports .NET if You Change the XSD sounds like it addresses the same issue. — Joshua Drake

Vlad Schnakovszki Vlad Schnakovszki · Accepted Answer · 2012-05-19T00:01:27

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.

I renamed the Formula Fields that had the same name as the DataTable columns I added.
I clicked the " ... " box and reselected the same file.
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.

Update DataSet in Crystal Reports

2 Answers