Formula Question - Select Borrower and Co-Borrower

[Anddmx]

Hi,

I need some help with formula that well allow me to select borrower and co-borrower from my table, problem is that both are in the same columns and I tired to right formula to extract both from the table but it still only pulls borrower name. There is column in the table that is BORR_CODE, this is how I knows who is borrower or co-borrower.

1 Table, 3 Columns

IF {BORRDATA.BORR_CODE} = "B1" THEN
{BORRDATA.BORR_LAST_NAME}
ELSE IF {BORRDATA.BORR_CODE} = "B2" THEN
{BORRDATA.BORR_LAST_NAME}

Above is formula that I tired and now it does work if I do add BORRDATA.BORR_CODE (is one of) B1, B2 with select expert but then I duplicate records on my report.

I am using crystal reports 11

Thanks

 

[Durango122]

hi
create a group base on the code
and place the formula field in the group footer

Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[Anddmx]

Hi,

I dont understand what you mean, because if I group them together then it well seperate them depending on BORR_CODE.

Can you give me more details on how to do this?

Thanks for reply.

 

[Madawc]

If you have duplicate records, then group them by whatever it is that is being duplicated - it can be a name or a formula field, provided the formula field only uses data from a single detail line.

Show the record details in the group header or group footer. Suppress the detail lines.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

I would insert a group on loan# (or whatever field you have like that), and then create two formulas:

//{@Borrower}:
if {table.code} = "B1" then {table.lastname}

//{@Co-Borrower}:
if {table.code} = "B2" then {table.lastname}

Place these in the detail section and insert maximums on them at the loan# group level. Then suppress the detail section.

-LB