searching in crystal

[teksecrets]

HI,
I'd like to search for the following data in my Crystal report.

My data field shows:

bos/username.

How would I go about searching to show only username. I'd like to eliminate bos/.

Any help would be appreciated.

Thanks.

 

[cmpgeek]

use this formula:

MID ({string},4)

that tells crystal to ignore the first 4 characters of that field when it prints ShannonLea
Computer Coordinator 4 Surgical Services
Athens Ga

 

[teksecrets]

hi again,
where would I enter this MID function?

 

[cmpgeek]

you would create a new formula...

enter the MID statement as the formula and save it...
when you place that formula field into the report and preview it it should have ignored 'bos/' and started with the next character after that... ShannonLea
Computer Coordinator 4 Surgical Services
Athens Ga

 

[teksecrets]

Great, Thanks so much!

 

[cmpgeek]

you're welcome! i'm glad i could help! ShannonLea
Computer Coordinator 4 Surgical Services
Athens Ga

 

[teksecrets]

When I try to create this formula, I get the error:
The result of selection formula must be a boolean. I'm using Crystal 8.5. Thanks.