Summary Columns with reports builder only 1 query....
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.
subtotal for A codes: 3
subtotal for B codes: 3
TOTAL for all codes: 6