Snapshot Report

[Shari]

Hi,

I need to produce a report that shows counts of field information for all records of a given class ID. For example, I have a field called Polling, the data is either yes or no. I have another field called status, which has different data. I need a report that shows the specific class, with a count for each data element in the different fields. I need this for all the classes.

How can this be accomplished?

Thanks.

[kenneth2k1]

Hi Shari:

"How this can be accomplished," is rather broad, so I apoligize if this seems kinda general.

I think what you want to have is a sub-summary report sorted by class ID.

Enter Layout Mode and go to Layout/New Layout. Select Columnar list/report and click next. Then select a report with grouped data. Follow the wizard and put fields where you want them to belong in the report. Then you will need to sort the database by class ID and view the report layout in preview mode. Sorry if this is not that accurate, I'm doing it through memory.

If this is not what you are looking for, please be more specific.

Ken

[Shari]

Thanks Ken,

This is fine. However, I want to view each class only once with the total of all records. This gives me the Class ID and then each record with the totals. I only want to view the totals once for each class.

Example: Class A

Total Registeted Total Corp. Emplyoees Total Canadian Employees

8 3 5

Class B

Total Registeted Total Corp. Emplyoees Total Canadian Employees

6 5 1

Thanks,

Shari

[Riley Waugh]

Shari,

Stick with Ken, he'll get you there.

If you make a new summary field called 'total_employees' which is a count of your field 'employees', then go put it on a layout (with nothing in the body), (or no body), in a sub-summary part when sorted by your field 'Class', the resulting form will be

835

651

if you put the field for Class (without a label) in the sub-summary part, before the new summary field, then your report will look like

A 835

B 651

Add some labels and off you go.

Now, try adding a leading grand summary or trailing grand summary part and put that same summary field in that part for a total total.