I am trying to create a chart and running into a problem. when I edit my SQL code to show
create procedure sp_DBR_FilmByCategoryChart()
select 'dbr.chart', 'Pie', 'Sample Pie chart';
select category, total_sales from mydb.sales_by_film_category;
I can hit execute and the lines
select category, total_sales
Do not save.
If I exit and go back to edit the report they are gone. Everything before the first ';' stays.