Stephen Lebans A97ReportToPDF

  • Thread starter Thread starter RedFish
  • Start date Start date
R

RedFish

Is anyone using this? How do you get a landscaped report to come out
correctly? It always comes out portrait, guess I must be doing something
wrong. If anyone can shed some light, that would be great. Thanks a lot,

Redfish
 
Portrait and Landscape work fine here. What happens when you convert the
sample CustomerLandscape report?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
hmmm.. seems fine. After further investigation, it appears that even though
the snapshots view correctly, they are being created with portrait checked,
rather than landscape. When I try to print them, all the text is adjusted
and bunched together as the snapshot suddenly shifts into portrait mode. I
use the ReportToPDF directly, haveing it create the snapshots and everything
for me, so I guess this would be why they get converted to portrait. Must
be something wrong on my side, looks like I have some digging to do. Any
suggestions? Access 2000, Win2000. Thanks,

Redfish
 
Let's backup a second here. Forget about my code completely. Export the
report in question to Snapshot file format. What happens when you view and
then print this Snapshot within the MS Snapshot Viewer application.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Agreed, after some testing, it appears this problem has nothing to do with
your code. Here is what is happening. In design view, the report is saved
as landscaped. The I open the report and export it to snapshot. When I
first open it in snapshot to view it, everything looks fine. If I hit
print, the print layout tab says that it should be portrait, even though it
is viewed as landscape. If I don't change it, (or didn't bother to look at
that tab at all, for instance), it prints out portrait. As soon as the
print button is pressed, it also changes in the viewer to portrait mode. I
can close the viewer and reopen, and it appears in landscape mode again, but
the same steps produce the same results. I hope that is clear, as I really
don't know where to look for a solution to this. Thanks for the help,

Redfish
 
Actually, it appears to be working almost correctly at this point. The
problem was on our end, with the format of reports being changed back and
forth by different people. The only thing I'm running into now is that the
font, or at least the text size, in some text boxes, appears to be off after
the conversion to PDF. Most reports we run are generic, with the client
name (part of the report header) being data driven. Just using a textbox to
display the name. It is right-aligned, and the resultant PDF always seems
to have the last few letters missing. Any thoughts on that? Thanks a lot,
have a great day!

Redfish
 
Are you be chance using a System Bitmap font for the TextBox in question?
Change it to a non Bitmap font and the issue will go away.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Okay, I changed to a non-true type font, it worked great. Thank you very
much. I don't suppose you know how to change all the font properties of the
labels and text boxes of several different reports in one fell swoop, do
you? Thanks again, have a great evening!

Redfish
 
Wait a minute, there should be no need to bother changing all of your
Reports. You already were using a non Bitmap font as True Type fonts are
vector based.

What font were you using?
Does this font related issue show up when you manually export the Repor to
Snapshot format?
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top