Report output giving different products depending on user

[Mattbro]

Hi all,


I have a database that contains a report. Using the OutputTo command, the report is generated and emailed to a collection of email addresses.
My problem is, when I do this, the report is exported as a .pdf and its fine-a single page of text.
When other users perform the same action on the same database, the report is spread in massive text over 12 pages rather than the single page. My output code is;

DoCmd.OutputTo acOutputReport, "EscalationReport", acFormatPDF, "C:\Escalation\Escalation Report.pdf", False

Any ideas?
Many thanks,
Mattbro451

[ranman256]

is the rpt query based on a form the user picks?
or the user id?
any critieria?

[Mattbro]

is the rpt query based on a form the user picks?
or the user id?
any critieria?

Hi ranman256. The database opens up to Form 'Form1' for all users. Report query is the same for all users. We are all following exactly the same path. I really don't get it-I thought it might be a 'user profile' thing, but the problem does not replicate in similar databases, which makes this unlikely.
Thanks,
Mattbro451

[Micron]

Is this 12 page spread because there are only a few records (or even just one) on a page, or some pages only have a few fields on them, or nothing, - or what? You could be describing a margins or printer paper problem because of someone's settings. I can't recall if output to pdf is based on printer settings or not. Might be worth looking at. Perhaps you designed the report based on 8 1/2 x x11 and they're set to A4?

[orange]

It might be more efficient to get this resolved if you post a copy of your database.
Compact and Repair,then zip, then post.