Re: [GNC] Report ROWS (being badly broken at the bottom of a page)

[davidbrown.rdps]

No probs Victor ... good to get some additional advice at any time

-Original Message-
From: R. Victor Klassen  
Sent: 28 September 2018 18:28
To: davidbrown.r...@photos.bozeat.biz
Cc: Gnucash Users 
Subject: Re: [GNC] Report ROWS (being badly broken at the bottom of a page)

Ah. Hijacked thread. I failed to note the date on the earlier posts

Sent from my iPhone

> On Sep 28, 2018, at 11:47 AM,  
>  wrote:
> 
> Thank you Victor ... this was an older query and I did manage that 
> workaround. ... these odd little quirks cause so much when we expect all to 
> be just right!!!
> 
> I have found that just selecting all on a report and pasting onto an Excel 
> sheet does give so much more formatting options, and once a year for that is 
> OK.
> 
> Kind regards
> 
> David
> 
> -Original Message-
> From: R. Victor Klassen 
> Sent: 27 September 2018 23:32
> To: davidbrown.r...@photos.bozeat.biz
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Report ROWS (being badly broken at the bottom of a 
> page)
> 
> This is a problem common to many reports, including invoices, which is 
> the use case for which I learned the work-around.  Copying to a 
> spreadsheet really isn’t a great solution after you’ve figured out how 
> to get an invoice formatted the way you want and then after a couple 
> of years generate an invoice with too many lines and it breaks in the 
> middle of a line badly…
> 
> That said, the customer for which we had the long invoices is no longer a 
> customer of ours, so I haven’t needed the workaround in years, but I’m 
> reasonably certain it still works.  
> 
> The workaround I used was to save the report as HTML and then open it in a 
> browser that respects the tag that tells it not to let that happen.  Yes 
> there is such a tag and it is used in the reports, but it is optional (!) for 
> browsers to respect that tag when generating a print version of the page.  If 
> I recall correctly, Safari is based on the same code as used in GnuCash, and 
> does not respect it, but FireFox does respect it.  I didn’t try Explorer or 
> Chrome, since I had found a solution.  
> 
> From the right browser you can send it to the printer or to a PDF writer and 
> get the correct result.  
> 
>> On May 23, 2018, at 11:04 AM, davidbrown.r...@photos.bozeat.biz wrote:
>> 
>> I note that when printing a report to a PDF file, the page set up is 
>> a bit hit and mis when multiple pages.  Some lines of entries span 
>> into the footer on one page and header of the next giving a split table.
>> Is there any method of having a complete row on one page and the 
>> start of a complete row on the next page.
>> 
>> ___
>> 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.
> 
> 

___
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.

Re: [GNC] Report ROWS (being badly broken at the bottom of a page)

[R. Victor Klassen]

Ah. Hijacked thread. I failed to note the date on the earlier posts

Sent from my iPhone

> On Sep 28, 2018, at 11:47 AM,  
>  wrote:
> 
> Thank you Victor ... this was an older query and I did manage that 
> workaround. ... these odd little quirks cause so much when we expect all to 
> be just right!!!
> 
> I have found that just selecting all on a report and pasting onto an Excel 
> sheet does give so much more formatting options, and once a year for that is 
> OK.
> 
> Kind regards
> 
> David
> 
> -Original Message-
> From: R. Victor Klassen  
> Sent: 27 September 2018 23:32
> To: davidbrown.r...@photos.bozeat.biz
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Report ROWS (being badly broken at the bottom of a page)
> 
> This is a problem common to many reports, including invoices, which is the 
> use case for which I learned the work-around.  Copying to a spreadsheet 
> really isn’t a great solution after you’ve figured out how to get an invoice 
> formatted the way you want and then after a couple of years generate an 
> invoice with too many lines and it breaks in the middle of a line badly…
> 
> That said, the customer for which we had the long invoices is no longer a 
> customer of ours, so I haven’t needed the workaround in years, but I’m 
> reasonably certain it still works.  
> 
> The workaround I used was to save the report as HTML and then open it in a 
> browser that respects the tag that tells it not to let that happen.  Yes 
> there is such a tag and it is used in the reports, but it is optional (!) for 
> browsers to respect that tag when generating a print version of the page.  If 
> I recall correctly, Safari is based on the same code as used in GnuCash, and 
> does not respect it, but FireFox does respect it.  I didn’t try Explorer or 
> Chrome, since I had found a solution.  
> 
> From the right browser you can send it to the printer or to a PDF writer and 
> get the correct result.  
> 
>> On May 23, 2018, at 11:04 AM, davidbrown.r...@photos.bozeat.biz wrote:
>> 
>> I note that when printing a report to a PDF file, the page set up is a 
>> bit hit and mis when multiple pages.  Some lines of entries span into 
>> the footer on one page and header of the next giving a split table.  
>> Is there any method of having a complete row on one page and the start 
>> of a complete row on the next page.
>> 
>> ___
>> 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.
> 
> 
___
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.

