cancel
Showing results for 
Search instead for 
Did you mean: 

Site Codes Missing in My Crystal Reports

Former Member
0 Kudos

Hi Anyone,

I am new to Crystal Reports Part of my job is to provide regional reports for a customer of mine. I run my report against a data file that has information I need for each customer site. Part of the information I need is site-code information that is assigned to each customer site like (8250, 4462, or 2435a etc...)  For some reason the Site-Code string is not working in the report unless it is a alpha-numeric code, for example (BT618 or 2435a). Any site-code ony numeric I can not list and have no clue why this is happening.

Any help anyone can provide would be appreciated.

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member260594
Active Contributor
0 Kudos

Hello Christopher,

Is your data file an Excel spreadsheet by chance?

If so check out the following MS KBase KB208414

Regards,

Graham

abhilash_kumar
Active Contributor
0 Kudos

Hi Christopher,

Check if the numbers have any spaces towards the end or start.

You may even try this formula:

Trim({sitefield})

-Abhilash

Former Member
0 Kudos

That is very curious...

This should not make a difference, but try fooling Crystal with a formula

if isnumeric({sitefield}) then totext({sitefield},0,"") else {sitefield}