Creating count from queried fields

[Former Member]

Post Author: John

CA Forum: Formula

Hello all. Newbie here to the forum and CR.

Running CR 9

I have a report that extracts certain data from the database. A field that displays "test code", is not part of the original search criteria. I have been asked to total "test code" but, I don't know how to count the records from the extracted data.

For example, I'm pulling in everyone with a last name that begins with a "J" and who came in the store from 01/01/07 - 01/31/07. I then list the data and also print their address, city, state, zip, and "test code". The "test code" is one of 3 possible codes. I want to have 1 running total for each of these 3.

My knowledge allows me to create a running total on the field but, the total is from ALL of the records that match.

So, if we had 45 people with "J" and 01/01/07 - 01/31/07, the running total will be 67 because it is finding all data sets that match it's code. It isn't pulling from the original search criteria of "J" and 01/01/07 - 01/31/07.

Any help is appreciated.

John

[Former Member]

Post Author: John

CA Forum: Formula

OK... well.. this is still a problem for me.

So, I have 6 instances of a sale and the report is suppressing 5 of those instances because they are all by the same person on the same day. So, when I put my running totals in, it is counting 6 of them instead of the 1 that is displayed. I have tried the "WhilePrintingRecords" formula and have tried every form of total that has been mentioned. None of them will count only what is displayed.

Anyone have any ideas on how to total only the printed instances?

Also, I placed a formula on the Detail level that said

WhilePrintingRecords;

NumberVar Count1;

If {ProductInventory.ProductID} = "FFP" Then

Count1 := Count1 + 1

This still gave me a count of all instances.