Re: [GNC] Report ROWS (being badly broken at the bottom of a page)

[davidbrown.rdps]

Thank you Victor ... this was an older query and I did manage that workaround. 
... these odd little quirks cause so much when we expect all to be just right!!!

I have found that just selecting all on a report and pasting onto an Excel 
sheet does give so much more formatting options, and once a year for that is OK.

Kind regards

David

-Original Message-
From: R. Victor Klassen  
Sent: 27 September 2018 23:32
To: davidbrown.r...@photos.bozeat.biz
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Report ROWS (being badly broken at the bottom of a page)

This is a problem common to many reports, including invoices, which is the use 
case for which I learned the work-around.  Copying to a spreadsheet really 
isn’t a great solution after you’ve figured out how to get an invoice formatted 
the way you want and then after a couple of years generate an invoice with too 
many lines and it breaks in the middle of a line badly…

That said, the customer for which we had the long invoices is no longer a 
customer of ours, so I haven’t needed the workaround in years, but I’m 
reasonably certain it still works.  

The workaround I used was to save the report as HTML and then open it in a 
browser that respects the tag that tells it not to let that happen.  Yes there 
is such a tag and it is used in the reports, but it is optional (!) for 
browsers to respect that tag when generating a print version of the page.  If I 
recall correctly, Safari is based on the same code as used in GnuCash, and does 
not respect it, but FireFox does respect it.  I didn’t try Explorer or Chrome, 
since I had found a solution.  

From the right browser you can send it to the printer or to a PDF writer and 
get the correct result.  

> On May 23, 2018, at 11:04 AM, davidbrown.r...@photos.bozeat.biz wrote:
> 
> I note that when printing a report to a PDF file, the page set up is a 
> bit hit and mis when multiple pages.  Some lines of entries span into 
> the footer on one page and header of the next giving a split table.  
> Is there any method of having a complete row on one page and the start 
> of a complete row on the next page.
> 
> ___
> 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.


___
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.

Re: [GNC] Report ROWS (being badly broken at the bottom of a page)

[R. Victor Klassen]

This is a problem common to many reports, including invoices, which is the use 
case for which I learned the work-around.  Copying to a spreadsheet really 
isn’t a great solution after you’ve figured out how to get an invoice formatted 
the way you want and then after a couple of years generate an invoice with too 
many lines and it breaks in the middle of a line badly…

That said, the customer for which we had the long invoices is no longer a 
customer of ours, so I haven’t needed the workaround in years, but I’m 
reasonably certain it still works.  

The workaround I used was to save the report as HTML and then open it in a 
browser that respects the tag that tells it not to let that happen.  Yes there 
is such a tag and it is used in the reports, but it is optional (!) for 
browsers to respect that tag when generating a print version of the page.  If I 
recall correctly, Safari is based on the same code as used in GnuCash, and does 
not respect it, but FireFox does respect it.  I didn’t try Explorer or Chrome, 
since I had found a solution.  

From the right browser you can send it to the printer or to a PDF writer and 
get the correct result.  

> On May 23, 2018, at 11:04 AM, davidbrown.r...@photos.bozeat.biz wrote:
> 
> I note that when printing a report to a PDF file, the page set up is a bit
> hit and mis when multiple pages.  Some lines of entries span into the footer
> on one page and header of the next giving a split table.  Is there any
> method of having a complete row on one page and the start of a complete row
> on the next page.
> 
> ___
> 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.

___
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.

Re: [GNC] Report ROWS

