User (Legacy) Posted August 7, 2006 Report Share Posted August 7, 2006 I am trying to draw a line chart of multiple data series, from a JDBC resultset. The query returns the following data: Client Date Value A 7/1/2006 10 A 7/14/2006 15 A 7/22/2006 20 B 7/5/2006 50 B 7/17/2006 60 B 7/23/2006 70 What I want is two lines (one for Client A, the other for Client plotted against Date. I couldn't figure out how to do this... I tried transposing, and tried the crosstabdataprovider. Any suggestions? Link to comment Share on other sites More sharing options...
User (Legacy) Posted August 7, 2006 Author Report Share Posted August 7, 2006 I am trying to draw a line chart of multiple data series, from a JDBC resultset. The query returns the following data: Client Date Value A 7/1/2006 10 A 7/14/2006 15 A 7/22/2006 20 B 7/5/2006 50 B 7/17/2006 60 B 7/23/2006 70 What I want is two lines (one for Client A, the other for Client plotted against Date. I couldn't figure out how to do this... I tried transposing, and tried the crosstabdataprovider. Any suggestions? Link to comment Share on other sites More sharing options...
User (Legacy) Posted August 7, 2006 Author Report Share Posted August 7, 2006 Nevermind. Turns out the solution was to call CrosstabDataProvider.setXValue(true). "Michael Choundary" <none@none.com> wrote in message news:6ka2eVkuGHA.2276@webserver3.softwarefx.com... >I am trying to draw a line chart of multiple data series, from a JDBC >resultset. > > The query returns the following data: > > Client Date Value > A 7/1/2006 10 > A 7/14/2006 15 > A 7/22/2006 20 > B 7/5/2006 50 > B 7/17/2006 60 > B 7/23/2006 70 > > What I want is two lines (one for Client A, the other for Client > plotted against Date. > > I couldn't figure out how to do this... I tried transposing, and tried the > crosstabdataprovider. > > Any suggestions? > Link to comment Share on other sites More sharing options...
User (Legacy) Posted August 7, 2006 Author Report Share Posted August 7, 2006 Nevermind. Turns out the solution was to call CrosstabDataProvider.setXValue(true). "Michael Choundary" <none@none.com> wrote in message news:6ka2eVkuGHA.2276@webserver3.softwarefx.com... >I am trying to draw a line chart of multiple data series, from a JDBC >resultset. > > The query returns the following data: > > Client Date Value > A 7/1/2006 10 > A 7/14/2006 15 > A 7/22/2006 20 > B 7/5/2006 50 > B 7/17/2006 60 > B 7/23/2006 70 > > What I want is two lines (one for Client A, the other for Client > plotted against Date. > > I couldn't figure out how to do this... I tried transposing, and tried the > crosstabdataprovider. > > Any suggestions? > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.