GNUCash 3.0: Report Printing problems

[Steve Parry]

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.au at gnucash.org> On Behalf Of Adrien Monteleone
Sent: Thursday, 5 April 2018 01:00
To: GnuCash User List <gnucash-user at 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:sparry at vidar.com.au> sparry at 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 at gnucash.org> gnucash-user at 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 at gnucash.org> gnucash-user at 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.