User (Legacy) Posted February 1, 2005 Report Share Posted February 1, 2005 I have a data set from a SQL Database (shown below) that I am trying to display in strips from Start Date to End Date on a stacked chart Transaction StartDate EndDate Percentage 100000063 2004-11-30 2014-12-02 6.250000 100000064 2004-11-30 2014-11-30 6.000000 100000065 2004-11-30 2014-11-30 12.000000 100000066 2004-11-30 2014-11-30 18.700000 100000067 2004-11-30 2014-11-30 14.000000 Using the CrossTab provider with DataType[0] = ColumnHeading DataType[1] = RowHeading DataType[2] = RowHeading DataType[3] = Value doesn't achieve the desired results... I have tried seperating the data above to get something like Transaction Date Percentage 100000063 2004-11-30 6.250000 100000063 2014-12-02 6.250000 100000064 2004-11-30 6.000000 100000064 2014-11-30 6.000000 100000065 2004-11-30 12.000000 100000065 2014-11-30 12.000000 100000066 2004-11-30 18.700000 100000066 2014-11-30 18.700000 100000067 2004-11-30 14.000000 100000067 2014-11-30 14.000000 Using the CrossTab provider with DataType[0] = ColumnHeading DataType[1] = RowHeading DataType[2] = Value doesn't achieve the desired results... I have tried ordering by column 1, 2 or 3 with mixed (incorrect) results Any help appreciated Thanks John Link to comment Share on other sites More sharing options...
Software FX Posted February 10, 2005 Report Share Posted February 10, 2005 The Crosstab Provider in Chart FX Client Server 5.1 doesn't support IniValues, so you will not be able to use it to plot data between two points (this functionality is available in the 6.2 version, though). In any case, it's important to mention the way the columns are handled in the Crosstab provider: The values in the column identified as Column Heading will be translated into Series of the chart. The values in the column(s) identified as Row Heading will be translated into Points of the chart. The values in the column identified as Value will be plotted in the Y axis. On the other hand, the Crosstab provider requires the dataset to be sorted by the column identified as Row Heading. With that said, if you pass the data in your second data sample, correctly sorted, you will get a chart with three points (2004-11-30, 2014-11-30 and 2014-12-02) and 5 series (100000063, 100000064, 100000065, 100000066 and 100000067). --- IG Software FX "John Parker" <john.parker@granvilleassociates.co.uk> wrote in message news:FIN3qlFCFHA.388@webserver3.softwarefx.com... >I have a data set from a SQL Database (shown below) that I am trying to >display in strips from Start Date to End Date on a stacked chart > > Transaction StartDate EndDate Percentage > 100000063 2004-11-30 2014-12-02 6.250000 > 100000064 2004-11-30 2014-11-30 6.000000 > 100000065 2004-11-30 2014-11-30 12.000000 > 100000066 2004-11-30 2014-11-30 18.700000 > 100000067 2004-11-30 2014-11-30 14.000000 > > > Using the CrossTab provider with > DataType[0] = ColumnHeading > DataType[1] = RowHeading > DataType[2] = RowHeading > DataType[3] = Value > > doesn't achieve the desired results... > > I have tried seperating the data above to get something like > > Transaction Date Percentage > 100000063 2004-11-30 6.250000 > 100000063 2014-12-02 6.250000 > 100000064 2004-11-30 6.000000 > 100000064 2014-11-30 6.000000 > 100000065 2004-11-30 12.000000 > 100000065 2014-11-30 12.000000 > 100000066 2004-11-30 18.700000 > 100000066 2014-11-30 18.700000 > 100000067 2004-11-30 14.000000 > 100000067 2014-11-30 14.000000 > > Using the CrossTab provider with > DataType[0] = ColumnHeading > DataType[1] = RowHeading > DataType[2] = Value > > doesn't achieve the desired results... I have tried ordering by column 1, > 2 or 3 with mixed (incorrect) results > > Any help appreciated > > > Thanks > John > > > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.