Re: SRB missing text FUNTIONS

Hi Fernand,

Fernand Vanrie wrote:
> Maybe a stupid  question or  i looked just over it
>
> : but why is a very usefull text Function  as CONCAT or CONCATENATE 
> not available in the Sun Report Builder ?
I don't remember exactly but shouldn't it be possible to just write
'column1' + ' '  + 'column2'

- oj
>
> I know, there are Queries to do things like that (supposes we build 
> for every Report a new Query...), but Concatenate a part of  field 
> with some 'text' or other parts  is more handy than some other 
> available text Functions.as URLENCODE etc...
>
> Joining  the field parts  as separate  controls  is al so a work 
> around  but  by making  URL's  for   pictures  we need to do something 
> like
>
> concat('///myserver/mydirectory ; LEFT(TEXT[urlFIELD]);10); 'etc...')
>
> Hope it helps to improve SRB and thanks for all the exellent work done 
> to make this tool available!
>
> Fernand
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>


-- 
Ocke Janssen                      Tel: +49 40 23646 661, x66661
Dipl. Inf(FH)                     Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55                      mailto:[email protected]
D-20097 Hamburg                   http://www.sun.com/staroffice

Sitz der Gesellschaft:
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Juergen Kunz