how to pull data for customer #2 using same fieldname as #1 1

[coconutgirlll]

Crystal 9.2
i'm trying to pull the income for customer #2 (and #3, #4 and so on), but the income field for all customers on the loan is the same field: {mp-borrower.borr-pay}

to pull for customer #1, my simple formula is:
if {mp-borrower.borr-nbr} =1 then {mp-borrower.borr-pay}...
substituting "=1" with "=2" doesn't work.

please help

 

[Madawc]

It's not clear what you're after. You could do a crosstab with borr-nbr and income. Or group by borr-nbr.

If you're wanting to process two or three customers as a group, add the table (dataset) twice, the second time as an alias. Also a third and fourth time as aliases, if that's necessary.

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

 

[dgillz]

I agree, it is not clear what you are trying to do. Have you looked at the next() function?

Can you post sample data and desired results? Also your version of crystal and your database type and connectivity used would help.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[coconutgirlll]

Thank you both for responding.

Crystal 9.2
SQL 10.0B
DataDirect 4.2
ODBC

it's a Catch22...

I'm trying to pull the income for each customer on the account without having each customer name appear on the report (I only want the primary customer on account to appear on my report). So my selection criteria includes {mp-borrower.borr-nbr} = 1...which prevents data for other customers from being pulled.
{mp-borrower.borr-nbr}=1, =2, =3, is the only distinction between the customers.. their income field is the SAME field {mp-borrower.borr-pay}.

Am I being clear as mud?

 

[LizSara]

Yup, i think you want to group by customer name and then put the field where thier income is stored in the details section...but you could want to do something totally different

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you." ~ Nietzsche"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

http://bionicyoghurt.blogspot.com/

 

[lbass]

Group on the account, sort on the {mp-borrower.borr-nbr} ascending, and then place the fields in the group header and suppress the detail section.

-LB

 

[coconutgirlll]

lbass, i love you!!! it worked! that was so simple I'm pounding my fist to my head for being so slow on this.

Thanks so much!