Re: [libreoffice-users] Printing Reports from BASE extends to Writer?

Can this be extended to Writer document, eliminating the requirement of 
opening Writer and selecting 'Print'?

On 10/28/2014 4:05 AM, Walther Koehler wrote:
> Hi Peter
>
> just another proposal:
>
> sub printreport()
>
> Dim oDoc as Object
> Dim arg(0) as new com.sun.star.beans.PropertyValue
>
> oDoc=ThisComponent
> arg(0).name = "Name"
> arg(0).value = "<" & "myprinter" & " >"
> oDoc.printPages(arg())
> end sub
>
> Yours
> Walther
>
> Am Dienstag, 28. Oktober 2014 schrieb Peter Goggin:
> > On 28/10/14 15:01, Marion & Noel Lodge wrote:
> > > Hi Peter,
> > >
> > > A macro similar to this should do what you want -
> > >
> > > Sub PrintReport()
> > >           ThisDatabaseDocument.ReportDocuments.getbyname("<name of your
> > > report>").open()
> > > End Sub
> > >
> > > Then edit your Menu form, double click on the Print button and under
> > > Events
> > >
> > > | 'Mouse button pressed', link the button to the PrintReport() sub.  Then
> > >
> > > when you run your application, clicking on the button should fire your
> > > report.
> > >
> > > Noel
> > > --
> > > Noel Lodge
> > > lodgemn@gmail.com
> > >
> > > On 28 October 2014 13:24, Peter Goggin <petergoggin@bigpond.com> wrote:
> > > > I have a report run from a push button on a menu form. I can print it
> > > > from the screen, but in Access I was able to program a push button to
> > > > print id directly.  Is this possible in BASE? I cannot find any
> > > > reference to this.
> > > >
> > > > Regards
> > > >
> > > >
> > > > Peter Goggin
> > > >
> > > > --
> > > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> > > > unsubscribe/
> > > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > > > List archive: http://listarchives.libreoffice.org/global/users/
> > > > All messages sent to this list will be publicly archived and cannot be
> > > > deleted
> > Thanks for the suggestion. However all the subroutine does is display
> > the report on the screen. I want to be able to send it to the printer
> > without first displaying it on the screen. So far I cannot see any
> > reference on how to doi this.
> >
> > Regards
> >
> > Peter Goggin


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted