How to refresh table fields?

[Former Member]

Hello all, I am somewhat new to developing in Crystal Reports, using Crystal Reports 11, and have a question. What is the easiest way to refresh the fields information about the tables in your report? For example, if a report was made, and then a field was added to a table the report uses, I notice it doesn't appear in the Crystal Reports field explorer.

I've gotten around it earlier by removing and re-adding the table in the database expert, but that loses everything on the report from that table, so I would imagine there is a better method, but have been unable to find it. Anyone know a better way to refresh the table fields in the field explorer?

I'd appreciate any responses, thanks.

[Former Member · Accepted solution]

Under database, there is a "verify database" option. That will refresh the tables. If you find yourself adding and deleting tables for other reasons, you can wrap your columns in formulas, and they won't disappear from the report when manipulating tables.