I'm making an application that will be using Crystal Reports to generate some reports.

I have a question about how I am storing my data in the database. This is an example of how my data looks after it is being queried:

CustomerID CustomerType Products
---------- --------------- ------------------
1 Online, Phone product a, product b
2 Instore, Online product c, product d

My report is suppose to be a cross-tab report displaying the totals. My question is crystal reports smart enough to recognize the commas in the data fields? Will it recognize Online as 2 entrys or will it read it as Online, Phone and Instore, Online?

Or does my data need to look like this:

CustomerID CustomerType Products
---------- --------------- ------------------
1 Phone product a
1 Online product b
2 Online product c
2 Instore product d

Does anyone know?

I would say the second example is how you should store your data. Trying to determine where the commas are and how they are supposed to break out would be a nightmare in my opinion. Hope that helps..good luck!