I am using FC for Dreamweaver, my problem is when I create a Recordset with the following query I have NO Labels on my chart:
SELECT SUM(opportunity.Jan_Amount), SUM(opportunity.Feb_Amount), SUM(opportunity.Mar_Amount), SUM(opportunity.Apr_Amount), SUM(opportunity.May_Amount),SUM(opportunity.Jun_Amount), SUM(opportunity.Jul_Amount),SUM(opportunity.Aug_Amount), SUM(opportunity.Sep_Amount), SUM(opportunity.Oct_Amount), SUM(opportunity.Nov_Amount), SUM(opportunity.Dec_Amount)
FROM opportunity
WHERE opportunity.Product_Service='Printers'
This query totals the amounts in their respective columns; Jan_Amount Feb_Amount etc..
I have also tried the SELECT statement like this: SELECT SUM(opportunity.Jan_Amount) as Jan, SUM(opportunity.Feb_Amount) as Feb, etc....
My goal is to have each months total display as a series with corresponding labels.
Thanks for any help!