Hi Adrien.

 

Thanks for your prompt replies to this and the subsequent comments from others.

 

Re #3 (page size) - I'm not sure from my testing that this affects the PDF 
output, maybe it's only the hysical printing formatting (when it is working 
again!)?.

 

Regardless, it does seem that the copy and paste to excel may be the most 
expedient way of formatting. I'm writing VBA Macros to auto format my common 
reports. Thank you for the tip about copy and paste rather than go through the 
HTML step😊

 

Re page numbers in the footer, I haven't found any variable for that, but as I 
will now be going through Excel that's not required.

 

I suggest that financial reporting is a very high priority, and having that as 
an integral function of GNUCash will be a huge timesaver globally amongst your 
users😊

 

Thanks again for your guidance.

 

Cheers

...Steve

 

 

-----Original Message-----
From: gnucash-user <gnucash-user-bounces+sparry=vidar.com...@gnucash.org> On 
Behalf Of Adrien Monteleone
Sent: Thursday, 5 April 2018 01:00
To: GnuCash User List <gnucash-user@gnucash.org>
Subject: Re: GNUCash 3.0: Report Printing problems

 

Welcome to GnuCash Steve!

 

I just caught up on a thread about W10 printing issues. It seems the problem 
has indeed carried over to the 3.0 series. (and still exists in 2.6.x)

 

As long as you can then print that PDF, it’s an extra step, but you aren’t 
locked out of printing.

 

Unfortunately, looking at your questions in 2-4, you might need an extra few 
steps anyway.

 

There’s no need to export first, you can simply select-all and copy/paste your 
report into Excel, and use that to format your printout with desired 
page-breaks, paper size, and footer.

 

Directly to your #3 - Check in File > Page Setup. You can set paper size and 
orientation there.

 

You can’t directly control page breaks, but you can change page orientation and 
you can adjust font-size by editing the stylesheets or creating your own 
stylesheet. However, you’ll likely have to alter this by trial and error and 
then do so each time the report changes. (not very time efficient)

 

Likewise, you can customize the Footer stylesheet to your needs which will 
allow you to print a footer on the page. There are some variables to use in 
some places but I’m not sure if page-number and page-count are included in 
these or if they’d even work in the footer. You might have to create a custom 
report. (which would be even more trouble)

 

The easiest way to get all requirements is to copy/paste and format in Excel as 
noted.

 

Please note, a proper reporting system is on the wish list, but it’s going to 
be well down the road until after core parts of the app are rebuilt, 
particularly, the transition to a true database app. Till then, we can always 
use our favorite spreadsheet for custom and ‘pretty printing’.

 

Regards,

Adrien

 

> On Apr 4, 2018, at 2:03 AM, Steve Parry < <mailto:spa...@vidar.com.au> 
> spa...@vidar.com.au> wrote:

> 

> Hi all,

> 

> GNUCash newbie here.

> 

> 

> 

> The problems I am having are: 

> 

> 1.         I can only print to PDF – no option for real printer use. I 
> understand this is a problem with GNUCash on W10, so I’ll let that go.

> 

> 

> 

> 2.         If I create a PDF report it splits whatever is at the page break 
> across the pages. For example the top half of a text line will be on the 
> bottom of page 1 and the bottom half of the text on page 2. How do I make it 
> page break at the end of a line?

> 

> 

> 

> 3.         Australia use A4 paper, but I can’t see where the PDF page size in 
> GNUCash is set up. One Report needs to be in A3 landscape, and currently I 
> have to export it to HTML, into Excel, reformat and then print it.  Is there 
> a way of setting the PDF print properties for GNUCash?

> 

> 

> 

> 4.         I want to add a report footer that has “Page x of y” in for my 
> multi-page reports. How do I do that?

> 

> 

> 

> Thank you everyone – be gentle😊

> 

> 

> 

> Cheers

> 

> …Steve

> 

> _______________________________________________

> gnucash-user mailing list

>  <mailto:gnucash-user@gnucash.org> gnucash-user@gnucash.org

> To update your subscription preferences or to unsubscribe:

>  <https://lists.gnucash.org/mailman/listinfo/gnucash-user> 
> https://lists.gnucash.org/mailman/listinfo/gnucash-user

> If you are using Nabble or Gmane, please see  
> <https://wiki.gnucash.org/wiki/Mailing_Lists> 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

> -----

> Please remember to CC this list on all your replies.

> You can do this by using Reply-To-List or Reply-All.

 

_______________________________________________

gnucash-user mailing list

 <mailto:gnucash-user@gnucash.org> gnucash-user@gnucash.org

To update your subscription preferences or to unsubscribe:

 <https://lists.gnucash.org/mailman/listinfo/gnucash-user> 
https://lists.gnucash.org/mailman/listinfo/gnucash-user

If you are using Nabble or Gmane, please see  
<https://wiki.gnucash.org/wiki/Mailing_Lists> 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-----

Please remember to CC this list on all your replies.

You can do this by using Reply-To-List or Reply-All.

_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Reply via email to