Totals Appearing Twice in Pie Chart

[joannef]

Using Crystal Reports 10, when creating a pie chart from a SQL 2000 sp to be used in a VB .NET application, it is duplicating the totals it is pulling from the database (Counts the different types of data). Anyone have an idea why?

Thanks for the help in advance.

Joanne

 

[synapsevampire]

Run the SP in Query Analyzer, if it returns the right data, then it must be a problem in CR 10, or how you set up the SP within.

Did you use Add Command to execute the SP, or point directly at it from within CR?

Try the opposite to see if that helps

-k