I've had some reports in existence now for quite a while and recently I had occasion to change the data type of some table columns from ASCII to Numeric. A couple of my L&L reports that show data directly from the tables (as opposed to from variables) steadfastly refuse to recognize the new data type. The image below shows an example, the indicated field should be a numeric - the .FD file has it as such and if I look at the table with dbExplor, it's a numeric there. How can I force the L&L designer to recognize the change? Curiously, in another table it did recognize the change.


Click image for larger version. 

Name:	WrongType.jpg 
Views:	173 
Size:	8.7 KB 
ID:	5003