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

Posted on 2011-09-28
Last Modified: 2012-06-22
  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?
  • 4
  • 3
LVL 19

Expert Comment

ID: 36715157
Have you tried removing the field from the repprt and re adding ?
LVL 142

Author Comment

by:Guy Hengel [angelIII / a3]
ID: 36715485
yes, no change
LVL 19

Expert Comment

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

can you upload the report with saved data
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

LVL 142

Author Comment

by:Guy Hengel [angelIII / a3]
ID: 36715623
I will need a minute to modify the report to avoid customer data ...
LVL 142

Author Comment

by:Guy Hengel [angelIII / a3]
ID: 36715630
here we go, the report has now only that field ...
LVL 19

Expert Comment

ID: 36715703
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


LVL 142

Accepted Solution

Guy Hengel [angelIII / a3] earned 0 total points
ID: 36715735
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 !

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now