bhavesh2015
Programmer
|INVESTOR - INVESTMENTS#1#subsequent capital call.|INVESTOR CONTRIBUTIONS#2#Does not affect.|DISTRIBUTION PRINCIPAL#3#Does not affect|TO PARTNERS - REALIZED GAINS#4#Net of General.
I have shared variable with above string.
I have four transaction type and four footnote.
Transaction type Footnote
INVESTOR - INVESTMENTS subsequent capital call
INVESTOR CONTRIBUTIONS Does not affect
DISTRIBUTION PRINCIPAL Does not affect
TO PARTNERS Net of General.
now my crystal report display below
INVESTOR - INVESTMENTS(1) 100
INVESTOR CONTRIBUTIONS(2) 200
DISTRIBUTION PRINCIPAL(3) 500
TO PARTNERS(4) 700
where (1),(2),(3),(4) as display number which is assign in footnote.
(1)subsequent capital call
(2)Does not affect
(3)Does not affect
(4)Net of General.
Now my req. is to remove duplicate footnote.
It should be (This is completed)
(1)subsequent capital call
(2)Does not affect
(3)Net of General.
Based on above footnote assignment,
my report should display like this
INVESTOR - INVESTMENTS(1) 100
INVESTOR CONTRIBUTIONS(2) 200
DISTRIBUTION PRINCIPAL(2) 500
TO PARTNERS(3) 700
Can any one help to write a script in crystal report formula(may be array) that can resolve my issue.
Thanks
I have shared variable with above string.
I have four transaction type and four footnote.
Transaction type Footnote
INVESTOR - INVESTMENTS subsequent capital call
INVESTOR CONTRIBUTIONS Does not affect
DISTRIBUTION PRINCIPAL Does not affect
TO PARTNERS Net of General.
now my crystal report display below
INVESTOR - INVESTMENTS(1) 100
INVESTOR CONTRIBUTIONS(2) 200
DISTRIBUTION PRINCIPAL(3) 500
TO PARTNERS(4) 700
where (1),(2),(3),(4) as display number which is assign in footnote.
(1)subsequent capital call
(2)Does not affect
(3)Does not affect
(4)Net of General.
Now my req. is to remove duplicate footnote.
It should be (This is completed)
(1)subsequent capital call
(2)Does not affect
(3)Net of General.
Based on above footnote assignment,
my report should display like this
INVESTOR - INVESTMENTS(1) 100
INVESTOR CONTRIBUTIONS(2) 200
DISTRIBUTION PRINCIPAL(2) 500
TO PARTNERS(3) 700
Can any one help to write a script in crystal report formula(may be array) that can resolve my issue.
Thanks