cfchart seriesplacement="stacked" CFMX7 problems

[dentarthurdent]

Hi,

I upgraded our server over the weekend to MX7 enterprise. I have a problem
with charts now that do not work as they did in MX6.1. An example is this one
and the problem seems to be with the seriesplacement="stacked" parameter and
only one column of information being returned. So imagine you have a stacked
chart of information and clicking to drill down will give you the part of the
chart you click on in more detail. This now does not work.

<cfchart
seriesplacement="stacked"
format="flash"
yaxistitle="Number"
xaxistitle="Departments"
showxgridlines="yes"
showygridlines="yes"
show3d="no"
showborder="no"
font="Arial"
fontbold="no"
fontitalic="no"
sortxaxis="yes"
showlegend="no"
Chartwidth="450"
chartheight="300"
scalefrom="0"
scaleto="#chartsize#"
gridlines="#gridsize#"
url="#currentpage#?dept=$ITEMLABEL$">

<cfchartseries
type="bar"
query="chartdata"
itemcolumn="dept"
valuecolumn="count1"
serieslabel="count1"
seriescolor="##669999"
paintstyle="plain"/>

<cfchartseries
type="bar"
query="chartdata"
itemcolumn="dept"
valuecolumn="count2"
serieslabel="count2 "
seriescolor="##ffcc00"
paintstyle="plain"/>

<cfchartseries
type="bar"
query="chartdata"
itemcolumn="dept"
valuecolumn="count3"
serieslabel="count3"
seriescolor="##cc3333"
paintstyle="plain"/>
</cfchart>

I have changed one or two pieces here so it does not compromise anything,
however this is only the lables and valuecolumns.

This worked Friday in MX6.1 and now in 7 it does not. I have tried a lot of
things but all I get is a blank chart, lables show but no data. I have checked
and the query is outputing data as expected.

HELP!!!!

Steve

[dentarthurdent]

Anyone?

[realbeaux]

They had a serious step back in the CFCHART tag between 6.1 and 7. :| They
are working on a TechNote.

In another thread on this forum there was a tenative release of a TechNote on
these issues due last week per Prayank. Search "Advanced Techniques" for
cfchart and you will see lots of issue with MX 7 and CFCHART. Hopefully, soon
they will have hotfixes.