Columns added to a view don't show up

[jowilliams]

I'm amending an existing report in Crystal 6.0. The report uses data from a view.

I've added a couple of columns to the view. When I try to create a formula using the new columns, they're not available in the list of fields.

If, however, I create a new report and select the view, I can 'see' all the columns, including those I just added.

Is there aomething I need to amend in the old report to enable it to recognize the new columns?

 

[kenhamady]

Go to the database menu of the report and select "Verify Report". Crystal keeps a memory of the structure, and this forces it to reread the structure. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[jowilliams]

.Database>Verify Database, right? That worked a treat. Presumably I would need to do that for any DDL statements that were executed on my tables/views...

many thanks