Hello, this is probably easy but i'm newish to Crystal so i need some help. I have an SQL table that has data, lets use cars as an example.. mustang, escape, and corvette. I want to list this data in this report by say brand, which is not included in any table, so i need to have a row called Ford and have a column that summarizes the sales data for the mustang and escape, and the same for chevrolet which includes the corvette and so on. What is the best way to do this? I have tried creating a group, then using the select expert to select the entries for each brand but all it does is create a group with many empty rows below it suppressing the model before the next group. Any suggestions on the best way create this report?
product total sales
Graham Cunningham replied
As long as the makes and manufacturers stay somewhat consistent then you could group on Car and used specified order to create your own groupings.
To do this;
In the group expert highlight Car and select options
Change it from ascending order to specified order
Name the groups, ie Ford, GM, etc
After creating each named group click new and change from is any value to is one of and select the makes for that manufacturer.
You can summarize the data at the manufacturer level.