Jump to content
Software FX Community

Chart FX 5.5 Not Showing Correct Graph


User (Legacy)

Recommended Posts

We were on version 4,5,18,1 and we just put the patch on our server to get

up to 5,5,10,2 and once that got downloaded to a clients desktop the graphs

stopped working. listed below is my asp code that worked in the previous

version of Chart FX, but doesn't work with 5.5. It looks like the new

version is bring back a dummy line chart because the data is nothing like

what I am looking for plus it's bringing back 2 lines where I had only one

line in the previous version and I ran the sql in the background to make

sure it wasn't that end of things and it wasn't.

Any help would be appreciated.

ASP Code:

<!-- #include file="../../Include/CfxIE.inc" -->

<html>

<head>

</head>

<body>

<%

Dim SPobj,Rs,Chart,sSQL,sCusip,RealCusip,iPosition

RealCusip = Request.QueryString("sCusip")

sSQL = "FinDatGetBond52Wk '" & RealCusip & "'"

Set SPobj = Server.CreateObject("DLBSystem.clsDBFunctions")

Call SPobj.GetRS(CStr(sSQL), Rs, CLng(180),"CorpSec","Connection")

Set Chart = Server.CreateObject("ChartFX.WebServer")

Chart.RgbBk = RGB(255,255,255)

Chart.Chart3D = False

Chart.Gallery = LINES

Chart.AxesStyle = CAS_FLATFRAME

Chart.Title(CHART_TOPTIT) = "Trailing Weekly Price History For " & RealCusip

& ""

Chart.AdoResultset Rs

'Chart.SerLegBox = False

Chart.OpenDataEx COD_COLORS, 2, 0

Chart.Color(0) = RGB(0,0,255)

Chart.CloseData COD_COLORS

Chart.Fonts(CHART_TOPFT) = CF_UNDERLINE

Chart.Axis(AXIS_Y).Decimals = 2

Chart.Axis(AXIS_Y).ForceZero = False

Chart.RecalcScale

'Chart.Series(0).MarkerSize = 2

Chart.Toolbar = True

Chart.DataEditor = True

Chart.AllowDrag = False

Chart.AllowEdit = False

Chart.Grid = 1 'Show the horizontal lines

if Chart.Axis(AXIS_Y).Min = 0 then

else

Chart.Axis(AXIS_Y).Min = Chart.Axis(AXIS_Y).Min - 5

end if

Chart.Axis(AXIS_Y).Max = Chart.Axis(AXIS_Y).Max + 5

Chart.Axis(AXIS_Y).AdjustScale

%>

<%=Chart.GetHtmlTag("100%","300")%>

</P>

</body>

</html>

Also listed below is the source code of the graph page:

<html>

<head>

</head>

<body>

<OBJECT CLASSID="CLSID:21F49842-BFA9-11d2-A89C-00104B62BDDA"

TYPE="application/x-oleobject"

WIDTH="100%" HEIGHT="300" ID="Chart1"

CODEBASE=/download/CfxIEAx.cab#Version=5,5,10,2

>

<PARAM NAME="LICENSE" VALUE="/license/CfxIE.lic">

<PARAM NAME="DATAPATH" VALUE="/cfxtemp/CFT0219_145727287.chw">

</OBJECT>

</P>

</body>

</html>

Thanks

Ian Dalton

Link to comment
Share on other sites

Looks like reading the file is failing.

Can you please attach the file ="/cfxtemp/CFT0219_145727287.chw", we need to

take a look to see what's wrong with it.

Also, make sure the file can be downloaded. To test this, try to access it

from your browser's address bar by preceding this URL with the current

page's URL. For example, if your page was at www.foo.com/folder/mypage.asp,

type in your browser's address bar:

www.foo.com/folder/mypage/cfxtemp/CFT0219_145727287.chw

If you get a "Saver as" dialog, everything is fine (then you need to send us

the file to see what's wrong with it) otherwise, you have a problem that has

nothing to do with upgrading to 5.5 but it has something to do maybe with

re-starting your server as changes you have made to it are reflected just

now.

--

FP

Software FX, Inc.

Link to comment
Share on other sites

You may also want to check your CfxSrv.ini to make sure the new version of

the client component (5.5.10.2) is pushed to your users, check the codebase

and pluginpage entries.

--

Regards,

JC

Software FX Support

"Ian Dalton" <idalton@dlbabson.com> wrote in message

news:ur7o#TF2CHA.1312@webserver1.softwarefx.com...

> We were on version 4,5,18,1 and we just put the patch on our server to get

> up to 5,5,10,2 and once that got downloaded to a clients desktop the

graphs

> stopped working. listed below is my asp code that worked in the previous

> version of Chart FX, but doesn't work with 5.5. It looks like the new

> version is bring back a dummy line chart because the data is nothing like

> what I am looking for plus it's bringing back 2 lines where I had only one

> line in the previous version and I ran the sql in the background to make

> sure it wasn't that end of things and it wasn't.

>

> Any help would be appreciated.

>

> ASP Code:

>

> <!-- #include file="../../Include/CfxIE.inc" -->

> <html>

> <head>

> </head>

> <body>

> <%

> Dim SPobj,Rs,Chart,sSQL,sCusip,RealCusip,iPosition

>

> RealCusip = Request.QueryString("sCusip")

>

> sSQL = "FinDatGetBond52Wk '" & RealCusip & "'"

>

> Set SPobj = Server.CreateObject("DLBSystem.clsDBFunctions")

> Call SPobj.GetRS(CStr(sSQL), Rs, CLng(180),"CorpSec","Connection")

>

> Set Chart = Server.CreateObject("ChartFX.WebServer")

> Chart.RgbBk = RGB(255,255,255)

> Chart.Chart3D = False

> Chart.Gallery = LINES

> Chart.AxesStyle = CAS_FLATFRAME

> Chart.Title(CHART_TOPTIT) = "Trailing Weekly Price History For " &

RealCusip

> & ""

> Chart.AdoResultset Rs

> 'Chart.SerLegBox = False

> Chart.OpenDataEx COD_COLORS, 2, 0

> Chart.Color(0) = RGB(0,0,255)

> Chart.CloseData COD_COLORS

> Chart.Fonts(CHART_TOPFT) = CF_UNDERLINE

> Chart.Axis(AXIS_Y).Decimals = 2

> Chart.Axis(AXIS_Y).ForceZero = False

> Chart.RecalcScale

> 'Chart.Series(0).MarkerSize = 2

>

> Chart.Toolbar = True

> Chart.DataEditor = True

> Chart.AllowDrag = False

> Chart.AllowEdit = False

> Chart.Grid = 1 'Show the horizontal lines

>

> if Chart.Axis(AXIS_Y).Min = 0 then

> else

> Chart.Axis(AXIS_Y).Min = Chart.Axis(AXIS_Y).Min - 5

> end if

> Chart.Axis(AXIS_Y).Max = Chart.Axis(AXIS_Y).Max + 5

> Chart.Axis(AXIS_Y).AdjustScale

> %>

> <%=Chart.GetHtmlTag("100%","300")%>

> </P>

>

> </body>

> </html>

>

> Also listed below is the source code of the graph page:

>

> <html>

> <head>

> </head>

> <body>

> <OBJECT CLASSID="CLSID:21F49842-BFA9-11d2-A89C-00104B62BDDA"

> TYPE="application/x-oleobject"

> WIDTH="100%" HEIGHT="300" ID="Chart1"

> CODEBASE=/download/CfxIEAx.cab#Version=5,5,10,2

> >

> <PARAM NAME="LICENSE" VALUE="/license/CfxIE.lic">

> <PARAM NAME="DATAPATH" VALUE="/cfxtemp/CFT0219_145727287.chw">

> </OBJECT>

>

> </P>

> </body>

> </html>

>

> Thanks

> Ian Dalton

>

>

Link to comment
Share on other sites

I attached the chw file you asked for. I was able to download the file. The

object that got downloaded to my machine was "Chart FX Internet Control

Date = 11/25/2002 Version = 5,5,10,2". I also attached the CfxSrv.ini.

Thanks for your help

Ian Dalton

"Ian Dalton" <idalton@dlbabson.com> wrote in message

news:ur7o#TF2CHA.1312@webserver1.softwarefx.com...

> We were on version 4,5,18,1 and we just put the patch on our server to get

> up to 5,5,10,2 and once that got downloaded to a clients desktop the

graphs

> stopped working. listed below is my asp code that worked in the previous

> version of Chart FX, but doesn't work with 5.5. It looks like the new

> version is bring back a dummy line chart because the data is nothing like

> what I am looking for plus it's bringing back 2 lines where I had only one

> line in the previous version and I ran the sql in the background to make

> sure it wasn't that end of things and it wasn't.

>

> Any help would be appreciated.

>

> ASP Code:

>

> <!-- #include file="../../Include/CfxIE.inc" -->

> <html>

> <head>

> </head>

> <body>

> <%

> Dim SPobj,Rs,Chart,sSQL,sCusip,RealCusip,iPosition

>

> RealCusip = Request.QueryString("sCusip")

>

> sSQL = "FinDatGetBond52Wk '" & RealCusip & "'"

>

> Set SPobj = Server.CreateObject("DLBSystem.clsDBFunctions")

> Call SPobj.GetRS(CStr(sSQL), Rs, CLng(180),"CorpSec","Connection")

>

> Set Chart = Server.CreateObject("ChartFX.WebServer")

> Chart.RgbBk = RGB(255,255,255)

> Chart.Chart3D = False

> Chart.Gallery = LINES

> Chart.AxesStyle = CAS_FLATFRAME

> Chart.Title(CHART_TOPTIT) = "Trailing Weekly Price History For " &

RealCusip

> & ""

> Chart.AdoResultset Rs

> 'Chart.SerLegBox = False

> Chart.OpenDataEx COD_COLORS, 2, 0

> Chart.Color(0) = RGB(0,0,255)

> Chart.CloseData COD_COLORS

> Chart.Fonts(CHART_TOPFT) = CF_UNDERLINE

> Chart.Axis(AXIS_Y).Decimals = 2

> Chart.Axis(AXIS_Y).ForceZero = False

> Chart.RecalcScale

> 'Chart.Series(0).MarkerSize = 2

>

> Chart.Toolbar = True

> Chart.DataEditor = True

> Chart.AllowDrag = False

> Chart.AllowEdit = False

> Chart.Grid = 1 'Show the horizontal lines

>

> if Chart.Axis(AXIS_Y).Min = 0 then

> else

> Chart.Axis(AXIS_Y).Min = Chart.Axis(AXIS_Y).Min - 5

> end if

> Chart.Axis(AXIS_Y).Max = Chart.Axis(AXIS_Y).Max + 5

> Chart.Axis(AXIS_Y).AdjustScale

> %>

> <%=Chart.GetHtmlTag("100%","300")%>

> </P>

>

> </body>

> </html>

>

> Also listed below is the source code of the graph page:

>

> <html>

> <head>

> </head>

> <body>

> <OBJECT CLASSID="CLSID:21F49842-BFA9-11d2-A89C-00104B62BDDA"

> TYPE="application/x-oleobject"

> WIDTH="100%" HEIGHT="300" ID="Chart1"

> CODEBASE=/download/CfxIEAx.cab#Version=5,5,10,2

> >

> <PARAM NAME="LICENSE" VALUE="/license/CfxIE.lic">

> <PARAM NAME="DATAPATH" VALUE="/cfxtemp/CFT0219_145727287.chw">

> </OBJECT>

>

> </P>

> </body>

> </html>

>

> Thanks

> Ian Dalton

>

>

Link to comment
Share on other sites

The attached chart file contains two series with the data as displayed in

the data editor. So the problem is not in the client component reading the

file, the file was generated this way by the server component.

Is the data shown incorrect ? Other settings seem OK like colors, fonts,

etc. It looks like the problem is only with the data.

Please check the file version of CFX4DATA.DLL in your server.

--

FP

Software FX, Inc.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...