Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Filtering Data

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?

simple sample..

product total sales

ford #######

chevrolet ######

replied

Rod,

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.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question