SUBCOUNTS

  • Thread starter Thread starter JAEGER
  • Start date Start date
J

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.
 
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?
 
Back
Top