conditional print
|
View:
New views
13 Messages
—
Rating Filter:
Alert me
|
 |
conditional print
by Franco Fornari
::
Rate this Message:
Hello,
I'm trying to use conditional print expressions in reports, with no success. Probably it's a matter of sintax, but I didn't find any example to understand why it didn't work for me. I attached a sample db, containing a little table and a very simple report linked to it. I'd like to make invisible each field when it contain 0 and visible with any other value. As far as I know, it should be easy to get such a result, but ..., it's not easy for me. Any help, please? Thanks in advance, Franco --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: conditional print
by Frank Schoenheit, Sun Microsystems Germany
::
Rate this Message:
Hi Franco,
> I'm trying to use conditional print expressions in reports, with no > success. Probably it's a matter of sintax Well, "[Imponibile]<>0", in your example database, should do - it does very well in the conditional formatting dialog, so it can't be too wrong ... So, this indeed sounds like a problem with the conditional print expression. I took the liberty to attach a slightly modified version of your database to the newly submitted issue: http://www.openoffice.org/issues/show_bug.cgi?id=105724 Thanks & Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenheit@... - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: conditional print
by Franco Fornari
::
Rate this Message:
Hi Frank,
I just tried to open your attachment to the new issue, but the database includes one report, only. No tables, no queries at all. Perhaps did you use an external source? Thanks, Franco Frank Schoenheit, Sun Microsystems Germany ha scritto: > Hi Franco, > > >> I'm trying to use conditional print expressions in reports, with no >> success. Probably it's a matter of sintax >> > > Well, "[Imponibile]<>0", in your example database, should do - it does > very well in the conditional formatting dialog, so it can't be too wrong > ... So, this indeed sounds like a problem with the conditional print > expression. > > I took the liberty to attach a slightly modified version of your > database to the newly submitted issue: > http://www.openoffice.org/issues/show_bug.cgi?id=105724 > > Thanks & Ciao > Frank > > > ------------------------------------------------------------------------ > > > Nessun virus nel messaggio in arrivo. > Controllato da AVG - www.avg.com > Versione: 8.5.421 / Database dei virus: 270.14.7/2421 - Data di rilascio: 10/07/09 20:49:00 > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: conditional print
by Frank Schoenheit, Sun Microsystems Germany
::
Rate this Message:
Hi Franco,
> I just tried to open your attachment to the new issue, but the database > includes one report, only. No tables, no queries at all. Perhaps did you > use an external source? freshly downloaded it, opened in a Windows-OOo-3.1.0 (well, StarOffice 9.1, honestly) -> works like a charm. Which version did you use to open the file, on which platform? Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenheit@... - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: conditional print
by Franco Fornari
::
Rate this Message:
Hi Frank,
still the same, that is official 3.1.0 , on WinXp Franco Frank Schoenheit, Sun Microsystems Germany ha scritto: > Hi Franco, > > >> I just tried to open your attachment to the new issue, but the database >> includes one report, only. No tables, no queries at all. Perhaps did you >> use an external source? >> > > freshly downloaded it, opened in a Windows-OOo-3.1.0 (well, StarOffice > 9.1, honestly) -> works like a charm. > > Which version did you use to open the file, on which platform? > > Ciao > Frank > > > ------------------------------------------------------------------------ > > > Nessun virus nel messaggio in arrivo. > Controllato da AVG - www.avg.com > Versione: 8.5.421 / Database dei virus: 270.14.7/2421 - Data di rilascio: 10/07/09 20:49:00 > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: conditional print
by Frank Schoenheit, Sun Microsystems Germany
::
Rate this Message:
Hi Franco,
> still the same, that is official 3.1.0 , on WinXp Phh. Okay, let's get more concrete. You said "no tables, no queries" - actually, there should be exactly one table "Table1" (it's really the doc you sent in your original mail), and no queries. Can you connect, i.e. successfully select the "Tables" icon on the left hand side? What does the status bar say? Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenheit@... - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: conditional print
by Reizinger Zoltán
::
Rate this Message:
Hi Franco,
Franco Fornari írta: > Hi Frank, > > I just tried to open your attachment to the new issue, but the > database includes one report, only. No tables, no queries at all. > Perhaps did you use an external source? I downloaded database and it contain Table1 table, I opened it in OOo 3.1.1. Zoltan > > Thanks, > Franco > > Frank Schoenheit, Sun Microsystems Germany ha scritto: >> Hi Franco, >> >> >>> I'm trying to use conditional print expressions in reports, with no >>> success. Probably it's a matter of sintax >>> >> >> Well, "[Imponibile]<>0", in your example database, should do - it does >> very well in the conditional formatting dialog, so it can't be too wrong >> ... So, this indeed sounds like a problem with the conditional print >> expression. >> >> I took the liberty to attach a slightly modified version of your >> database to the newly submitted issue: >> http://www.openoffice.org/issues/show_bug.cgi?id=105724 >> >> Thanks & Ciao >> Frank >> >> >> ------------------------------------------------------------------------ >> >> >> Nessun virus nel messaggio in arrivo. >> Controllato da AVG - www.avg.com Versione: 8.5.421 / Database dei >> virus: 270.14.7/2421 - Data di rilascio: 10/07/09 20:49:00 >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: conditional print
by Franco Fornari
::
Rate this Message:
Hi Frank,
no, when I try to select the "Tables" icon I receive an error message like this: Cannot connect to data source "i105724" General Error: org.hsqldb.lib.FileSystemRunTimeException:java.IOException: Ciao, Franco Frank Schoenheit, Sun Microsystems Germany ha scritto: > Hi Franco, > > >> still the same, that is official 3.1.0 , on WinXp >> > > Phh. Okay, let's get more concrete. You said "no tables, no queries" - > actually, there should be exactly one table "Table1" (it's really the > doc you sent in your original mail), and no queries. > Can you connect, i.e. successfully select the "Tables" icon on the left > hand side? What does the status bar say? > > Ciao > Frank > > > ------------------------------------------------------------------------ > > > Nessun virus nel messaggio in arrivo. > Controllato da AVG - www.avg.com > Versione: 8.5.421 / Database dei virus: 270.14.7/2421 - Data di rilascio: 10/07/09 20:49:00 > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: conditional print
by Frank Schoenheit, Sun Microsystems Germany
::
Rate this Message:
Hi Franco,
> no, when I try to select the "Tables" icon I receive an error message > like this: > > Cannot connect to data source "i105724" > General Error: org.hsqldb.lib.FileSystemRunTimeException:java.IOException: Ouch. Is the location where the file is located write-protected? Has this ugly bug crept back in? Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenheit@... - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: conditional print
by Franco Fornari
::
Rate this Message:
Hi Zoltan,
what can I say? I dowloaded it again, but the error remains the same. Franco Reizinger Zoltán ha scritto: > Hi Franco, > Franco Fornari írta: >> Hi Frank, >> >> I just tried to open your attachment to the new issue, but the >> database includes one report, only. No tables, no queries at all. >> Perhaps did you use an external source? > I downloaded database and it contain Table1 table, I opened it in OOo > 3.1.1. > Zoltan >> >> Thanks, >> Franco >> >> Frank Schoenheit, Sun Microsystems Germany ha scritto: >>> Hi Franco, >>> >>> >>>> I'm trying to use conditional print expressions in reports, with no >>>> success. Probably it's a matter of sintax >>>> >>> >>> Well, "[Imponibile]<>0", in your example database, should do - it does >>> very well in the conditional formatting dialog, so it can't be too >>> wrong >>> ... So, this indeed sounds like a problem with the conditional print >>> expression. >>> >>> I took the liberty to attach a slightly modified version of your >>> database to the newly submitted issue: >>> http://www.openoffice.org/issues/show_bug.cgi?id=105724 >>> >>> Thanks & Ciao >>> Frank >>> >>> >>> ------------------------------------------------------------------------ >>> >>> >>> >>> Nessun virus nel messaggio in arrivo. >>> Controllato da AVG - www.avg.com Versione: 8.5.421 / Database dei >>> virus: 270.14.7/2421 - Data di rilascio: 10/07/09 20:49:00 >>> >>> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscribe@... >> For additional commands, e-mail: users-help@... >> >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > ------------------------------------------------------------------------ > > > Nessun virus nel messaggio in arrivo. > Controllato da AVG - www.avg.com > Versione: 8.5.421 / Database dei virus: 270.14.7/2421 - Data di rilascio: 10/07/09 20:49:00 > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: conditional print
by Reizinger Zoltán
::
Rate this Message:
Franco Fornari írta:
> Hi Zoltan, > > what can I say? I dowloaded it again, but the error remains the same. May be it is caused by differences between OOo 3.1.0 and 3.1.1, try it in OOo 3.1.1. Zoltan > > Franco > > Reizinger Zoltán ha scritto: >> Hi Franco, >> Franco Fornari írta: >>> Hi Frank, >>> >>> I just tried to open your attachment to the new issue, but the >>> database includes one report, only. No tables, no queries at all. >>> Perhaps did you use an external source? >> I downloaded database and it contain Table1 table, I opened it in OOo >> 3.1.1. >> Zoltan >>> >>> Thanks, >>> Franco >>> >>> Frank Schoenheit, Sun Microsystems Germany ha scritto: >>>> Hi Franco, >>>> >>>> >>>>> I'm trying to use conditional print expressions in reports, with >>>>> no success. Probably it's a matter of sintax >>>>> >>>> >>>> Well, "[Imponibile]<>0", in your example database, should do - it does >>>> very well in the conditional formatting dialog, so it can't be too >>>> wrong >>>> ... So, this indeed sounds like a problem with the conditional print >>>> expression. >>>> >>>> I took the liberty to attach a slightly modified version of your >>>> database to the newly submitted issue: >>>> http://www.openoffice.org/issues/show_bug.cgi?id=105724 >>>> >>>> Thanks & Ciao >>>> Frank >>>> >>>> >>>> ------------------------------------------------------------------------ >>>> >>>> >>>> >>>> Nessun virus nel messaggio in arrivo. >>>> Controllato da AVG - www.avg.com Versione: 8.5.421 / Database dei >>>> virus: 270.14.7/2421 - Data di rilascio: 10/07/09 20:49:00 >>>> >>>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: users-unsubscribe@... >>> For additional commands, e-mail: users-help@... >>> >>> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscribe@... >> For additional commands, e-mail: users-help@... >> ------------------------------------------------------------------------ >> >> >> Nessun virus nel messaggio in arrivo. >> Controllato da AVG - www.avg.com Versione: 8.5.421 / Database dei >> virus: 270.14.7/2421 - Data di rilascio: 10/07/09 20:49:00 >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: conditional print
by Ocke Janssen
::
Rate this Message:
Hi Franco,
On 09/05/09 18:40, Franco Fornari wrote: > Hello, > > I'm trying to use conditional print expressions in reports, with no > success. Probably it's a matter of sintax, but I didn't find any > example to understand why it didn't work for me. I attached a sample > db, containing a little table and a very simple report linked to it. > I'd like to make invisible each field when it contain 0 and visible > with any other value. As far as I know, it should be easy to get such > a result, but ..., it's not easy for me. Any help, please? The problem is the number format. As a workaround you format your field as string. - oj > > Thanks in advance, > Franco > ------------------------------------------------------------------------ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... -- Ocke Janssen Tel: +49 40 23646 661, x66661 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:Ocke.Janssen@... 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: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering |
|
|
Re: conditional print
by Franco Fornari
::
Rate this Message:
Hi Ocke,
sorry, but for me it's not a good workaround; it can be acceptable for integers, but in case of formatting calculated fields as strings, you can easily get too many decimals displayed. I prefer to wait that it will be fixed. Thanks, Franco Ocke Janssen ha scritto: > Hi Franco, > On 09/05/09 18:40, Franco Fornari wrote: >> Hello, >> >> I'm trying to use conditional print expressions in reports, with no >> success. Probably it's a matter of sintax, but I didn't find any >> example to understand why it didn't work for me. I attached a sample >> db, containing a little table and a very simple report linked to it. >> I'd like to make invisible each field when it contain 0 and visible >> with any other value. As far as I know, it should be easy to get such >> a result, but ..., it's not easy for me. Any help, please? > The problem is the number format. As a workaround you format your > field as string. > > - oj >> >> Thanks in advance, >> Franco >> ------------------------------------------------------------------------ >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscribe@... >> For additional commands, e-mail: users-help@... > > > ------------------------------------------------------------------------ > > > Nessun virus nel messaggio in arrivo. > Controllato da AVG - www.avg.com > Versione: 8.5.421 / Database dei virus: 270.14.9/2427 - Data di rilascio: 10/10/09 06:39:00 > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
db_ sample_2_Franco.odb (25K) | Free embeddable forum powered by Nabble | Forum Help |
