I cant get a field on report from a view
Posted
by
felipedz
on Stack Overflow
See other posts from Stack Overflow
or by felipedz
Published on 2013-06-10T23:53:15Z
Indexed on
2013/06/27
22:21 UTC
Read the original article
Hit count: 173
mysql
|jasper-reports
When I get a field, this work good.
But, when get a field from a 'VIEW', is a problem because the code of a VIEW is:
CREATE OR REPLACE VIEW tabla_clientes AS
SELECT id_cliente,nombre, CONCAT('$ ',FORMAT(monto_a_favor,0), '???'), CONCAT('$ ',FORMAT(calcular_monto_por_cobrar_cliente(id_cliente),0))
FROM cliente;
When I compile this. Appears errors from the name of fields.
Description | Object
----------------------------------------------------------------------------
Syntax error, insert ";" to complete BlockStatements | ${CONCAT('$ ',FORMAT(monto_a_favor,0)}
Syntax error on tokens, delete these tokens | ${CONCAT('$ ',FORMAT(monto_a_favor,0)}
Syntax error on token ",", delete this token | ${CONCAT('$ ',FORMAT(monto_a_favor,0)}
If I change the name at this field appears other error.
© Stack Overflow or respective owner