1. Jochen Peters
  2. Report Editor
  3. Воскресенье, Июль 02 2017, 07:33 PM
  4.  Подписаться через email
How do this on Expression Filed1 + " " + Field2 to show like one field only
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
sorry i found how it works
thanks
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
But no Works
How do this on Expression Filed1 + " " + Field2 to show like one field only

it show like Name + " " + Last on the reports
Комментарий
There are no comments made yet.
François Van Lerberghe Ответ принят
CONCAT(Field1, ' ', Field2)

Cheers
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
thanks
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
i test but same no works
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
CONCAT(Apellidos,' ',Dueno)
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
There are two ways to do it in the expression:

1) Using macro $F:
$F(Field1) $F(Field2)

2) Using SQL command CONCAT (if you use Postgres and field names have upper case symbols, make sure to quote their names):
=CONCAT(Field1,' ',Field2)
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
it works but in the query in Report expression
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
how i do this on the expression in the VS
If $F(StatusSocio)=0 then
='Activo'
else
='InActivo'
End if
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
For MySQL, expression can be:

=IF( StatusSocio=0, 'Activo', 'InActivo' )

'=' at the beginning tells that it is the SQL expression.
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
if i use sum() or expression report no show data
Комментарий
There are no comments made yet.
Jochen Peters Ответ принят
ms sql 2012
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories