crystal reports - add database field

S

sdlangers

Well-known member
Joined
Dec 3, 2002
Messages
118
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!
 
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
 
Back
Top