Re: [dba-dev] Reportbuilder: Configure Page Break
Drew Jensen wrote: However there is a work around - ugly - but works. Add an explicit Group to the report. (You know just type something like "1" in the Group Dialog) make this the first group, just below the page header, now turn off Page Headers and use this GoupHeader instead. Add your logo to the GroupHeader Add this conditional statement to the GroupHeader Conditional Print property IF(PageNumber()=1;TRUE;FALSE) Actually that works for the actual ImageControl also..if you want other thins in this 'quiasi' page header all the time. Now add your normal groupings, if you want your normal group header only on pages 2...n then reverse the logic of the conditional print statement. Simple.. Want an example file, have that also, will attach it to the not yet created entry in Issuzilla. ok - forget all that...it doesn't really work. - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Reportbuilder: Configure Page Break
Mechtilde wrote: On 20.02.09 20:18, Mechtilde wrote: Hello, There is a discussion at us...@de.openoffice.org. We have problems to create a report about more than one pages. We need a logo on the first page. and the group header on each page. Details are displayed as a table. In the properties of the headers I find a filed where I can input expressions, but I don't know how to define them It would be nice if all you needed was to enter this: PageNumber() = 1 in the Conditional Print property...but nope...that dog doesn't hunt. So then maybe you could create your own function MYCount as [MyCount] + 1 Then use in the conditional print property [MyCount] = 1 Well that works for items in the detail section, even in a group header BUT it does not work in a page header. Bottom line, as best as I can ascertain is that conditional printing does not work for Page Headers or items in page headers. However there is a work around - ugly - but works. Add an explicit Group to the report. (You know just type something like "1" in the Group Dialog) make this the first group, just below the page header, now turn off Page Headers and use this GoupHeader instead. Add your logo to the GroupHeader Add this conditional statement to the GroupHeader Conditional Print property IF(PageNumber()=1;TRUE;FALSE) Actually that works for the actual ImageControl also..if you want other thins in this 'quiasi' page header all the time. Now add your normal groupings, if you want your normal group header only on pages 2...n then reverse the logic of the conditional print statement. Simple.. Want an example file, have that also, will attach it to the not yet created entry in Issuzilla. Drew ps My example works with DEV310_m3 and SRB (LOL, hell if I know which release of the SRB this is...I tried 1.1.xxx, Fix04, and finally the build of the SRB from Pavel's server under the m3 directory, that's what I have at this minute, but the version number I don't trust...) pps. Can you really call the SRB an extension when it requires so many changes to the baseline code - so just merge it into the baseline or pull it all the way out [making fixes or workarounds in the SRB for defects in the baseline code], either way but PLEASE - PLEASE pick one of those two ways and just do it. - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Reportbuilder: Configure Page Break
Hello Ocke, *, Ocke Janssen schrieb: > Moin Mechtilde, sorry for the delay > > On 20.02.09 20:18, Mechtilde wrote: >> Hello, >> >> There is a discussion at us...@de.openoffice.org. >> We have problems to create a report about more than one pages. >> We need a logo on the first page. and the group header on each page. >> >> Details are displayed as a table. >> >> In the properties of the headers I find a filed where I can input >> expressions, but I don't know how to define them >> > They are defined in the same way you define Calc expressions. Column > names are enclosed with [column name]. I don't know how to define such things in Calc. :( > Please also have a look at the wiki. Search for Sun report Builder. I > can't copy a link here, server seems to be down. :-( I looked for it in the Wiki but I couldn't find any information about conditinal expressions Kind regards Mechtilde -- Dipl. Ing. Mechtilde Stehmann ## http://de.openoffice.org ## Ansprechpartnerin für die deutschsprachige QA ## Freie Office-Suite für Linux, Mac, Windows, Solaris ## Meine Seite http://www.mechtilde.de ## PGP encryption welcome! Key-ID: 0x53B3892B - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Reportbuilder: Configure Page Break
Moin Mechtilde, On 20.02.09 20:18, Mechtilde wrote: Hello, There is a discussion at us...@de.openoffice.org. We have problems to create a report about more than one pages. We need a logo on the first page. and the group header on each page. Details are displaed as a table. In the properties of the headers I find a filed where I can input expressions, but I don't know how to define them They are defined in the same way you define Calc expressions. Column names are enclosed with [column name] Please also have a look at the wiki. Search for Sun report Builder. I can't copy a link here, server seems to be down. :-( - oj Regards Mechtilde -- 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: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] Reportbuilder: Configure Page Break
Hello, There is a discussion at us...@de.openoffice.org. We have problems to create a report about more than one pages. We need a logo on the first page. and the group header on each page. Details are displaed as a table. In the properties of the headers I find a filed where I can input expressions, but I don't know how to define them Regards Mechtilde -- Dipl. Ing. Mechtilde Stehmann ## http://de.openoffice.org ## Ansprechpartnerin für die deutschsprachige QA ## Freie Office-Suite für Linux, Mac, Windows, Solaris ## Meine Seite http://www.mechtilde.de ## PGP encryption welcome! Key-ID: 0x53B3892B - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
