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

Hi,
 
  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?
cr-data-type.JPG
LVL 143
Guy Hengel [angelIII / a3]Billing EngineerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor 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 !
0
 
GJParkerCommented:
Have you tried removing the field from the repprt and re adding ?
0
 
Guy Hengel [angelIII / a3]Billing EngineerAuthor Commented:
yes, no change
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
GJParkerCommented:
is it teh database field that you are using directly ?

can you upload the report with saved data
0
 
Guy Hengel [angelIII / a3]Billing EngineerAuthor Commented:
I will need a minute to modify the report to avoid customer data ...
0
 
Guy Hengel [angelIII / a3]Billing EngineerAuthor Commented:
here we go, the report has now only that field ...
CC35---ADSL-Install-ION.rpt
0
 
GJParkerCommented:
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

Cstr({DSL_MAILING.RESP_INST_PLANNED_TIME})


0
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.