Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal report Formula

Status
Not open for further replies.

bhavesh2015

Programmer
Jun 4, 2015
1
US
|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



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top