User (Legacy) Posted August 7, 2006 Report Share Posted August 7, 2006 Is it possible to plot multiple database queries in the same chart? For example, one might have a single query that returns historical stock prices (by weekly closing price), and another query that returns revenue per quarter. Query 1 returns: Day Stock Price 1/1 10 3/2 9 5/5 5 8/10 30 ... Query 2 returns: Quarter Revenue 1/1/2006 10,000 4/1/2006 20,000 7/1/2006 30,000 It appears that a chart can only contain a single data provider, and the JDBCDataProvider can only contain a single resultset. Link to comment Share on other sites More sharing options...
User (Legacy) Posted August 7, 2006 Author Report Share Posted August 7, 2006 Is it possible to plot multiple database queries in the same chart? For example, one might have a single query that returns historical stock prices (by weekly closing price), and another query that returns revenue per quarter. Query 1 returns: Day Stock Price 1/1 10 3/2 9 5/5 5 8/10 30 ... Query 2 returns: Quarter Revenue 1/1/2006 10,000 4/1/2006 20,000 7/1/2006 30,000 It appears that a chart can only contain a single data provider, and the JDBCDataProvider can only contain a single resultset. Link to comment Share on other sites More sharing options...
Software FX Posted August 7, 2006 Report Share Posted August 7, 2006 Hi, No, it's not possible to load data from more than one query using athe JDBCProvider. If you need to load data for more than one source, you have to use the API. GA Software FX "Michael Choundary" <none@none.com> wrote in message news:bLEgydkuGHA.2136@webserver3.softwarefx.com... > Is it possible to plot multiple database queries in the same chart? > > For example, one might have a single query that returns historical stock > prices (by weekly closing price), and another query that returns revenue > per quarter. > > Query 1 returns: > > Day Stock Price > 1/1 10 > 3/2 9 > 5/5 5 > 8/10 30 > ... > > Query 2 returns: > Quarter Revenue > 1/1/2006 10,000 > 4/1/2006 20,000 > 7/1/2006 30,000 > > It appears that a chart can only contain a single data provider, and the > JDBCDataProvider can only contain a single resultset. > > > Link to comment Share on other sites More sharing options...
Software FX Posted August 7, 2006 Report Share Posted August 7, 2006 Hi, No, it's not possible to load data from more than one query using athe JDBCProvider. If you need to load data for more than one source, you have to use the API. GA Software FX "Michael Choundary" <none@none.com> wrote in message news:bLEgydkuGHA.2136@webserver3.softwarefx.com... > Is it possible to plot multiple database queries in the same chart? > > For example, one might have a single query that returns historical stock > prices (by weekly closing price), and another query that returns revenue > per quarter. > > Query 1 returns: > > Day Stock Price > 1/1 10 > 3/2 9 > 5/5 5 > 8/10 30 > ... > > Query 2 returns: > Quarter Revenue > 1/1/2006 10,000 > 4/1/2006 20,000 > 7/1/2006 30,000 > > It appears that a chart can only contain a single data provider, and the > JDBCDataProvider can only contain a single resultset. > > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.