dotnetCharting Data Access Problem

[enreil]

Hello everyone,

I am working on a VB.NET project in VS 2003. I am utilizing dotnetCharting for my graphing and charting needs. I have hit something a little goofy and I'm wondering if one of you can help.

dotnetCharting seems to have difficulty with SQL that is slightly more advanced that the basic SELECT * FROM Products. Here's my query:

SELECT     exQuarter + ' ' + exYear AS Qtr, SUM(QNumEx - QMultNum) AS QNumEx
FROM         v_AggregateExTypes
WHERE     (isWholesale = 1) OR
                      (isRetail = 1) OR
                      (isFinancial = 1)
GROUP BY exQuarter, exYear
 

When I run the app, dotnetCharting fails to find any data. However, when I debug and grap the SQL command right before it is executed and run it in SQL Server myself, it returns exactly what I want. What is going on here?

I didn't know where else to ask this question. If there is a better forum, let me know. Thanks!