SUBCOUNTS

[JAEGER]

I NEED TO CREATE REPORT THAT HAS TWO SUBCOUNTS. FIRST BY
DIVISION WHICH I AM CREATING BY GROUPING AND THEN PLACING
THE DIVISION IN THE GROUP FOOTER. SECOND WITHIN EACH
DIVISION, BY CODE. SO IF THE DIVISION WERE CONTRACT, I
WOULD NEED COUNTS FOR TYPES P, S, M, AND OTHER. THE NEXT
DIVISION MIGHT BE ISLANDS, WITH THE SAME SUBCOUNTS AND SO
ON. THERE ARE A TOTAL OF SIX DIVISIONS THAT COULD BE ON A
REPORT. IN THE DETAIL SIDE OF THE DIVISION WOULD BE THE
INDIVIDUAL ACCOUNTS THAT MAKE UP THE DATA FOR THE
SUBCOUNTS.

I HAVE NO PROBLEM WITH THE DIVISION GROUP. I AM HAVING A
PROBLEM GETTING THE SUBCOUNTS. I HAVE BEEN HAVING THE
PROBLEMS WITH THE SUBCOUNTS. I HAVE TRIED SUMMARY QUERIES
AND HAVE TRIED DOMAIN FUNCTIONS IN UNBOUND FIELDS, BOTH
WITHOUT SUCCESS. ANY SUGGESTIONS.

 

[Duane Hookom]

PLEASE find your caps lock key and press it! Using all caps is considered
SHOUTING and is very difficult to read. Most of the time I don't even try.
However, have you tried creating a sorting level on code and adding the
counts in the code footer?