Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report good on screen, won't print

Status
Not open for further replies.

groleau

Programmer
Apr 12, 2006
110
US
I had a report with so much data, I couldn't come up with a layout users could easily understand.

So I made a copy of it, and then I laid out a subset of the fields on each report.

One of them works fine. The other: In preview, it looks right, only one page long. Design is not too wide for the page. But the printer asks for letter-size paper to be loaded in the manual tray. Push the buttons to override, it spits out one sheet of lett-size paper, completely blank.

--
Wes Groleau
 
It sounds like something is either funky with the printer or some setting saved with the report for the printer.

If after exploring the former you will need to switch the report back to the default printer.

The easiest way to do this is to add a priter to print to LPT1 and select any driver (you do not need a physcial printer).

Next open the report and change the report to print to this printer and save the report.

Next delete the printer.

Finally repopen the report and say yes to whatever language it uses to say "Do you want to use the default printer?"

If things are weird at this point ideally you could try another printer if you do not have access to one... you may try downloading CutePDF a free print to PDF printer driver (actually 2 programs working in tandem but you'll see when you google it).

Then print to the Cutepdf printer and see if it looks right in PDF form. If it does try printing the PDF and see what you get.
 
I've used windows only at work, and have never had a local printer, so I'm not sure I understand all of that. But even if something is wrong with the printer or its queue (which prints thousands of diverse items per week with no problems other than paperjams, toner replacements, and this), why would that problem cause two copies of the same access report to be handled differently after each gets a few data sources changed?

But I will try some of your ideas--downloading software untested by I.S. is not allowed. (And many of the problems we have here are caused by violating that policy.)

--
Wes Groleau
 
If you go into printers in Windows you can hit add new printers as you go through the wizard, tell it to print to the local port and specify LPT1. Then select any of the printers (other than the one you use) and finish out the wizard. Use this as the printer I suggested. Otherwise get your IS department to help you if you either need perission or that isn't enough detail... The relevant portion of my original post quoted below for clarity.

The easiest way to do this is to add a priter to print to LPT1 and select any driver (you do not need a physcial printer).

Next open the report and change the report to print to this printer and save the report.

Next delete the printer.

Finally repopen the report and say yes to whatever language it uses to say "Do you want to use the default printer?"
 
SOLVED.

I was intending to try the suggestions by "lameid" but before I did, I decided to snoop around the menu selections again.

In page setup, "Specific Printer" was selected. I have no memory of changing it or even of going to that tab, but changing it to "Default Printer" solved the problem.

--
Wes Groleau
 
Cool!

I never noticed that before everytime I have seen the solution it was the old school one I suggested of changing to a printer and changing it. I honestly didn't think that setting was acessible via the User interface.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top