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

Thanks

I'll see what I can do.


On 10/31/2014 9:28 AM, Andrew Douglas Pitonyak wrote:
> I expect something like this to print the document
>
> ThisComponent.printPages(Array())
>
>
> Of course, you need to load it first so you would likely have 
> something like
>
>
> oDoc = StarDesktop.loadComponentFromURL( "URL_OF_THE_DOCUMENT", _
>
> "_blank", 0, Array() )
>
>
> And then print the oDoc
>
> I did not try this, but it should work. Also, don't just close the 
> document
>
> On 10/30/2014 10:18 AM, Paul D. Mirowsky wrote:
> > Yes, that seems correct.
> >
> > On 10/29/2014 4:55 PM, Andrew Douglas Pitonyak wrote:
> > > Are you asking if it is possible to use a macro to open a document 
> > > and then print it?
> > >
> > > On 10/28/2014 11:56 PM, Paul D. Mirowsky wrote:
> > > > 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