Need Help! Sub-totals within Sub-Totals

Need Help! Sub-totals within Sub-Totals

Post by Diane L. Emmi » Mon, 16 Sep 1996 04:00:00

How do you do Sub-totals within another Sub-Totals on Visual FoxPro
reports? I am doing a financial report for a client.  

For example, I need to sub-total Revenues and then add another revenue
category and create another sub-total.

Can anyone help?

Thanks in advance.

Diane Emmich


1. Count() : sub-totals and grand total ?

I have a question which is probably fairly simple to answer, but I just
can't do it :-)

Let's assume we have a table T  with one column c1 accepting nulls.
I want to know, how many instances of each different non null value of
c1 exist in this table, so I use the following query :

select c1, count(*)
from  T
where c1 is not null
group by c1

This produces for instance :

------------    ------
value1          10
value2          123

My question is what query should I write to get this AND a grand total ?
I was thinking of using a 'compute' clause but I'm unable to make it
work ...
The Transact-SQL help and docs are of no help at all.

All suggestions welcomed. Mail answers preferred.
Thanks in advance.

2. Olap - external authentification via LDAP

3. How can I extract sub-total from a sub-report into the main report

4. Oracle Openings DC Area

5. SQL Query Question

6. Sub total help with filemaker Pro 4.1

7. 461 error - (couldn't resist)

8. SubTotal And Grand Total

9. How I get Grand Total And SubTotal....

10. MDX - Blank sub/grand totals

11. Sub-Totals via SQL

12. Sub Totals