[libreoffice-users] Basic Addon Builder

Has anyone recently used or edited the BasicAddonBuilter macro? I recently used it and ran into a problem with an addon I built. The labels on my new macro are not showing up . Drew suggested it might be a language file missing? http://nabble.documentfoundation.org/file/n3730282/labels.png Beth

[libreoffice-users] Re: UNION Query throwing error

Thanks, Jay, That helped me refine it beautifully :-) I love this feature of reportbuilder. I was able to eliminate the relationship tables entirely and just do separate selects for the relevant tables themselves, which cut out a ton of extra work! Now I am going to attempt to repeat this with

[libreoffice-users] Re: UNION Query throwing error

Oh Oh! I hit Edit- Run SQL Directly and I'm getting much more informative error messages - stand-by :-) -- View this message in context: http://nabble.documentfoundation.org/UNION-Query-throwing-error-tp3695780p3695882.html Sent from the Users mailing list archive at Nabble.com. -- For

[libreoffice-users] Re: UNION Query throwing error

One more requirement - in report builder properties, chose in general Query, but Analize SQL:NO. -- View this message in context: http://nabble.documentfoundation.org/UNION-Query-throwing-error-tp3695780p3696191.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

[libreoffice-users] UNION Query throwing error

Hello! Wonder if my error jumps out at any of you - attempting to get a 3 column result - would you take a look? `( SELECT appointment.date AS Date, physician.lastname AS Description, appointment.time AS Comment FROM pat_appt, appointment, physician, patient WHERE pat_appt.appt_id =

[libreoffice-users] Re: UNION Query throwing error

This was my solution: `( SELECT appointment.date AS Date, appointment.notes AS Description, physician.lastname AS Comment, TO_CHAR(appointment.time, 'HH24:MI:SS') AS Notes, 'Appt' AS Type FROM pat_appt, appointment, physician, patient WHERE pat_appt.appt_id = appointment.id AND patient.id =

[libreoffice-users] Re: Triggering reports from html files

Solved! Yey! Thanks to Drew's reportrunner extension, I succeeded in getting a macro to run one specific report from a button on my forms. I edited the macro so it would accept assigned values for DBName and aReport, then made copies of Main () on mdlExecReport to create one for each report,

[libreoffice-users] Re: Triggering reports from html files

I edited mdlExecReport and added a function OpenAllergyReport, which is a duplicate of OpenReport(). This works when I access the macro from the toolbar - in both the DB object and an exported .odt form (where I hoped to put the button). It's throwing one error for line 305 (not optional??), but

[libreoffice-users] Re: Triggering reports from html files

Oh - that's a typo of sorts... http://nabble.documentfoundation.org/file/n3668719/allgergybutton.png -- View this message in context: http://nabble.documentfoundation.org/Triggering-reports-from-html-files-tp3654402p3668719.html Sent from the Users mailing list archive at Nabble.com. -- For

[libreoffice-users] Re: Triggering reports from html files

Hi Drew :-) Jeff has the one you sent me - we're working on the project together. He has it working now, too. Thanks! Beth -- View this message in context: http://nabble.documentfoundation.org/Triggering-reports-from-html-files-tp3654402p3668089.html Sent from the Users mailing list archive

[libreoffice-users] Re: Triggering reports from html files

Good idea, Fernand :-) Will do. -- View this message in context: http://nabble.documentfoundation.org/Triggering-reports-from-html-files-tp3654402p3664076.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

[libreoffice-users] Re: Triggering reports from html files

Hi Drew, Thanks for your reply. Part of my problem is the hidden URL to run the report - can you advise me as to how to determine what the URL might be? Beth -- View this message in context: http://nabble.documentfoundation.org/Triggering-reports-from-html-files-tp3654402p3661011.html Sent

[libreoffice-users] Re: Triggering reports from html files

Hi Fernand, Thanks for the reply. It appears reportrunner may no longer be available http://extensions.services.openoffice.org/project/reportrunner but I will continue a search for it. I am using an html5 document as my main navigator for access to reports and forms. Part of the problem is I

[libreoffice-users] Re: Triggering reports from html files

So does report runner exist anymore? How do I find the path to the report within base - seems if I can use open or href to open it, I could run it. I may be getting in way over my head and unfortunately my time is limited. What would you recommend? -- View this message in context:

[libreoffice-users] Re: Triggering reports from html files

Awesome! Thank you, Drew! I don't see the attachment, just a link to the API site... I'd be happy to familiarize myself with it. It would definitely be helpful to many! Beth -- View this message in context:

[libreoffice-users] Re: Triggering reports from html files

Sweet! It's listing the reports in my app :-) Thanks so much! We'll keep you posted... I think I'm going to try putting a button on my data entry form that runs the specific report. Yey! Beth -- View this message in context:

[libreoffice-users] Re: Triggering reports from html files

Hi :-) I'm so excited to have this working! I created a button, added an event - execute action, selected the mdlMngDlg - ShowRunReportDialog, but got an error - wrong number of paramaters. Any tips? On Sun, Jan 15, 2012 at 6:13 PM, blesko [via Document Foundation Mail Archive] ml-node

[libreoffice-users] Re: Triggering reports from html files

I sent an empty email to users+subscr...@global.libreoffice.org, so hopefully I will soon be fully subscribed - TY :-) On Thu, Jan 12, 2012 at 2:35 PM, Tom [via Document Foundation Mail Archive] ml-node+s969070n3654673...@n3.nabble.com wrote: Hi :) I think you have not yet subscribed to the

[libreoffice-users] Re: Triggering reports from html files

All registered! -- View this message in context: http://nabble.documentfoundation.org/Triggering-reports-from-html-files-tp3654402p3654951.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Triggering reports from html files

Hello! I have developed an application using libreoffice base. I navigate to all the forms from an html5 document. Here's my problem: I've created some reports using report builder, but cannot trigger the generation of a dynamic report from the html file. All my research points to the

[libreoffice-users] Re: Triggering reports from html files

Haha - just tried that and got the same - not approved yet, but maybe it will go through here: Hello! I have developed an application using libreoffice base. I navigate to all the forms from an html5 document. Here's my problem: I've created some reports using report builder, but cannot

[libreoffice-users] Triggering reports from html files

Hello! I have developed an application using libreoffice base. I navigate to all the forms from an html5 document. Here's my problem: I've created some reports using report builder, but cannot trigger the generation of a dynamic report from the html file. All my research points to the

[libreoffice-users] Re: Triggering reports from html files

I confirmed my registration with the Document Foundation Archive and can view both my post and your response when logged in... hopefully it's okay :-P Thanks for the warning - I'll check it out. Beth On Thu, Jan 12, 2012 at 2:35 PM, Tom [via Document Foundation Mail Archive]