No chart displays

(2 posts) (2 voices)


No tags yet.

  1. cfoinfo, Member

    create procedure sp_DBR_portfolio_balances_chart()

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

    select year, value
    from mydbname.mydbtablename;


    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


You must log in to post.