(1)Does EspressChart support stored procedures?
Yes, you can specify a stored procedure in the query. For the multiple result sets/response reply, EspressChart will use the first non-empty result set to plot the chart. The mechanism is same for the code bridgeTest/TestDB.java in your EspressChart installation directory.
(2)Does EspressReport support stored procedures?;
You may specify a stored procedure in the query such as “EXEC store” or “EXEC store ‘P1’, ‘P2” where P1, P2 are parameters into store for MSSQL and setup store on the database server. Similar stored procedure works for Oracle database where the query becomes “call store (P1, P2)”.