User (Legacy) Posted October 18, 2004 Author Report Share Posted October 18, 2004 I am having a problem with Chartfx Lite. I am using Chartfx Lite to display monthly usage of one of our products. But if the recordset return from my stored proc shows a client has never used our product and I set all .values to 0 my application hangs I'll have to restart. As long as I set one of the .values to a positive value everything fine. This only happens if I have to set all .values to 0. Does anyone know how to overcome this problem? I have included my code. Many thanks in advanced. With Chart1 .ToolBar = False .Gallery = Gallery.Bar .Border = True .AxisY.Max = 2 .AxisY.Min = 0 .Chart3D = True .Grid = ChartGrid.Horz Or ChartGrid.Vert .OpenData(COD.Values, 2, 6) .Value(0, 0) = rdr.Item("nLevel1") .Value(1, 0) = rdr.Item("nLevel2") .Value(0, 1) = rdr.Item("nLevel3") .Value(1, 1) = rdr.Item("nLevel4") .Value(0, 2) = rdr.Item("nLevel5") .Value(1, 2) = rdr.Item("nLevel6") .Value(0, 3) = rdr.Item("nLevel7") .Value(1, 3) = rdr.Item("nLevel8") .Value(0, 4) = rdr.Item("nLevel9") .Value(1, 4) = rdr.Item("nLevel10") .Value(0, 5) = rdr.Item("nLevel11") .Value(1, 5) = rdr.Item("nLevel12") .CloseData(COD.Values) .RecalcScale() End With Link to comment Share on other sites More sharing options...
User (Legacy) Posted October 18, 2004 Report Share Posted October 18, 2004 I am having a problem with Chartfx Lite. I am using Chartfx Lite to display monthly usage of one of our products. But if the recordset return from my stored proc shows a client has never used our product and I set all .values to 0 my application hangs I'll have to restart. As long as I set one of the .values to a positive value everything fine. This only happens if I have to set all .values to 0. Does anyone know how to overcome this problem? I have included my code. Many thanks in advanced. With Chart1 .ToolBar = False .Gallery = Gallery.Bar .Border = True .AxisY.Max = 2 .AxisY.Min = 0 .Chart3D = True .Grid = ChartGrid.Horz Or ChartGrid.Vert .OpenData(COD.Values, 2, 6) .Value(0, 0) = rdr.Item("nLevel1") .Value(1, 0) = rdr.Item("nLevel2") .Value(0, 1) = rdr.Item("nLevel3") .Value(1, 1) = rdr.Item("nLevel4") .Value(0, 2) = rdr.Item("nLevel5") .Value(1, 2) = rdr.Item("nLevel6") .Value(0, 3) = rdr.Item("nLevel7") .Value(1, 3) = rdr.Item("nLevel8") .Value(0, 4) = rdr.Item("nLevel9") .Value(1, 4) = rdr.Item("nLevel10") .Value(0, 5) = rdr.Item("nLevel11") .Value(1, 5) = rdr.Item("nLevel12") .CloseData(COD.Values) .RecalcScale() End With Link to comment Share on other sites More sharing options...
Software FX Posted October 18, 2004 Report Share Posted October 18, 2004 Note that this happens as RecalcScale does not know how to handle all 0 values, I think this has been fixed in a more recent build but because you seem to know the Min/Max you may want to move those lines after the CloseData, e.g. .OpenData(..) .Value(..) ... .CloseData(...) .AxisY.Max = 2 .AxisY.Min = 0 -- Regards, JC Software FX Support "Dennis Strickland" <dstrickland@satisfacts.net> wrote in message news:1ALZZwWtEHA.1332@webserver3.softwarefx.com... >I am having a problem with Chartfx Lite. I am using Chartfx Lite to >display monthly usage of one of our products. But if the recordset return >from my stored proc shows a client has never used our product and I set all >.values to 0 my application hangs I'll have to restart. As long as I set >one of the .values to a positive value everything fine. This only happens >if I have to set all .values to 0. Does anyone know how to overcome this >problem? I have included my code. Many thanks in advanced. > > With Chart1 > .ToolBar = False > .Gallery = Gallery.Bar > .Border = True > .AxisY.Max = 2 > .AxisY.Min = 0 > .Chart3D = True > .Grid = ChartGrid.Horz Or ChartGrid.Vert > .OpenData(COD.Values, 2, 6) > .Value(0, 0) = rdr.Item("nLevel1") > .Value(1, 0) = rdr.Item("nLevel2") > .Value(0, 1) = rdr.Item("nLevel3") > .Value(1, 1) = rdr.Item("nLevel4") > .Value(0, 2) = rdr.Item("nLevel5") > .Value(1, 2) = rdr.Item("nLevel6") > .Value(0, 3) = rdr.Item("nLevel7") > .Value(1, 3) = rdr.Item("nLevel8") > .Value(0, 4) = rdr.Item("nLevel9") > .Value(1, 4) = rdr.Item("nLevel10") > .Value(0, 5) = rdr.Item("nLevel11") > .Value(1, 5) = rdr.Item("nLevel12") > .CloseData(COD.Values) > .RecalcScale() > End With > > Link to comment Share on other sites More sharing options...
Software FX Posted October 18, 2004 Report Share Posted October 18, 2004 Note that this happens as RecalcScale does not know how to handle all 0 values, I think this has been fixed in a more recent build but because you seem to know the Min/Max you may want to move those lines after the CloseData, e.g. .OpenData(..) .Value(..) ... .CloseData(...) .AxisY.Max = 2 .AxisY.Min = 0 -- Regards, JC Software FX Support "Dennis Strickland" <dstrickland@satisfacts.net> wrote in message news:1ALZZwWtEHA.1332@webserver3.softwarefx.com... >I am having a problem with Chartfx Lite. I am using Chartfx Lite to >display monthly usage of one of our products. But if the recordset return >from my stored proc shows a client has never used our product and I set all >.values to 0 my application hangs I'll have to restart. As long as I set >one of the .values to a positive value everything fine. This only happens >if I have to set all .values to 0. Does anyone know how to overcome this >problem? I have included my code. Many thanks in advanced. > > With Chart1 > .ToolBar = False > .Gallery = Gallery.Bar > .Border = True > .AxisY.Max = 2 > .AxisY.Min = 0 > .Chart3D = True > .Grid = ChartGrid.Horz Or ChartGrid.Vert > .OpenData(COD.Values, 2, 6) > .Value(0, 0) = rdr.Item("nLevel1") > .Value(1, 0) = rdr.Item("nLevel2") > .Value(0, 1) = rdr.Item("nLevel3") > .Value(1, 1) = rdr.Item("nLevel4") > .Value(0, 2) = rdr.Item("nLevel5") > .Value(1, 2) = rdr.Item("nLevel6") > .Value(0, 3) = rdr.Item("nLevel7") > .Value(1, 3) = rdr.Item("nLevel8") > .Value(0, 4) = rdr.Item("nLevel9") > .Value(1, 4) = rdr.Item("nLevel10") > .Value(0, 5) = rdr.Item("nLevel11") > .Value(1, 5) = rdr.Item("nLevel12") > .CloseData(COD.Values) > .RecalcScale() > End With > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.