Search results for query: *

I am not sure what do you mean by 'new version of SQL'. I am using Mysql 5.17 and CR 11.5 and the command I give to run the SP is the following - call spname (input param, @output param); the same cmd works perfectly fine when i run the sql browser but throws error when being run in CR.

Hello I am trying to call a mySql Stored Proc from CR10. But I get the attached error msg. I tried testing and SP runs fine when it doesnt output any value to a variable. The SP runs perfectly fine in the query browser. But when I try to call a Stored Proc which outputs value to output...

I think that is the issues I am facing. Both the cols and rows are part of any table. Like sales range is something I would be putting manually , say 1-20, 21-40 and so on. And in the cols I would be manually putting Median, Avg etc. And for the values I would be putting individual variables...

Thanks, that helped. Can you please tell me how could I add a table in a CR. Or how can i add new rows/ cols to a crosstab. Basically I am trying to have like a crosstab, with the columns being median, avg , stddev etc and rows being Sales Range1, Sales Range2 etc.. I am kinda new to CR, worked...

Hello All I have a problem with calculation within groups. Here is the sample data - I have 5 groups (5 days) showing the top 20 sales prices of items for that day. I would like to get the median and average by each group and show it within the group. When I do avg(price) or median(price) it...