Evaluation Formula Help

[huskerfan1]

Hello. I am not a programmer and need some assistance. I am grouping on a customer ID and then on an account number.

In detail section A I need a formula that prints the account numbers for a customer and the account name. So if the next three accounts numbers all fall under the same customer ID I need to print all 3 account numbers on under another. Does anyone know how I can do this.

 

[Naith]

If you are already grouping by Customer ID and then by Account, if you just place the Account Names and Numbers in the detail section, the report will automatically sort them according to the grouping.

Naith

 

[huskerfan1]

That would work normally, but I need the account names to Print in the Header for Each Customer. I wasn't clear earler. For example,

In header----
customer 45 Scott Davis

You receive information for the following accounts:
Fund 345 - Scholarship
Fund 67 - Fund A
Fund 347 - Endowed Chair

 

[Naith]

Place the customer information in the Customer header, and the fund information in the Account group header, and suppress the details section, and Account group footer.

Does that give you what you want?

Naith

 

[huskerfan1]

That would normally work too, but I am using detail sections for other things. I really need a formula that performs some sort of variable decleration and stores the account names and then allows me to print all the account names associated with that entity in the header.

 

[Naith]

Hey Huskerfan,

Are you talking about this:

Customer: Bob
Account1: Cash
Account2: Bucks
Account3: Money

Cash Details.....
Bucks Details.....
Money Details.....

instead of this:

Customer: Bob
Account1: Cash

Cash Details....

Account2: Bucks

Bucks Details....

Account3: Money

Money Details....

Because if you are, you're going to have to insert a subreport in Customer Header B, which groups by Customer, but only displays the Accounts.

Naith

 

[huskerfan1]

Yes, Exactly.

I figured I might have to subreport it, but I hate that since is slows performance. Thanks for your help!