|
| |
|
|
HW15
Posts: 57
Joined: 3/12/2004
Status: offline
 |
FP2003 Charts - 4/18/2004 18:49:14
I have been creating charts using FP2003's web components. The charts are based on a SQL database and stored procedures I have created. But, all the data fields keep showing up in alphabetical order even though I have specified an 'order by' statement in SQL.
Example:
SELECT sa_ISDProjects.Category.CategoryName, COUNT(*) AS #
FROM sa_ISDProjects.Project
INNER JOIN sa_ISDProjects.Category
ON sa_ISDProjects.Project.CategoryID = sa_ISDProjects.Category.CategoryID
WHERE sa_ISDProjects.Project.CategoryID <= 4
GROUP BY sa_ISDProjects.Category.CategoryName
order BY sa_ISDProjects.Category.CategoryName DESC
It still puts the results in alphabetical order
I want it where the categories are in order of importance, with Top 10 first. This happens to be descending alphebetical order. But, the chart ignores any 'order by' statements.
The same happens on other charts when I want the fields for the months in order of Jan through Dec; it puts April first and September last.
Is there any way around this?
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
