crystal reports - add database field

[sdlangers]

hi,

 

i created a report in crystal reports using a dataset and populating it through xml (instead of connecting directly to the database)

 

it works correctly, but i then wanted to add another field to the dataset. i added it to the xsd file, but when i go to the crystal report and refresh the 'database fields' list it still does not show up

 

i tried re-running the custom tool on the xsd but that doesnt work

 

surely there is a way of getting it to recognize the new field without having to remove and re-add the 'database' - if i do this, i lose all the fields that i have already laid out, formatted etc.

 

thanks for your help!

[sdlangers]

nevermind- i found it

 

looks like the crystal report designer has some type of caching with the xsd 'connection' - so whenever i clicked verify database, it said it was up to date.

 

so i deleted the xsd, rebuilt, then closed down visual studio (which i think must have cleared the designer cache) and reopened it and then recreated the xsd, and clicked verify database in the report designer and it recognized the new field