Hi,
I cannot manage in Excel 2010 with Jet 2010 to get a pagebreak after each record of an NL function.
It used to work in old versions the manual says (It copies pagebreaks) but now I cannot manage it.
For example after NL("Rows=12";Table";;;;;;;) the pagebreak after row 12. very simple but it wont work with me. (after the set pagebreak Excel goes to the standard).
Do I need a Macro or is it still possible with standard Excel to solve?
I know there was a topic earlier on this but the answers there i tried but wont work.
TNX
Hans D.
Date
Votes
5 comments
-
Jet Reports Historic Posts Official comment Hi Hans,
Jet Reports 2010 has a new Application setting, General tab: Preserve page breaks. Does your report work if you apply that setting?
Fijn weekend alvast :) -
Jet Reports Historic Posts I knew it should be in the settings.
But not the Excel setting but Jet.
Tnx Hans, you make me and a customer very happy
gr,
Hans D. -
Jet Reports Historic Posts Hi Hans D!
Just to be clear, the reason that preserving page breaks was created as a setting in the newer Jet versions is that it can slow report performance down a lot. So I'd recommend leaving the setting off in general unless you need it. In this case of course you need it, but I wouldn't just turn it on for all customers or turn it on all the time.
Regards,
Hughes -
Jet Reports Historic Posts If that is the case, Hughes, wouldn't it be a nice feature that we can switch this setting on or off in the report? E.g. NP("Pagebreak";"On" or "Off") or NP("Pagebreak";"Yes" or "No".
-
Jet Reports Historic Posts Hi Hans F!
That is a good idea for a future feature request. Possibly something like Auto+Hide+PageBreak in cell A1 of the sheet where you want page breaks preserved. I will put this on the feature requests.
Regards,
Hughes
Please sign in to leave a comment.