User (Legacy) Posted March 13, 2003 Report Share Posted March 13, 2003 Hi, Please see the attachment for an example chart. I'm using Chart FX 5.5 internet server on Windows XP/2000. I'm having 2 problems with stacked charts: 1. I have 4 series. I'm stacking serie 2 on serie 1 (oChart.Series(2).stacked = true). I want to show the sum of these series on top of the stacked bars. I'm using point labels (oChart.PointLabels = true) but the problem is that the point label only shows the value for serie 2, not the sum (see attachement). I know I can use mask settings like %T but this will sum all series for this point, I just want to sum serie 1 and serie 2. How can I achive this? 2. We are using drilldown functionality. When clicking a specific point and a specific serie, I want to send parameters in the URL telling which employee it is. How should my settings for the URLOptions and URL property look like? Example code when looping a recordset and setting chart values: '------------------------------------ with oChart .SerLeg(0) = "Capacity time" .SerLeg(1) = "Planned Project time" .SerLeg(2) = "Planned Activity time" .SerLeg(3) = "Reported time" .URLOptions = CHART_URL_JUMP' ??? how to combine the following settings? Or CHART_URL_BYMARKER or CHART_URL_PARAM or CHART_URL_BYVALUE or 'CHART_URL_BYSERIES ??? .DblClk CHART_URLCLK, 0 end with 'Iterate and display a graph for each week Do While Not oRs.EOF with oChart .ThisSerie = 0 .Value(iRecordCount) = iCapacity .URL(???) = "viewDetails.asp?iUserID=" & iUserID '??? .ThisSerie = 1 .Value(iRecordCount) = iProject .URL(???) = "viewDetails.asp?iUserID=" & iUserID '??? .ThisSerie = 2 .Value(iRecordCount) = iActivity .URL(???) = "viewDetails.asp?iUserID=" & iUserID '??? .ThisSerie = 3 .Value(iRecordCount) = iReported .URL(???) = "viewDetails.asp?iUserID=" & iUserID '??? end with iRecordCount = iRecordCount + 1 oRs.MoveNext Loop '------------------------------------ Hope I have explained my questions in a understandable way. Regards Gunnar Link to comment Share on other sites More sharing options...
Software FX Posted March 13, 2003 Report Share Posted March 13, 2003 1) I'm afraid we don't support this. We can not accumulate per "group". Are you generating Images ? If you are using the client component you can capture the GetPointLabel event to customize each point label in any way you want, however, this solution does not work if are producing images as in COM Events are not fired/captured in the server. This is something that you can now do with Chart FX for .NET but I can't think of any easy way of doing this with 5.5. Maybe you can use annotation objects in lieu of point labels, this will add considerable amounts of code but will get you exactly what you need. 2) The URLParamMask property allows you to pass parameters to the URL assigned, so even if you only assign ONE Url (CHART_URL_GLOBAL), you can send parameters to it by using URLParamMask. For example: chart.URL(0) = "DrillParam.asp" chart.URLOptions = CHART_URL_JUMP Or CHART_URL_GLOBAL Or CHART_URL_PARAM chart.URLParamMask = "Series=%s&Index=%S" This will pass the series legend as "Series" and the Series index as "Index" of the series that was clicked to DrillParam.asp. -- FP Software FX, Inc. Link to comment Share on other sites More sharing options...
User (Legacy) Posted March 14, 2003 Author Report Share Posted March 14, 2003 I'm generating images for viewing the charts. 1. I will look at the annotation object. 2. I don't think that passing the series legend and the series index will help me in this case since I want to pass an employee number (where does the %S mask come from? Can't find it in the documentation). How can I pass a customized value instead of %s or %S? It's of the highest importance that the value can be set per point and serie. Regards Gunnar "SoftwareFX Support" <support@softwarefx.com> wrote in message news:luaf76X6CHA.2116@webserver1.softwarefx.com... > 1) I'm afraid we don't support this. We can not accumulate per "group". Are > you generating Images ? If you are using the client component you can > capture the GetPointLabel event to customize each point label in any way you > want, however, this solution does not work if are producing images as in COM > Events are not fired/captured in the server. > > This is something that you can now do with Chart FX for .NET but I can't > think of any easy way of doing this with 5.5. Maybe you can use annotation > objects in lieu of point labels, this will add considerable amounts of code > but will get you exactly what you need. > > 2) The URLParamMask property allows you to pass parameters to the URL > assigned, so even if you only assign ONE Url (CHART_URL_GLOBAL), you can > send parameters to it by using URLParamMask. For example: > > chart.URL(0) = "DrillParam.asp" > chart.URLOptions = CHART_URL_JUMP Or CHART_URL_GLOBAL Or > CHART_URL_PARAM > chart.URLParamMask = "Series=%s&Index=%S" > > This will pass the series legend as "Series" and the Series index as "Index" > of the series that was clicked to DrillParam.asp. > > -- > FP > Software FX, Inc. > > Link to comment Share on other sites More sharing options...
Software FX Posted March 14, 2003 Report Share Posted March 14, 2003 > How can I pass a customized value instead of %s or %S? It's of the highest > importance that the value can be set per point and series. I think we missed %S from the docs, the rest of the macros are there (See TipMask property). A custom value ? where is this value ? the macros correspond to data that's already stored in the chart, so you can pass anything that's in the chart but if the data is in your own variables Chart FX doesn't see it. You need to put this data in either a legend, an X-Value or something so that it can be passed. -- FP Software FX, Inc. Link to comment Share on other sites More sharing options...
User (Legacy) Posted March 17, 2003 Author Report Share Posted March 17, 2003 When I create the URL I want it to be unique for each point and serie because I want to submit an employee ID (see chart image) from a database. This ID is not set as a some kind of chart value, I just want to pass it in the drill down URL. Does this make sense? /gunnar "SoftwareFX Support" <support@softwarefx.com> wrote in message news:5QCvi9j6CHA.2116@webserver1.softwarefx.com... > > How can I pass a customized value instead of %s or %S? It's of the highest > > importance that the value can be set per point and series. > > I think we missed %S from the docs, the rest of the macros are there (See > TipMask property). > > A custom value ? where is this value ? the macros correspond to data that's > already stored in the chart, so you can pass anything that's in the chart > but if the data is in your own variables Chart FX doesn't see it. > > You need to put this data in either a legend, an X-Value or something so > that it can be passed. > > -- > FP > Software FX, Inc. > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.