Version: Crystal XI
SQL2000 DB
I have a result set from a stored proc in SQL2000. Each Record has a customer reference number, an effective date (will be 1 of 2 possible dates), what product they were using on that effective date.
What I would like to do is graphically show movement in the amount of customers using each product on the 2 effective dates that are contained in my recordset that is if product A has 10 people more using it or 10 people less, product B and C etc.
Now what I have done which is probably wrong is make group 1 based on the effective date (giving me 2 groups). I have then grouped on product giving me lots of product groups for each of the effective dates. I can chart that fine, what I am having trouble doing is showing the difference for each product on the 2 dates. So if product A has 10000 customers using it on the 1st of Dec and 8000 today, how can I have a chart that shows product A as -2000?
Sorry for the long question I just want to explain it properly.
SQL2000 DB
I have a result set from a stored proc in SQL2000. Each Record has a customer reference number, an effective date (will be 1 of 2 possible dates), what product they were using on that effective date.
What I would like to do is graphically show movement in the amount of customers using each product on the 2 effective dates that are contained in my recordset that is if product A has 10 people more using it or 10 people less, product B and C etc.
Now what I have done which is probably wrong is make group 1 based on the effective date (giving me 2 groups). I have then grouped on product giving me lots of product groups for each of the effective dates. I can chart that fine, what I am having trouble doing is showing the difference for each product on the 2 dates. So if product A has 10000 customers using it on the 1st of Dec and 8000 today, how can I have a chart that shows product A as -2000?
Sorry for the long question I just want to explain it properly.