Expression nesting
How to achive, that expressions inside fields in dataset are translated.
example:
1) we create and fill table
create table Table1(Field1 varchar(255))
insert into Table1(Field1) values('text, text, [DATE], text...')
2) On Report we add Dataset (select * from Table1) and memo1 field (on masterData band) and write inside
[Dataset."Feld1"]
The result is
'text, text, [DATE], text...'
but I would like it to be
'text, text, 2008.11.11, text...'
Is that possible
example:
1) we create and fill table
create table Table1(Field1 varchar(255))
insert into Table1(Field1) values('text, text, [DATE], text...')
2) On Report we add Dataset (select * from Table1) and memo1 field (on masterData band) and write inside
[Dataset."Feld1"]
The result is
'text, text, [DATE], text...'
but I would like it to be
'text, text, 2008.11.11, text...'
Is that possible
Comments
a text object can contain text, expressions, variables or a combination but you are only allowed one set of [ ] around each expression so you must go back and enter the data correctly in the table field.
since you are not receiving an error i expect you may have included string ' delimiters in the var char field and therefore the expression [Dataset."Field1"] is returning the actual string characters that Field1 contains.
instead of [Date] you probably need (<Date>)