We changed the data type from CHAR(10) to INT of a few fields from 2 TABLES in the DB. These 2 TABLES already existed in the Impromptu Catalog. We also created 2 new VIEWS in the DB that are based on the 2 TABLES that had a few fields undergo a data type change.
I brought these 2 new VIEWS into the Impromptu Catalog for the first time, and when I report on on the VIEW's field that underwent a data type change in the TABLE, all I get is #FORMAT#. However, for the 2 TABLES that already existed, I removed them from the catalog and re-added the TABLES and all was well.
I've highlighted the column in the Impromptu report (the one pulling from a VIEW) and went to Format | Data and the values are previewed fine when the data is formated "General". The report however, still displays #FORMAT#.
Any thoughts?
I brought these 2 new VIEWS into the Impromptu Catalog for the first time, and when I report on on the VIEW's field that underwent a data type change in the TABLE, all I get is #FORMAT#. However, for the 2 TABLES that already existed, I removed them from the catalog and re-added the TABLES and all was well.
I've highlighted the column in the Impromptu report (the one pulling from a VIEW) and went to Format | Data and the values are previewed fine when the data is formated "General". The report however, still displays #FORMAT#.
Any thoughts?