after installing Sun Report Builder 1.1.0 "nur für mich" I got the extra "Bericht in Entwurfsansicht erstellen" but only a small window appear and disappear verry quickly.

Even worse clicking on "Bericht unter Verwendung des Assistenten erstellen" results in "Feld hinzufügen: Erste_Tabelle_meiner_Datenbank" without the chance to select any other table then the (alphabetic) first of my database. Regardless what I then tried to do, I didn't get any further, no writer document opens, nothing. Only closing the "Feld hinzufügen: Erste_Tabelle_meiner_Datenbank" window is possible.

Exit Base and restart didn't help but after closing the oOo quick launcher too, it looks quite hopeful for me.

Hi,
RB 1.1.0 + OO 3.1.1
Creating a new report with group and sort, I get
com.sun.star.lang.WrappedTargetException.

Cannot be in ORDER BY clause in statement [SELECT * FROM (SELECT

"T_ecritureCompta"."date",
"T_ecritureCompta"."anneeAffectation" AS "AnneeScol",
"T_ecritureCompta"."anneeFiscale" AS "AnneeFiscale",
"T_ecritureCompta"."entree",
"T_ecritureCompta"."sortie",
"Tp_modeReglement"."libelle" AS "type",
"T_adherent"."prenom" AS "prenomAdherent",
"T_adherent"."nom" AS "nomAdherent",
"T_eleve"."prenom" AS "prenomEleve",
"T_eleve"."nom" AS "nomEleve",
"T_ecritureCompta"."commentaire",
"T_ecritureCompta"."banque",

"T_ecritureCompta"."guichet",
"T_ecritureCompta"."numCheque",

"T_ecritureCompta"."compteImane",
"T_ecritureCompta"."numChequeImane",

"T_ecritureCompta"."numPiece"

FROM "T_ecritureCompta"

LEFT OUTER JOIN "Tp_modeReglement" ON "T_ecritureCompta"."mode" = "Tp_modeReglement"."code"
LEFT OUTER JOIN "T_adherent"
ON "T_ecritureCompta"."adherent" = "T_adherent"."ID"
LEFT OUTER JOIN "T_parrainage"
ON "T_ecritureCompta"."parrainage" ="T_parrainage"."ID"
LEFT OUTER JOIN "T_eleve"
ON "T_parrainage"."filleul" = "T_eleve"."ID"
WHERE ("T_ecritureCompta"."mode" != 10 and "AnneeFiscale" < 2099 and "AnneeFiscale" > 2000 )
ORDER BY "nomAdherent", "prenomAdherent", "T_adherent"."ID", "date"
)]

Request can be executed without the report builder
Any Idea?
Thanks

Installed OOo 3.1 and Sun Report Report Builder 1.1 and a problem still exists in displaying phone number format in reports. Phone number field is formatted (000) 000-0000 but is displayed as (0000000000 in reports.

When I go into Reports I cannot launch the Wizard or the creator at all untill I disable the Sun Report Builder and restart the app.

EDIT: launched open office from the command line and enabled sun report builder and got this when I clicked on the wizard:
com.sun.star.uno.RuntimeException:
at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:178)
at $Proxy4.createInstanceWithArguments(Unknown Source)
at com.sun.star.wizards.reportbuilder.ReportBuilderImplementation.initialize(ReportBuilderImplementation.java:195)
at com.sun.star.wizards.reportbuilder.ReportBuilderImplementation.getFrame(ReportBuilderImplementation.java:308)
at com.sun.star.wizards.reportbuilder.ReportBuilderImplementation.getWizardParent(ReportBuilderImplementation.java:139)
at com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:654)
at com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:570)
at com.sun.star.wizards.report.CallReportWizard$ReportWizardImplementation.trigger(CallReportWizard.java:128)

Got nothing when I clicked on the design view.

Hello,

I have installed the report builder and am somewhat satisfied with it. The main irritant is the placement of the Report Header/Footer. When you ask to insert them they are placed above and below the Detail section and there is no way to move them. This structures the report from top to bottom as: Page Header, Report Header, Detail, Report Footer, Page Footer. The Report Header/Footer and Page Header/Footer function as labeled; they are just in the wrong place on the page. The developers at Sun are aware of this issue and have chosen to not fix it. Even though the report builder functions reasonably well I am somewhat put off by the fact that Sun refuses to address a functionality issue that has been presented by more than one user.

Thanks for allowing me to vent.

coffeeroaster

Hi,

In OpenOffice 2.4 I have created a report using Sun Report Builder version 1.0.2. This report uses parameters. When I run this report in 3.0 using extension version 1.0.5, the report produces no output and the parameters are not asked for. Is this a bug?

Regards,
Jeroen van Veldhuizen

I've been trying to download and install Sun Report Builder 1.0.4. I get the following error message:

(com.sun.star.registry.CannotRegisterImplementationException) {{Message="",Context=com.sun.star.uno.XInterface) @0}}

I can successfully install versions 1.0.2 and 1.0.3. I've downloaded the extension afresh, closed the program and reopened it, and rebooted the computer, all to no avail.

I'm running Ooo 2.4.1 on Windows XP SP3.

Help would be appreciated.

Vic

Is there a link to documentation available?

Thanks