Re: [dba-dev] SRB missing text FUNTIONS
Zoltán , Thanks, I over looked the double quotes is my testing because wrong field format also produce "blanks" For others: when get "blank_output" then there is a error in the formula or wrong field format when get "0_output" then formula is OK but certenly wrong field format. Thanks for the solution and all the work you spended on this usefull Tool Fernand Hi Fernand, The [Textfieldname]&" "&[Textfieldname] working for me on windows with OOo 3.2 and SRB 1.2. Zoltan 2010.05.11. 9:58 keltezéssel, Fernand Vanrie írta: Ocke , Sorry but I tried this all before and again =-) : also & is not working: Windows - SRB 1.2 -OO 3.2.0 Sould i fill a issue ? Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB missing text FUNTIONS
Hi Fernand, The [Textfieldname]&" "&[Textfieldname] working for me on windows with OOo 3.2 and SRB 1.2. Zoltan 2010.05.11. 9:58 keltezéssel, Fernand Vanrie írta: Ocke , Sorry but I tried this all before and again =-) : also & is not working: Windows - SRB 1.2 -OO 3.2.0 Sould i fill a issue ? Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB missing text FUNTIONS
Fernand Vanrie wrote: Ocke , Sorry but I tried this all before and again =-) : also & is not working: Windows - SRB 1.2 -OO 3.2.0 Sould i fill a issue ? Yes, please. :-) - oj Fernand Hi Fernand, Fernand Vanrie wrote: Ocke Janssen wrote: Jocke, Thanks for the Reply, but no i Tried al this stuff before LEFT([textfieldname] ; 3 ) is working and returns the first 3 chararters of the field text must been included in double quotes "text" > works fields must been include in scuare brackets [Textfiledname] [Textfieldname] + " "+ [Textfiledname] not working results in a empty field.. I just had a look at the source code and you are right. The code must be with ampersand & [Textfieldname] & " "& [Textfieldname] Best regards, Ocke 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: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB missing text FUNTIONS
Ocke , Sorry but I tried this all before and again =-) : also & is not working: Windows - SRB 1.2 -OO 3.2.0 Sould i fill a issue ? Fernand Hi Fernand, Fernand Vanrie wrote: Ocke Janssen wrote: Jocke, Thanks for the Reply, but no i Tried al this stuff before LEFT([textfieldname] ; 3 ) is working and returns the first 3 chararters of the field text must been included in double quotes "text" > works fields must been include in scuare brackets [Textfiledname] [Textfieldname] + " "+ [Textfiledname] not working results in a empty field.. I just had a look at the source code and you are right. The code must be with ampersand & [Textfieldname] & " "& [Textfieldname] Best regards, Ocke 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: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB missing text FUNTIONS
Hi Fernand, Fernand Vanrie wrote: Ocke Janssen wrote: Jocke, Thanks for the Reply, but no i Tried al this stuff before LEFT([textfieldname] ; 3 ) is working and returns the first 3 chararters of the field text must been included in double quotes "text" > works fields must been include in scuare brackets [Textfiledname] [Textfieldname] + " "+ [Textfiledname] not working results in a empty field.. I just had a look at the source code and you are right. The code must be with ampersand & [Textfieldname] & " "& [Textfieldname] Best regards, Ocke 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: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB missing text FUNTIONS
Ocke Janssen wrote: Jocke, Thanks for the Reply, but no i Tried al this stuff before LEFT([textfieldname] ; 3 ) is working and returns the first 3 chararters of the field text must been included in double quotes "text" > works fields must been include in scuare brackets [Textfiledname] [Textfieldname] + " "+ [Textfiledname] not working results in a empty field.. 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: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] 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: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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 - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] SRB missing text FUNTIONS
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 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: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org