Field contains text or number 1

[nuttyernurse]

Good afternoon all!

I am using Crystal Reports 2011 and I have a problem with a field. This field mostly contains text, but sometimes contains numbers.

Sample of data is:
kerlix
kling
21
13

When I display the report, the numbers are not present, just a blank line shows. I have tried the ToText function without success.

Any suggestions would be greatly appreciated.

Thank you!

 

[Turkbear]

Hi,
Are you just placing the field in the report or is it part of a formula ? You should not need to use any function to display it if it is just placed in the report.








To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[nuttyernurse]

Turkbear,

Originally I did not try a formula, just the actual field. The data is from an excel spreadsheet, I even tried changing the field type, but that didn't work either. I can see the data in the excel file, so I know it isn't a null field. I have attached a link to the report (rough draft) and if you change the rpt extension to xls, you can get the excel file as well.

Thank you!!!!!!

 

[Turkbear]

Hi,
Changing the extension does not work ( at least in W7) - it throws an invalid file type error.
I do not have CR installed so I cannot help with the rpt format.

What connection method are you using to extract the Excel data?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

See the very end of this thread: thread149-1516532. Using the text to column wizard in Excel seemed to do the trick.

-LB

 

[nuttyernurse]

Ibass,

That worked! I have never encountered that, but will know when working with mixed data in excel to use text to columns.

Turkbear,

I was connecting to the excel file through the data connection wizard. Thanks for helping!

NuttyERnurse