1. PBI
  2. Valentina Reports ADK
  3. Mittwoch, Januar 04 2017, 05:59 PM
  4.  Abonnieren via E-Mail
On the cell of a table I must have the following data:

Right(field_A, 2) + mid(field_A, 4,2) + left(field_A, 4).

How can I do ?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
0
Votes
Undo
Hello,

If you have RIGHT, LEFT and MID functions in the source database, you can use Expression control for it.

1) With SQL expression
=concat( right(field_A, 2), mid(field_A, 4,2), left(field_A, 4) )


This kind of expressions starts with '=' character and is passed to the source database as it is defined.

2) OR With pattern using macros
$E(right(field_A, 2))$E(mid(field_A, 4,2))$E(left(field_A, 4))


In this kind of expressions you write a pattern - how a string should look like.
With macros you can embed special values into resulting string:
$E - SQL expression
$F - value of field
$P - value of parameter
$( var ) - value of var report variable (date, pagetotal, page, etc)
Kommentar
There are no comments made yet.
  • Seite :
  • 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories