michellecole
Programmer
Crystal 8
Microsoft Access
I have a Main report displaying CustomerIDs. For each CustomerID there are (3) unlinked subreports - one is displaying AccountIDs, one is displaying SiteIDs and one is displaying ScannerIDs. I would like to have a grand total at the bottom of the Main report reflecting a count of total AccountIDs from the AccountID subforms. I have been reading other posts and have confused myself on the best approach to accomplish this. I believe I want to go the "Shared Variable" route, but I am unsure of what and where I need to code things.
Here is a skeleton of my "Customer" report:
RH
PH
Da tblCustomers.CustomerID
CustomerSubReport_Accounts
Db CustomerSubReport_Sites
Dc CustomerSubReport_Scanners
RF
PF
I have read a lot about text fields and formula fields and WhilePrintingRecords - but I don't know if I should be creating "Formula Fields" and if so, what is the formula syntax and where should the formula fields go? Do I have to DIM a Shared Variable. Feel free to start a duh for me on this one.
Your help is greatly appreciated!
Thank you,
Michelle
Microsoft Access
I have a Main report displaying CustomerIDs. For each CustomerID there are (3) unlinked subreports - one is displaying AccountIDs, one is displaying SiteIDs and one is displaying ScannerIDs. I would like to have a grand total at the bottom of the Main report reflecting a count of total AccountIDs from the AccountID subforms. I have been reading other posts and have confused myself on the best approach to accomplish this. I believe I want to go the "Shared Variable" route, but I am unsure of what and where I need to code things.
Here is a skeleton of my "Customer" report:
RH
PH
Da tblCustomers.CustomerID
CustomerSubReport_Accounts
Db CustomerSubReport_Sites
Dc CustomerSubReport_Scanners
RF
PF
I have read a lot about text fields and formula fields and WhilePrintingRecords - but I don't know if I should be creating "Formula Fields" and if so, what is the formula syntax and where should the formula fields go? Do I have to DIM a Shared Variable. Feel free to start a duh for me on this one.
Your help is greatly appreciated!
Thank you,
Michelle