grouping on a group

[akirk]

I am having trouble solving a problem. I have grouped a number of products by their associated license number. Each group (license) therefore has a number of products associated with them (1-50). I need to group the licenses by the number of products associated with it, then get a total of the number of licenses with 3 or fewer products, 4 products, and 5 or more products.

I have tried this a couple of ways, including appending the product detail into a string, then getting the length of the string, but am stumped on the next step (grouping based on a formula located in a group footer).

any help is appreciated.

kirk

 

[kenhamady]

You can't group based on a summary value. But I still think you can do what you want.

Add a count of products for each license using "Insert Summary".

Then use the TopN feature to sort the groups in Asc. order based on this subtotal. That will put them lowest to highest.

To get a count of the groups you will have to use running total that is a distinct count of the license, each with a different evaluate condition:

Count (Product,License) <4
Count (Product,License) =4
Count (Product,License) >4
These can all be placed in the REport footer. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[akirk]

Hi Ken,

Thanks for the help, the totals worked out correctly.

kirk