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:
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!
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:
Code:
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
I didn't know where else to ask this question. If there is a better forum, let me know. Thanks!