Summarizing Group subtotals by group 1

[Rob7]

Hi,
This is a pretty common sales report, with sales dollars grouped first by salesman then by product group. This part was pertty straight forward. I would like to now total all sales by each product group. This is not so straight forward. I tried to use a Select statement by my syntax must not have been correct. Error indicated that beginning at my where clause, it was not part of the formula. I also would like to have a way not to hard code the actual product group names in so in the event that product groups are added in the future, these would not be excluded.

Thanks in advance.

Rob

 

[lbass]

The simplest solution would be to insert a crosstab in the report footer where you use the product as the row field and sales as the summary, with no column field.

-LB

 

[Rob7]

That was a killer solution. Thanks much. By the way, is there a good book on Crystal you would recommend? I think I will be needing it.
Rob

 

[lbass]

The George Peck books are good. Also check out Ken Hamady's website. The help section for CR is quite good, and I use it a lot. Then, of course, following threads here has been the most helpful of all.

-LB