[Adrien Monteleone]

Not sure how this relates to the original post, but you have a couple of 
options.

1. Run a separate report for each period, copy/paste the contents of each into 
a spreadsheet, adjust as needed.
2. Run a multi-column report, put each period in its own column. This however 
will duplicate the account names, so if you don’t want that, you’ll still need 
to copy/paste the result into a spreadsheet to adjust as desired.

Note, there will likely be a new Balance Sheet/Income Statement report in 
version 3.3(due in October) or 3.4. This new report is supposed to properly 
generate multiple periods in the same report.

Regards,
Adrien

> On Sep 27, 2018, at 5:52 AM,  
>  wrote:
> 
> I have been using GNU cash now for just over a year and now into 2nd year.  
> Have been trawling through the help files but yet to find the explanation.  I 
> want to provide the EndOfYear reports with last year figures on the LH side.  
> Wondering whether this works with just one type of report or with a number of 
> them?
> 
> Kind regards
> 
> DAvid
> 
> ___
> 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.
> 


___
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.

Re: [GNC] Report ROWS

[davidbrown.rdps]

I have been using GNU cash now for just over a year and now into 2nd year.  
Have been trawling through the help files but yet to find the explanation.  I 
want to provide the EndOfYear reports with last year figures on the LH side.  
Wondering whether this works with just one type of report or with a number of 
them?

Kind regards

DAvid

___
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.

Re: [GNC] Report ROWS

[davidbrown.rdps]

Hello Adrien, thank you for your prompt reply.  I use also a PDF printer for 
other applications, but this appears to be not allowed in this App.  Happy with 
using Excel or similar which I have done for the end of year, but to do a quick 
report print particularly with all the options of what to include, and the fact 
there is a page set-up tab if seems to fall down on a simple task?

All ok exporting as html as all one page.  Just seems a bit odd having a split 
row whatever the page set-up.

I use the latest version and vaguely remember being able to print to a printer 
via the windows listing.  The pdf printer is installed as that.

Regards
David



-Original Message-
From: gnucash-user 
<gnucash-user-bounces+davidbrown.rdps=photos.bozeat@gnucash.org> On Behalf 
Of Adrien Monteleone
Sent: 23 May 2018 18:21
To: Gnucash Users <gnucash-user@gnucash.org>
Subject: Re: [GNC] Report ROWS

Any report can either be opened in, or simply copied and pasted into, a 
spreadsheet where you can fine tune all aspects of printing. (particularly page 
breaks)

This also gives you the benefit of being able to do additional analysis or 
include other calculations and likely create better charts using the 
spreadsheet app’s more advanced charting features. 

Regards,
Adrien

> On May 23, 2018, at 10:04 AM, <davidbrown.r...@photos.bozeat.biz> 
> <davidbrown.r...@photos.bozeat.biz> wrote:
> 
> I note that when printing a report to a PDF file, the page set up is a 
> bit hit and mis when multiple pages.  Some lines of entries span into 
> the footer on one page and header of the next giving a split table.  
> Is there any method of having a complete row on one page and the start 
> of a complete row on the next page.
> 
> ___
> 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.
> 


___
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.

___
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.

Re: [GNC] Report ROWS

[Adrien Monteleone]

Any report can either be opened in, or simply copied and pasted into, a 
spreadsheet where you can fine tune all aspects of printing. (particularly page 
breaks)

This also gives you the benefit of being able to do additional analysis or 
include other calculations and likely create better charts using the 
spreadsheet app’s more advanced charting features. 

Regards,
Adrien

> On May 23, 2018, at 10:04 AM,  
>  wrote:
> 
> I note that when printing a report to a PDF file, the page set up is a bit
> hit and mis when multiple pages.  Some lines of entries span into the footer
> on one page and header of the next giving a split table.  Is there any
> method of having a complete row on one page and the start of a complete row
> on the next page.
> 
> ___
> 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.
> 


___
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.

[GNC] Report ROWS

[davidbrown.rdps]

I note that when printing a report to a PDF file, the page set up is a bit
hit and mis when multiple pages.  Some lines of entries span into the footer
on one page and header of the next giving a split table.  Is there any
method of having a complete row on one page and the start of a complete row
on the next page.

___
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.