Part of the data making bold and increasing the font size?

[nmmure]

Hi,

I am struck up to do the below req. I need to make bold and increase the font of last 4 characters of the string in report. I didn't get idea how to do this one. Any one guides me on this. Below I am giving example of my requirement.

Ex:
Data field value: 1021456ev123
45054x34b5t
Above 2 strings (data) coming from database, in report I need to show last 4 characters of each string in Bold and increasing the font.
Ex: Frist string : v123 is blod and increase the font size
Second string : 4b5t is bold and increase the font size

I am using SQL Server 2000 and Crystal reports 10.

Any help will be appreciated.

Thanks
Mure

 

[IanWaterman]

Provided your string is same length (11 chars), create two formulae

@end
right(fieldname, 4)

@start
left(fieldname, 7)

Place text box on report and then insert the two formula into the box, right click on the second formula and format as bold and larger font.

Ian

 

[AndyMc]

Mure,

For another approach, see this thread that talks about using html tags on a formula string.

http://www.tek-tips.com/viewthread.cfm?qid=1398197&page=1

Andy