1. 

   cfoinfo, Member

   create procedure sp_DBR_portfolio_balances_chart()
   begin

   select 'dbr.chart', 'Line', 'Portfolio Trend Since Year 2000';

   select year, value
   from mydbname.mydbtablename;

   end

   1. When I create a report and link this SP to it, I get no results just an OK button.
   2. When I check Report Wizard and click the report it runs the report instead of displaying the report wizard screen
2. 

   myDBR Team, Key Master

   The syntax of the query is just fine.

   First thing to check is that the stored procedure executes without errors. Easiest way to check this is to simply execute the procedure from the mysql-command line tool (MySQL Query Browser does not support multiple result sets.

   mysql> call sp_DBR_portfolio_balances_chart();
   
   

   See if the call produces data you expect.

   --
   myDBR Team

Reply

You must log in to post.