Hello,

I've got a problem here and I don't know if there is even a solution. I've tried using Global variables and Running Total Fields and neither are working for me.

Basically I have this

-- Group Header (Fund) --
-- Group Header (Bank) --
-- Group Header (Account) --
-- Details --
-- Group Footer (Account) --
-- Group Footer (Bank) --
-- Group Footer (Fund) --

With some random data

Fund,     Bank,     Account,     Transaction
Fund1,     Bank1,     1234,          23
Fund1,     Bank1,     1234,          -3
Fund1,     Bank1,     1234,          35
Fund1,     Bank2,     4444,          98
Fund1,     Bank2,     9999,          38
Fund2,     Bank1,     9876,          999
Fund2,     Bank2,     8374,          456

My report shows a transaction history for a list of funds. Each fund can have multiple banks, and each bank can have multiple accounts.

Let's concentrate on the Group Footer for Account. I want to suppress this footer if the fund has only one Bank, but show the footer if the Fund has multiple banks.

The problem here is I need to know the count of all the fund's banks before I ever start printing footers.

--

Running Total fields aren't working here, because like the name suggest they run with the total, so each footer I go to print has only the bank count up to that point. I've not found a way to get the count of all the banks.

Global variables seem like the way to go, but I run into a timing issue. I need to know the count of all the banks before I print the first footer. That puts me at having to count the banks WhileReadingRecords but I have no place to store the result to be used WhilePrintingRecords. If the report has multiple funds, I'll start to overwrite the result in my global variable.

I hope I've made myself clear. Any help would most certainly be appreciated!

--Michael

Hi Brian, thanks for the reply and a great book,

I understand exactly what you are saying in your reply, I even have tried to implement something like that to keep a running total of the banks.

Here's where it breaks down for me, if I was counting banks and wanted to suppress the bank footer, this would work great. However, I trying to suppress the Account Number footer, based on the count of banks. Recall that the account number group is grouped within the Bank.

Bear with me as I try to highlight my problem through what Crystal Reports is doing WhilePrintingRecords

Print Fund Header
Print Bank Header (Increment @BankCounter)
    Account Header
      Transaction
      Transaction
    Account Footer (Suppress? I need to know the TOTAL bank count at this point, even though I haven't iterated through all the data to have a total count yet.)

Once I figured out there was no getting past this WhilePrintingRecords, I thought, "Ok, I'll just count the banks WhileReadingRecords". This works great if there is only one Fund, but as soon as I show a report with multiple funds, the BankCounter is only going to represent the last fund shown on the report.

I don't see a way past this, unless it's possible to update/store a value WhileReadingRecords that I can later retrieve WhilePrintingRecords. I would need to store the count of banks for a particular fund.

Hope this makes more sense, and thanks for any help you might offer!
--Michael

I do think that will work, I'll post back if I run into any issues. Thanks for your help, both of you!