Refusal to Suppress?

[Crazycritter1]

I have a report that is supposed to report the occurance of multiple balances on one record - for instance:

Mr. Smith has a bank account with a main account number, which is being used to pull the record. Next, from within that record, Mr. Smith has 2 savings accounts and 3 loan accounts, each with their own balance.

My output on the record is supposed to look like this:

12345 Mr. Smith Saving1 $100.00 Loan1 $100.00
Loan2 $200.00
Loan3 $300.00
Saving2 $200.00

However, What I am getting, is when the Saving2 entry is displayed, the report then goes ahead and DUPLICATES the entries for loan1,2, and 3.... so I end up with:

12345 Mr. Smith Saving1 $100.00 Loan1 $100.00
Loan2 $200.00
Loan3 $300.00
Saving2 $200.00 Loan1 $100.00
Loan2 $200.00
Loan3 $300.00

There is suppression in use that is successfully working for the name, AND for the saving1 and saving2 fields and balances - because each would fill in the blank space with duplicate information. But my loans won't suppress the same way.

Is there a way to have the suppression for the loan information be conditional to only print on the occurance of the saving1 data? Every account will have a saving1, but the saving2 data does not occur with each record...

Thanks once again -you all are great!

 

[Crazycritter1]

Sorry - those columns didn't align properly - the savings and loan data should be aligned under each-other.

 

[kskid]

What is the link that ties the loan to the savings? Is there a unique subaccount?

 

[kskid]

A layout of the sample input date would be helpful.

 

[Crazycritter1]

I actually just figured it out - I created a formula that looked at whether the "savings1" record was true or false, and then went into the loan1 record, and loan balance record, and suppressed based on a false condition... it worked great. I'm really surprised that I got it to work by playing with it since the post, being as I'm still completely "green" with this program!

I must be catching on to some of this after all of the questions I've bounced off all of you. Thanks for keeping an eye out here!