I'm supposed to deliver you to the Master now. There's this whole deal where I get to be immortal. Are you cool with that?

Xander ,'Lessons'


Buffistechnology 3: "Press Some Buttons, See What Happens."

Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!


Typo Boy - Mar 05, 2007 11:46:23 am PST #765 of 25496
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.

I'm presuming the report is maintained in word process or dtp software?

Cause if so you can produce two different reports with different print sizes from the same file easily. Just use any software that uses a print driver to print to a pdf. Then print twice to two pdfs, once with the first set of print setting, once with the second.

Actually I think you can produce a single pdf that will work with different page sizes - but if you can't control the reader version it may not work for everyone. Cause normally page numbers are just hard coded in by your source document. But you can put in javascript buttons, which will work if the user has the right reader version , and (unlike me) has not disabled javscript in adobe. I think the "two files" solution is actually more portable.

(Reader by default automatically rescales pdfs to your print settings. But it probably will add odd page breaks, and hard coded page numbers will wrong.)


tommyrot - Mar 05, 2007 11:50:03 am PST #766 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

The report is generated in MS Access. If I just make the font smaller, the fields remain the same size - they would need to be resized (and moved) as well. Which is why I'd have to maintain two versions (I've had to do this before). I could write VBA code that would shrink all the fields and move them over so they're still lined up touching each other, but there's a bunch of other stuff that would need to be resized and/or moved too, so the doing it with code would just be too complex.

eta: Come to think of it, I could write code that would just loop through every single object on the report, and if it has a font, reduce the size, and if it has a width and/or height, reduce that and recalculate a new 'left' position.

Maybe I'll suggest that to my boss and/or client....


Typo Boy - Mar 05, 2007 12:04:18 pm PST #767 of 25496
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.

OK - before you go creating VBA code, how about this. Take your 8.5X14 version.

choose to print to a pdf. Before hitting the print button, choose letter as your paper size. In your print to pdf driver go to zoom or size or whatever and scale to paper size. Tell to "fit letter". Now hit print, and give it a file name when prompted. open the file, and it should be scaled to letter. (You can print another one on default settings to create on scaled to legal.)

If for some reason your pdf driver does not include these options, you might want to download the free "Cute Pdf" software and install it as an additional printer.


tommyrot - Mar 05, 2007 12:08:05 pm PST #768 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

Oh, that's sort of what I was thinking, Typo Boy, but I couldn't find where to do that.

I'll have to present that option to our client (assuming the result doesn't look too hideous). They might end up decided that it's too much trouble/confusing for their offices, and just pay us to maintain the two versions... we'll see.

I just hate editing multiple similar-but-not-identical versions of report designs....


Typo Boy - Mar 05, 2007 12:37:51 pm PST #769 of 25496
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.

To make it easier for the client to say "yes" to the simple solution:

Can you simply save the same report twice under two different names with two different default settings. Better yet, to avoid maintaining two reports, can you make a really simple access macro to run the report twice to PDFs with two different print size settings and two different file names (say "ReportnameDDMMYYYYletter.pdf" and reportnameDDMMYYYYlegal.pdf"?


tommyrot - Mar 06, 2007 10:09:36 am PST #770 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

How well does McAfee rate for its anti-virus software?

Here is a website that lists tons o' various processes that you might find running on a Windows machine when you look at Task Manager: [link] My boss and I found a bunch of stuff running on our computers that the above link says are viruses, trojans, etc., but when my boss ran McAfee it failed to find anything bad.

I'm running McAfee now - so far it hasn't found anything.


Typo Boy - Mar 06, 2007 10:17:54 am PST #771 of 25496
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.

Umm - I recognize some of the processes the site lists as trojans as legit processes offhand. Also some of the others (iexplore.exe for example) are legit processes that also have trojans that steal the name. I would take McAfee's word on this one, because the site is totally misleading.


Typo Boy - Mar 06, 2007 10:26:23 am PST #772 of 25496
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.

Followup: a little googling shows that the site is advertising for

(http://www.pcintegrityscanner.com

That's why they include legitamate windows processes in with actual virsuses and trojans - to scare you into switching from your current virus scanner to PcIntengrityscanner.


tommyrot - Mar 06, 2007 10:29:34 am PST #773 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

Bah.

And thanks, Typo Boy.


Ailleann - Mar 06, 2007 10:29:41 am PST #774 of 25496
vanguard of the socialist Hollywood liberal homosexualist agenda

tommyrot, if you're still worried, Symantec offers an online virus scan through their website. You don't have to own their software to use it. It doesn't clean, I don't think, but it does list results including virus name.