Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by namitrs

  1. namitrs

    Calling mysql Stored proc throws error

    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.
  2. namitrs

    Calling mysql Stored proc throws error

    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...
  3. namitrs

    Calculation within groups

    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...
  4. namitrs

    Calculation within groups

    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...
  5. namitrs

    Calculation within groups

    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...
See more

Part and Inventory Search

Back
Top