?
Solved

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

Posted on 2011-09-28
7
Medium Priority
?
627 Views
Last Modified: 2012-06-22
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
0
Comment
  • 4
  • 3
7 Comments
 
LVL 19

Expert Comment

by:GJParker
ID: 36715157
Have you tried removing the field from the repprt and re adding ?
0
 
LVL 143

Author Comment

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

Expert Comment

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

can you upload the report with saved data
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 143

Author Comment

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

Author Comment

by:Guy Hengel [angelIII / a3]
ID: 36715630
here we go, the report has now only that field ...
CC35---ADSL-Install-ION.rpt
0
 
LVL 19

Expert Comment

by:GJParker
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

Cstr({DSL_MAILING.RESP_INST_PLANNED_TIME})


0
 
LVL 143

Accepted Solution

by:
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 !
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Integration Management Part 2
Screencast - Getting to Know the Pipeline
Suggested Courses

571 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