Hi all,
I’m creating a report with 18 columns for monthly sales results.
Is there a way of printing a form which is wider than a page (landscape)?
I should probably not be answering this because I am brand new to Servoy and have never made even one report yet! So please don’t waste too much time seeing if this is the best approach, I’m only posting based on other environments I’ve worked in, all of which would have solved your problem this way:
– Create one report form with the number of columns that fit across one of your landscape pages. Get the header part and fonts and everything all set up the way you definitely want them. Let’s say 9 columns fit on one page.
– Duplicate the form and in this 2nd form just respecify the fields (and retype column labels accordingly) to be the OTHER 9 fields.
– Write a method that selects the methods, prints using Report Form 1, and then prints again using Report Form 2.
Again, take my advice with a huge “grain of salt” (i.e., I don’t know what I’m talking about when it comes to Servoy!). I’ll leave it to the experts here to refute or confirm my suggestion, and either way we’ll both have learned something.
Good luck
Harriet_Rosenberg:
– Write a method that selects the methods
woops, of course I meant “write a method that selects the records” [for your report]
Hi Harriet,
your method will work as long as there are no surprises caused by print-sliding 
I forgot to say that I have created the report in HTML, by quering the SQL database directly using getDataSetByQuery(), so I would like to print a single field which is more than one page wide…
In FileMaker, I Would go to the print setup and reduce to 70%, or 50% or whatever to make the report fit, unfortunately the HTML stays the same size in Servoy…
your method will work as long as there are no surprises caused by print-sliding
Ah. I was envisioning a one-line-per-row kind of thing. Yes, sliding could make my suggestion a mess.
I forgot to say that I have created the report in HTML, by quering the SQL database directly using getDataSetByQuery(), so I would like to print a single field which is more than one page wide…
In FileMaker, I Would go to the print setup and reduce to 70%, or 50% or whatever to make the report fit, unfortunately the HTML stays the same size in Servoy…
I have not investigated creating reports in HTML yet (or creating any kind of report) so here’s my next know-nothing suggestion:
If you’re returning HTML to a field in order to pull this report, if the entire printed page is done in html (I’m having trouble envisioning how this works) as opposed to a regular field being in the Header for example and then html being used for the Body part (rows), can’t you include a Size tag in the html to reduce the font? Or maybe even a simpler method of just using a smaller font?
It’s unclear at this point if your real requirement is to reduce the printout to fit on ONE landscape page, or (as you started out asking) to split the report’s width across 2 pages…
Harriet_Rosenberg:
It’s unclear at this point if your real requirement is to reduce the printout to fit on ONE landscape page, or (as you started out asking) to split the report’s width across 2 pages…
I’m happy either way, as long as my client can see all the columns…
Swingman, you should be able to grow/shrink your report based on the content. I just made a report with one html field on it. I have seen it growing (yet) but it shrinks like expected so I suppose it will grow too…
Maybe I am not understanding your question, but would setting the form “paperPrintScale” property to a value higher than 100 solve your problem? It will allow you to print a lot more on a standard size piece of paper.
I noticed that in 2.1.2 growing and shrinking a html field doesn’t work horizontally and vertically.
In 2.2 it does work vertically but doesn’t work horizontally…
IT2BE:
I noticed that in 2.1.2 growing and shrinking a html field doesn’t work horizontally and vertically.
Correct it works only one way, see docs
swingman:
Is there a way of printing a form which is wider than a page (landscape)?
No there is none…, tip use printscale to fit the width on 1 page