Crystal Report Field .....

Question

0.00/5 (No votes)

See more:

hi there,

in crystal report i have a filed with name country which display countries name.
like.......

India
America
Australia

now i want only first three characters in reports.
like.......

Ind
Ame
Aus

thanks.

Posted 18-Sep-12 18:27pm

Aniruddh Bhatt

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aarti Meswania · Accepted Answer · 2012-09-18T18:39:00

Solution 1

drag drop your country field on report

open property by right click that field -> Format Object
on that page at below you will see display string and a button x+2
click that button and put below formula in editor
YourCountryField=> select it from Report Fields -> your contryname field
e.g. {Table.CountryNm}

MID(YourCountryField, 1,3)

Happy Coding!
:)

Posted 18-Sep-12 18:39pm

Aarti Meswania

Updated 18-Sep-12 18:53pm

v2

Comments

Aniruddh Bhatt 19-Sep-12 1:08am

thanks, it works.

Aarti Meswania 19-Sep-12 1:09am

welcome, Glad to help you! :)

Crystal Report Field .....

1 solution

Solution 1

Add your solution here

Preview 0

Crystal Report Field .....

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us