MySQL Forums
Forum List  »  Analytics, Reporting, BI

Query Report Builder Error
Posted by: Silas Augusto V C Junior
Date: August 04, 2016 09:07AM

Ir MySQl WorkBench this Query is OK

select Nome_Produto, sum(Quantidade), cast( replace(preco_venda,',','.') as from SiBar.pedidosdetalhados where Cod_Evento = 11 group by Nome_Produto

But in Report Builder do not

I need convert string for decimal

Options: ReplyQuote

Written By
Query Report Builder Error
August 04, 2016 09:07AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.