Adding Additional Fields after Report Creation

[Jenny101]

Hello,

I am working in VB .NET and have included a Crystal Report that pulls it's data from a dataset in my application. That dataset is referencing an Access table. After creating and designing the report I decided to add a few more fields to the Access table. I updated the VB data adapter and the table mappings look fine. BUT when I go back to my report and look for the new fields in the Field Explorer I don't see them. Am I missing a step?

Thanks and hope I explained this well ...

 

[goranm]

Hi !

If you click on "Database" you will find "Verify Database".

Click on that and I think that you will see your new fields.

/Goran

 

[synapsevampire]

If this fails, there are cases when people have used Database->Set Location and repointed the report to the data source and then used a database->Verify database with success.

-k

 

[Jenny101]

Thanks for your suggestions. I recreated my data adapter and dataset then followed your instructions on verifying the database. The Field Explorer now shows that I removed one field (which is correct) but it still doesn't show the fields I added to the Access table. I don't get it ... why would it update the one field and not the others? It removed one but didn't add the others in??

The Table Mappings of the data adapter are correct and the schema for the dataset is also showing the correct fields.

Thanks again for your help -- it's greatly appreciated!

 

[dmitry1]

2synapsevampire

Hello! I had the same problem, and "Set Location" solves it, but dont you know, how can I do it (S.L.) from program code? (If I do only .database.verify, sometimes it do not work. And I cannot find a cause!)

 

[dmitry1]

I'm using vb6 & cr8.5