Field data type changed ... but format stays number ?

  I have a oracle 11 database, with a table, that has a column RESP_INST_PLANNED_TIME
  the field was NUMBER(10), and has now changed to varchar2(10)
  I have Crystal Reports 11.0, a report for that table, the field was shown as NUMBER.
  With "verify database", the field's type changed to "chaine[10] => string[10]

  So far, so good. the format field howver still thinks the fields is number, and "parse field values" shows only the numerical values, and empty/null for those that are not number anymore.

   how to trick it?
LVL 143
Guy Hengel [angelIII / a3]Billing EngineerAsked:
Who is Participating?
Guy Hengel [angelIII / a3]Billing EngineerAuthor Commented:
ah, I found it.
when refreshing the data, it now openend a window to check mappings for the fields vs the db fields.
I could uncheck the "respect data type" field, and then I could map the field to the column.

all good now !
Have you tried removing the field from the repprt and re adding ?
Guy Hengel [angelIII / a3]Billing EngineerAuthor Commented:
yes, no change
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

is it teh database field that you are using directly ?

can you upload the report with saved data
Guy Hengel [angelIII / a3]Billing EngineerAuthor Commented:
I will need a minute to modify the report to avoid customer data ...
Guy Hengel [angelIII / a3]Billing EngineerAuthor Commented:
here we go, the report has now only that field ...
Very strange - I've never seen that before

Have you tried adding the field to a completely new report to see if you get the same result ?

If you do need the field as a string then you could create a formula


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.