Printing problem

[Kathleen Anderson]

When I print, I only get one page, with the SQL at the top and the first part of the results - the rest is truncated - I'm only getting one page. How do I print the complete results, either wrapped on the same page, or continued to the next page? (I do have wrapped enabled in the print options, but it doesn't seem to be the option I'm looking for).

Thanks,

Kathleen

 

[aotte]

Could it be that your print before having retrieved all the rows? Defaulkt preferences is that the SQL window only retrieves enough row to populate the visible grid.

I changed it to a fixed number of 500. Enough for me to see what's going on, and probably too much for what I would want to print, but still manageable...

That way I don't get caught on the 13 rows insetad of the full 25 rows trap.

 

[Kathleen Anderson]

No, there's only 6 rows total, the problem is that there are approximately 20 fields in each row. They are not all shown on the screen unless I scroll right, and it is only printing what I see on the screen.

 

[ScottMattes]

I think that it is working as designed. I always switch to single record mode to print 'wide' result sets.

You could also save the result set as HTML or something and print it with Word or something

 

[Kathleen Anderson]

Thanks, Scott - that does look much better, I now get the SQL and the results on the same page, excpt that it only prints one page. How do I get it to print all the results?

 

[ScottMattes]

I don't know of any automated way - I just scroll to the record/s I want and do a print.

To print as much as possible in the all rows mode about all I can think to try would be to 1) make your font for the grid as small as possible without needing a microscope to read it, 2) close the browser window to give as much room as possible on the screen.