I am working on a report using Oracle Reports 6i that needs several
counts and summaries. I have the grand total summary for the report created and working fine. How I understand this is, if a total is needed on the report level, then it does not have to be within the
query but outside on its own with no linking. Now how would I create two subtotals? I only have one query and Oracle does not allow summaries for models if it exists in the parent query. Here is how I would like for it to be. The problem I am having is that I only have one query and oracle will not count it that way. There are other columns but this is the most important for sample purposes.


code
A459
A490
A501


subtotal for A codes: 3
B321
B234
B211
subtotal for B codes: 3


TOTAL for all codes: 6