Hi,
I am displaying key information on my report. That is numeric value. My user is asking me to highlight last 4 digits.
Using the below formula I break the value into 2 parts and formatted first one to left alignment and second one right alignment. This is working fine.
My report is look like this.
Ex: 1
Customer: United Airways
Fname: Johnson
Acc Key: 234<b>6792</b>
Ex: 2
Customer: AAA Airways
Fname: Johnson
Acc Key: 67845311<b>2341</b>
Upto this, it is fine. User is asking all the values must be in left alignment. Like Ex: 2.
I did couple of ways but not success. Pls guide me any one have idea.
Below formula’s I am using in my report
1)
if Length {1.Acc_key})) <> 0 then
numberVar len := Length ({1.Acc_key}) 4;
left{1.Acc_key}), len)
2)
if Length ({1.Acc_key}) <> 0 then
right({1.Acc_key }, 4)
I am using Crystal report 10 and SQL Server 2000.
Thank You!
Mure
I am displaying key information on my report. That is numeric value. My user is asking me to highlight last 4 digits.
Using the below formula I break the value into 2 parts and formatted first one to left alignment and second one right alignment. This is working fine.
My report is look like this.
Ex: 1
Customer: United Airways
Fname: Johnson
Acc Key: 234<b>6792</b>
Ex: 2
Customer: AAA Airways
Fname: Johnson
Acc Key: 67845311<b>2341</b>
Upto this, it is fine. User is asking all the values must be in left alignment. Like Ex: 2.
I did couple of ways but not success. Pls guide me any one have idea.
Below formula’s I am using in my report
1)
if Length {1.Acc_key})) <> 0 then
numberVar len := Length ({1.Acc_key}) 4;
left{1.Acc_key}), len)
2)
if Length ({1.Acc_key}) <> 0 then
right({1.Acc_key }, 4)
I am using Crystal report 10 and SQL Server 2000.
Thank You!
Mure