David,
I don't know what your print statement says when you go to print your
report, but here is some help via RDocs;
PRINT reportname WHERE whereclause ORDER BY orderbyclause +
OPTION PDF +
|SHOW_CANCEL_DIALOG value +
|FILENAME filespec +
|TITLE value +
|SUBJECT value +
|AUTHOR authorname +
|KEYWORDS values +
|BACKGROUND_COLOR value +
|BACKGROUND_FILE filespec +
|BACKGROUND_TYPE value +
|COMPRESSION_METHOD value +
|FONT_ENCODING value +
|IMAGE_FORMAT value +
|IMAGE_DPI value +
|PIXELFORMAT value +
|INCLUDE_IMAGES value +
|INCLUDE_LINES value +
|INCLUDE_RICHTEXT value +
|INCLUDE_SHAPES value +
|JPEG_QUALITY value +
|RICHTEXT_ENCODING_TYPE value +
|USE_COMPRESSION value + ****
|OPEN value
****COMPRESSION_METHOD
Specifies the type of compression to be used to compress text and
Image.
. FASTEST
. NORMAL
. MAXCOMPRESS
Try MAXCOMPRESS and see if it reduces your PDF file size.
Best,
Bill Eyring
_____
From: [email protected] [mailto:[email protected]] On Behalf Of David
Blocker
Sent: Tuesday, December 01, 2009 7:57 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Report prints extra page; PDF file generated is huge
Thanks to all on the list who assisted me in working through issues on the
columnar report I?ve been creating the last few days!
There are now 2 remaining issues with the report, one minor, one a possible
deal breaker. The report is a membership list for a musician?s union.
<!--[if !supportLists]-->1. <!--[endif]-->The report ALWAYS prints an
extra blank page at the end, whether I print for the full data set of about
1700 rows or just a portion. The report breaks first on a variable set to
the first letter of the full name, then on the name itself in order to keep
each listing together without wrapping to the next column.
The first break has nothing checked off re keep break together, reprint
break header etc. The second has Keep break together checked off.
The page footer has a Before Generate Custom EEP which prints the first
letter of the group on that page. The EEP moves the letter from side to
side of the page for odd and even pages:
IF vCounter2 = 1 THEN
SET VAR vCounter2 = 0
PROPERTY LetterGroupODD VISIBLE "TRUE"
PROPERTY LetterGroupEven VISIBLE "FALSE"
ELSE
SET VAR vCounter2 = 1
PROPERTY LetterGroupODD VISIBLE "FALSE"
PROPERTY LetterGroupEven VISIBLE "TRUE"
ENDIF
RETURN
The report has Page Style to print the horizontal and vertical lines the
client wants for borders
Ideas?
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
<!--[if !supportLists]-->2. <!--[endif]-->The client wants this report
in a PDF format so they can distribute the list to members by email once a
month.
However the PDF file created is 39,308,445 bytes in size: zipping it does
not significantly reduce the size. The database itself is SMALLER, only
30,284,160 for all 4 files. It would obviously NOT be possible to email
this file.
The workaround I?ve found for now is to print to an RTF file and then use
Word to create a password needed to edit the file, so members can view it
without worrying about editing it. The RTF file for the same report is
5,941,248 in size, a workable number.
Any ideas about why the PDF file is so huge and how to reduce its size?
David Blocker
"David Blocker
[email protected]
Office: 781-344-1920
Cell: 339-206-0261"
