Reference

DPI (dots-per-inch) resolution to which all pictures are recomputed. You can use this property to reduce the output document size.

This property must be sent before calling the SetParams method.
Default value: 0 (do not recompute, keep pictures as they are)

Picture format of activeX components converted to pictures.

Allowed values: “bmp”, “jpg”, "png", "tif", "gif"

Default value: “jpg”

Syntax:

lnRetVal = loXFRXobj.ErrorMessage(lnErrorNo)

This method returns a error message corresponding to the value returned from SetParams() method.

Call this method to set the document generation parameters.

Syntax:

 lnRetVal = loXFRXobj.SetParams(<tcOutputName>, <tcTempDirectory>, <tlNotOpenViewer>, <tcCodePage>, 
                                <tlSilent>, <tlNewSession>, <tcTarget>, <tcArchive>, <tlAdditive>, 
                                <tlDeleteFileAfter>, <tuAppend>)

Return values: 

   0 ... everything was ok, you can start processing reports
  -1 ... cannot load Word or Excel application
  -2 ... the Word or Excel application version must be 2000 or higher
  -3 ... cannot create or open the output file
  -4 ... unknown target
  -5 ... hndlib.dll cannot be loaded (it is missing or an old version is used)
  -6 ... xfrxlib.fll cannot be loaded (it is missing or invalid). Please see Frequently asked questions if you are getting this error.  
  -7 ... zlib.dll cannot be loaded
  -8 … An old xfrxlib.fll is used
  -9... Sorry, Word 2007 or higher is required for docx format!
-10 … The existing document is either corrupted or in an unsupported format
-11 ... Signature file not found
-12 ... Cannot use the signature file
-13 ... The output folder does not exist or you do not have write access

Parameters:

tcOutputName
  the name of the document to create.

tcTempDirectory
  directory where temporary files will be created. If blank, the temporary files will be created in the current directory [optional]

tlNotOpenViewer
  if set to .T., documents won't be opened after the generation [optional]

tcCodePage
  is a codepage of the generated document [optional]. If you don't specify this parameter, cpcurrent() is used.

tlSilent
  if set to .T., no messages will be printed [optional]. This option is useful if your application is not in English and/or you would like to handle the Processing... message and error messages in your code.

tlNewSession
  by default, word document will be open in the current Word session, if exists. If this paramenter is set to .T., the document will always be open in a new Word session. This option is not used for PDF targets. [optional]

tcTarget
  The output type to be generated. One of the values listed at XFRX Output Target Types (above).

tcArchive
  The name of the zip archive to be created. If not empty, the generated file will be added to the archive after generation (optional)

tlAdditive
  If set to .T. and the archive already exists, the file will be added. (optional)

Please note: you can add several files to the archive, but existing files with the same name will not be overwritten - the new files will always be added.

tlDeleteFileAfter
  If set to .T., the generated file is be deleted after it is copied to the archive. (optional)

tuAppend
  Specifies whether the generated document will be appended to an existing file. This parameter can be either logical, numeric or a string, with the following meaning:

Examples:

This parameter applies to PDF documents only (optional, default value = .F.)

This method is used to add various output type specific parameters. The first parameter is a string value representing the parameter to be set, the second parameter is the values to be set.

Example:

To set the next sheet name in the XLS document to “Customer 1”, call:

.SetOtherParams("NEXT_SHEET_NAME", "Customer 1")

HTML specific parameters

Plain text specific parameters

Please find more information about plain text parameter in Converting reports to plain text chapter on page 41.

XLS, XLSPLAIN, NATIVE_FXLS, NATIVE_PFXLSX, ODS,FODS, PFODS specific parameters

This method finishes the document generation and displays the generated document (unless the document preview was explicitly suppressed).

The Finalize() method does not have to be called in VFP 9.0, if the last REPORT FORM command doesn’t contain the NOPAGEEJECT clause. 

This method create log file with name "_XFRX.log".

Syntax 

= loXFRXobj.initLog(<tlSilent>)

Parameters:

 tlSilent
  do not write header to log file [optional]

This method create log file with name <tcLogFile>.  

Syntax  

= loXFRXobj.setLogFile(<tcLogFile>, <tlSilent>)

Parameters:

 tcLogFile
  the name of the log file to create.

 tlSilent
  do not write header to log file [optional]

Syntax: 

RegisterScript(toScriptObject, tcScriptMethod, tnZOrder, tcPageScope, tnNumberingType) 

Parameters:

toScriptObject
  The PDFLScripts object reference

tcMethodName
  The name of the method containing the script

tnZIndex
  0 ... print below (before) the report page
  1 ... print above (after) the report page

tcScope
  Defines which pages to invoke the scripts on. Can contain "ALL", "ODD", "EVEN" and numbers delimited with commas. Hyphens can be used to define the from-to scope. Examples: "ODD", "1,5-19", "ODD,4,8"

tnPageNumberingType
  Defines how XFRX determines the page number: 
0 ... absolute - the page number in the document, 
1 ... relative - the page number in the current report, 
2 ... the value of _PAGENO

Syntax: 

UnregisterAllScripts()

If multiple reports are merged together and you would like to apply scripts on a certain report but not on subsequent ones, call this method to remove all scripts registrations.

This method does not need to be called at the end of the reports processing.

Use this method to define a user-define page size.

Syntax:

setPaperSize(nUDPaperWidth, nUDPaperHeight[,nUDPaperOrientation] )

Please see User-defined page size paragraph on page 18 (nad) for more information.

nUDPaperWidth
 Paper width

nUDPaperHeight
 Paper height

nUDPaperOrientation 
 Paper orientation (XFRX 15.5)

Use this method to shorten the page size. Please see HTML page size adjustment na stránce 34 for more information.

Sets passwords for PDF and Word document protection.

PDF syntax:

setPasswords(tcOwnerPassword, tcUserPassword)

Parameters:

The user password (tcUserPassword) can be empty. If the owner password (tcOwnerPassword) is empty, a random string will be generated as the password. 
The owner can do anything with the document. The user permissions can be set using the setPermissions() methods.

Word syntax:

setPasswords(tcReadPassword, tcWritePassword, tlRequirePassword)

You can omit either tcReadPassword or tcWritePassword. tlRequirePassword is optional (default value is .F.). If set to .T., Word will ask for the password even when the document is being opened first time after the generation (if DoNotOpenViewer property is set to .F.).

Sets the user permissions in the PDF document.

Syntax:

setPermissions(tlPrintDocument, tlModifyDocument, tlCopyTextAndGraphics, tlAddOrModifyAnnotations)

Sets the document author property.

Syntax:

setAuthor(tcvalue)

Parameters:
tcValue (char) is a value that will be used in the document properties.

Sets the document “Category” property.

Syntax:

setCategory(tcvalue)

Parameters:
  tcValue (char) is a value that will be used in the document properties.

Sets the document “Comments” property.

Syntax:

setComments(tcvalue)

Parameters:
tcValue (char) is a value that will be used in the document properties.

Sets the document “Company” property.

Syntax: 

setCompany(tcValue)

Parameters:
tcValue (char) is a value that will be used in the document properties.

Remarks: This value will be used for Word and Excel documents only.

Sets the document “creator” property.

Syntax: 

setCreator( tcValue )

Parameters:
(char) is a value that will be used in the document properties.

Remarks: This value will be used for PDF documents only.

Sets the document “keywords” property.

Syntax: 

setKeywords(tcValue)

Parameters:
tcValue (char) is a value that will be used in the document properties.

Remarks: This value will be used for PDF, Word and Excel documents.

Sets the document “Manager” property.

Syntax: 

 setManager(tcValue)

Parameters:
tcValue (char) is a value that will be used in the document properties.

Remarks: This value will be used for Word and Excel documents only.

Sets the document “producer” property.

Syntax:  

 setProducer(tcValue) 

Parameters:
tcValue (char) is a value that will be used in the document properties.

Remarks: This value will be used for PDF documents only.

Sets the document “Subject” property

Syntax: 

 setSubject(tcValue) 

Parameters:
tcValue (char) is a value that will be used in the document properties.

Remarks: This value will be used for PDF, Word and Excel documents.

Sets the document title property.

Syntax:  

 setTitle(tcValue) 

Parameters:
tcValue (char) is a value that will be used in the document properties.

Remarks: This value will be used for PDF, Word and Excel documents.

 Specifies whether the generated document will be appended to an existing file. This parameter can be either logical, numeric or a string, with the following meaning:

Examples:

This property applies to PDF documents only.

The code page of the output document.

If set to .T., documents won't be opened after the generation.

Default value = .F.

By default, Word and HTML documents will be open in the current instance of the application, if exists. If this parameter is set to .T., the document will always be open in a new Word / Web browser instance.

Default value = .F.

This is a property of the ReportListener class. If set to .T., no message will be printed during the report generation process.

The name of the file to be generated.

The output type to be generated. One of the values listed at XFRX Output Target Types (above).

Specifies that the generated document should be added to a zip archive.

Syntax:

zipDocument(ArchiveName, AddToArchive, DeleteSourceDocument)

Return values: none

Parameters: 

ArchiveName (char) is the file name of the zip archive

AddToArchive (logical) specifies, if the file should be added to existing archive (.T.) or if a new archive should be created (.F.)

DeleteSourceDocument (logical) if set to .T., the source document will be deleted after adding to the archive.

Processes the report.

Syntax:

ProcessReport(<tcReportName>, <tcForClause>, <tlSummary>, <tcScopeClause>, <tcWhileClause>, <tlPlain>)

Parameters: 

tcReportName
  the name of the report file

tcForClause
 the FOR clause [optional] 

tlSummary
  The summary clause switch. If set to .T., the report is processed as if SUMMARY clause was used in the REPORT FORM command [optional] 

tcScopeClause
  The string corresponding to the report's scope clause (such as NEXT 4, REST, ALL, RECORD nRecno). Default value is "ALL" [optional] 

tcWhileClause
 The while clause [optional]

tlPlain
  Plain format switch. Send .T.  as this parameter to switch the HTML output to PLAIN format. The plain format doesn't generate any page breaks to the document - one long page will be generated. The default value is .F.

The total number of pages in the XFF document

(numeric)

Adds a new page at the end of the document.

Syntax:

XFRXDraw::AddPage([tcPageSize])

Or

XFRXDraw::AddPage(tnPageWidth, tnPageHeight)

Parameters: 

tcPageSize
  The page size of the new page. Available values: “A4”, “letter”

tnPageWidth, tnPageHeight
  The width and height of the new page. The unit can be defined by SetUnit() method. The default unit it point (1/72 in).

If no page size is specified, the current page size is used.

Creates a new XFF file.

Syntax:

XFRXDraw::CreateDocument([tcFileName])

Return values

.T. … the file was successfully created
.F. … file couldn’t have been created ()

An existing file is overwritten.

Parameters:

tcFileName
  The file name if the document to be created. If this parameter is empty, the XFF file is created in memory.

Draws a line on the current page.

Syntax:

XFRXDraw::DrawLine(tnXPos, tnYPos, tnXToPos, tnYToPos [, tnLineWidth[, tnPenPattern]])

Parameters:

tnXPos, tnYPos
  The X,Y coordinates of the start point of the line.

tnXToPos, tnYToPos
  The X,Y coordinates of the end point of the line.

tnLineWidth
  The line width in points. 0 represents hairline. Optional, default value = 1.

tnPenPattern
   The border line pattern:
      0 ... no border
      1 ... dotted
      2 ... dashed
      3 ... dash-dot
      4 ... dash-dot-dot
      8 … solid line

   Optional, default value = 8.

Draws a picture on the current page into a given bounding rectangle. 

Syntax:

XFRXDraw::DrawPicture(tnXPos, tnYPos, tnWidth, tnHeight, tcFilename[, tnAdjType])

Parameters:

tnXPos, tnYPos
  The X,Y coordinates of the upper left hand corner of the bounding rectangle.

tnWidth
  The width of the rectangle 

tnHeight
  The height of the rectangle

tcFileName
  The picture file name

tnAdjType
   0  … clip picture
   1   … stretch picture, retain shape
   2   … stretch picture, fill frame

Draws a rectangle on the current page.

Syntax:

XFRXDraw::DrawRectangle(tnXPos, tnYPos, tnWidth, tnHeight [, tnLineWidth[, tnFill
                        [, tnPenPattern, tnRoundFactor]]])

Parameters:

tnXPos, tnYPos
  The X,Y coordinates of the upper left hand corner.

tnWidth
  The width of the rectangle

tnHeight
  The height of the rectangle

tnLineWidth
  The line width in points. 0 represents hairline. Optional, default value = 1.

tnFill
  0 ... not filled, 1 ... filled. Optional, default value = 0

tnPenPattern
   The border line pattern:
      0 ... no border
      1 ... dotted
      2 ... dashed
      3 ... dash-dot
      4 ... dash-dot-dot
      8 … solid line

   Optional, default value = 8.

tnRoundFactor
  The radius of the rectangle edges curvature. 0 makes the rectangle right-angled (no rounding), 99 creates an ellipse. Optional, default value = 0.

Draws a text, using a font defined by SetFont method.

Syntax:

XFRXDraw::DrawText(tnLeft, tnTop, tcText[, tnRotate[, tcLinkName[, tcLinkRef[, tcBookmark
                   [, tcTooltip[, tnmode[, liCP]]]]]]])

Or

XFRXDraw::DrawText(tcText[, tnRotate[, tcLinkName[, tcLinkRef[, tcBookmark[, tcTooltip[, tnmode[, liCP]]]]]]])

Parameters:

tnLeft, tnTop
  The coordinates where the text will be drawn. If the second syntax is used (without the coordinates), the text will be drawn at the current position: which is either a position defined by SetPos() method or a the end of an output if the previous DrawText() method call. 

tcText
  The text to be drawn

tnRotate
  The text rotation angle in degrees. The label will be rotated counterclockwise. Optional, default value = 0.

tcLinkName
  If this parameter is filled, the text will be a named target of a hyperlink. (see tcLinkRef parameter).

tcLinkRef
  If this parameter is filled, the text will be a hyperlink. It will navigate to a target in the local document with tcLinkRef name. To navigate to a http URL, include “http://” at the beginning of the parameter.

tcBookmark
  I not empty, the parameter contains a name of a bookmark that will be created and will navigate to this text.

tcTooltip
  The tooltip displayed when hovering mouse over this text.

tnMode   
  Opaque/transparent mode (since XFRX 15.7). 
0  … “opaque
1   …“transparent”

liCP  
  Code page of text (since XFRX 15.7)

Word wraps the give text and print it into a given bounding rectangle. If the height of the rectangle is zero, then the rectangle stretches to accommodate to full text and the height of the rectangle is returned.

Syntax:

XFRXDraw::DrawTextBox(tnLeft, tnTop, tnWidth, tnHeight, tcText[, tnAlign[, tnVAlign
                      [, tnRotate[,tnRotationPoint[, tcLinkName[, tcLinkRef[, tcBookmark
                      [, tcTooltip[, tnmode[, liCP]]]]]]]]]])

Return value:
  The height of the bounding rectangle is returned.

Parameters:

tnLeft, tnTop
  The X and Y coordinates of the upper left hand corner of the bounding rectangle.

tnWidth, tnHeight
  The width and the height of the bounding rectangle. If tnHeight is 0, the rectangle stretches to accommodate to full text and the height of the rectangle is returned.

tnAlign
  The horizontal alignment of the text inside of the rectangle. The allowed values are:

0  … “left”
1   …“center”
2  … “right”.

Optional, the default value is 0 (left).

tnVAlign
  The vertical alignment of the text inside of the rectangle. The allowed values are:

0  … “top”
1   …“center”
2  … “bottom”.

Optional, the default value is 0 (top).

tnRotate
  The text rotation angle in degrees. The label will be rotated counterclockwise. Optional, default value = 0.

tnRotationPoint

   The point within the rectangle around which the text is rotated. The allowed values are 0..8, optional, default value = 0 (left, top). Please see the picture on the right for the point positions.

tcLinkName
  If this parameter is filled, the text will be a named target of a hyperlink. (see tcLinkRef parameter).

tcLinkRef
  If this parameter is filled, the text will be a hyperlink. It will navigate to a target with tcLinkRef name.

tcBookmark
  I not empty, the parameter contains a name of a bookmark that will be created and will navigate to this text.

tcTooltip
  The tooltip displayed when hovering mouse over this text.

tnMode
   Opaque/transparent mode (since XFRX 15.4).
0  … “opaque
1   …“transparent”

liCP
  Code page of text (since XFRX 15.7)

Returns the bounding rectangle coordinates in the rectangle-bound script.

Syntax:

XFRXDraw::GetBoundingRectangle()

Return value:

   NULL  -  the bounding rectangle is not available  

  Object – an object with the following properties:
   nLeft, nTop – the coordinates of the upper left hand corner of the rectangle
   nWidth, nHeight – the width and height of the rectangle

   The unit of the coordinates can be set by SetUnit() method. The default unit is Point (1/72 in).

Returns the horizontal coordinate of the current position.

Syntax:

XFRXDraw::GetXPos()

Returns the vertical coordinate of the current position.

Syntax:

XFRXDraw::GetYPos()

Opens an existing XFF file.

Syntax:

XFRXDraw::OpenDocument(tcFileName)

Return values

.T. … the file was successfully opened
.F. … file couldn’t have been opened (file doesn’t exist or is locked)

Prints the XFF file to the specified printer.

Syntax:

XFRXDraw::PrintDocument(tcPrinterName, tcJobname, tnFrom [, tnTo [, tcDEVMODE 
                        [, tnPagesPerSheet, [ tnAllEvenOdd, [ tnCopies, [tnUnderlineHyperlinksOnPrint, [laFindString, [lcOutput]]]]]]]])

Return values

-100 … cannot initialize printer device
-101 … cannot initialize printer driver
-102 … cannot initialize DEVMODE structure
     0 … no errors

Parameters:

tcPrinterName
   Then name of the printer to which the document will be sent

tcJobName
   The printer job name

tnFrom
   If numeric, the first page to be printed.

tnTo
   The last page to be printed.

tcDEVMODE
   DEVMODE structure. 

tnPagesPerSheet
   The number of pages per sheet .

tnAllEvenOdd
   Include all pages, odd or even only.  The allowed values are:

   1 ... all pages (default value)
   2 ... odd pages
   3 ... even pages

 tnCopies
   The number of copies.

tnUnderlineHyperlinksOnPrint
   Print hyperlink... 
   0 - No print hyperlink
   1 - Print hyperlink in blue color
   2 - Print hyperlink in green color 

laFindString (XFRX 15.4)
 A array contains strings for   highlight  (background color yelow).

lcOutput (XFRX 15.5) 
 A output file name for virtual printers such as Microsoft XPS Document Writer, PDFCreator.

Alternatively, tnFrom can contain a string value, containing the pages numbers separated by commas and ranges separated by dashes, e.g.:

“1,2,5-6,8,20-30”

SavePicture method saves the report page(s) as a picture.

Syntax:

XFRXDraw::SavePicture(tcFilename, tcType, tnFrom [, tnTo [, tnBpp [, tnJPEGQuality [, tnThumbnailWidth [, tnThumbnailHeight [, tnPagesPerSheet, [ tnAllEvenOdd, [laFindString, [liBackgroundMode] ] ] ] ] ] ] ] ])

Return values
 0 ... no errors was encountered
-1 ... unknown image format
-2 ... page out of range

Parameters:

tcFilename
   The name of the file to be generated.

tcType
  The format of the picture to be saved. Currently supported options are: BMP, GIF, JPEG (JPG), PNG, TIFF (TIF), EMF.

tnFrom
  The page number to be saved. If TIFF format is being saved, the parameter specifies the first page to be saved.

tnTo
  If TIFF format is being saved, the parameter specifies the last page to be saved. Ignored otherwise.

tnBpp
  Bits per pixel. Currently supported values are 2, 16 or 24.

tnJPEGQuality
  Specifies the JPEG compression quality. The range is from 1 - the lowest quality to 100 - the best quality. The default value is 0 - default quality. Ignored for other output types.

tnThumbnailWidth
  The width of the output picture in pixels.

tnThumbnailHeight
  The height of the output picture in pixels.

tnPagesPerSheet
 The number of pages per sheet .

 tnAllEvenOdd
  Include all pages, odd or even only.  The allowed values are:

  1 ... all pages (default value)
  2 ... odd pages 
  3 ... even pages

laFindString (XFRX 15.4)
 A array contains strings for  highlight  (background color yelow).

liBackGroundMode (XFRX 15.5)

   0 ... Opaque (default color is white)
   1 ... Transparent

If both tnThumbnailWidth and tnThumbnailHeight are omitted, the original page size is used. If only one of the values is sent, the other one is calculated accordingly.

Sets the foreground and background drawing colors.

Syntax:

XFRXDraw::SetColor(tfr, tfg, tfb[, tbr, tbg, tbb])

Parameters:

tfr, tfg, tfb
  Red, green and blue components of the foreground color

tbr, tbg, tbb
  Red, green and blue components of the background color (optional)

Sets font name and attributes for subsequent DrawText() or DrawTextBox() calls.

Syntax:

XFRXDraw::SetFont(tcFontName, tnSize[, tlBold, tlItalic, tlUnderline])

Parameters:

tcFontName
  The font name

tnSize
  The font size in points

tlBold, tlItalics, tlUnderline
  The font attributes. These parameters are optional, the default value is .F.

Sets the position where the text will be drawn by the subsequent DrawText() method call.

Syntax:

XFRXDraw::SetPos(tnXPos, tnYPos)

Parameters:

tnXPos, tnYPos
  The X and Y (horizontal and vertical) coordinates of the position. The unit of the coordinates is defined by SetUnit() method, the default unit is Point (pt).

Sets the drawing units.

Syntax:

XFRXDraw::SetUnit(tcUnit)

Parameters:

tcUnit
  The unit code. The allowed values are: “in” – inches, “cm” – centimeters, “pt” – points and “px” – pixels.

Controls if the bookmark should be displayed in the previewer. The allowed values are:

• -1 = Disable bookmarks
• 0 = Enable bookmarks but hide them (users need to click on the bookmark button to see them)
• 1 = Enable bookmarks, always showing them
• 2 = Enable bookmarks, but show or hide them automatically based on whether or not there are bookmarks defined in the report to preview (default)

Controls the visibility of the toolbar at the top. The allowed values are:

• -1 = Disable toolbar
• 0 = The toolbar will be enabled but hidden. It can be invoked via right click shortcut menu
• 1 = The toolbar will be enabled and visible. (default)
  
  

Controls the visibility of the toolbar at the status bar of the previewer container. The allowed values are:

• .T. = show the toolbar (default)
• .F. = hide the toolbar
  
  

XFCont is using this method to display messages via WAIT WINDOW. Should you like to change this, you can override this method in a subclass. 

Syntax:

XFCont::DisplayMessage(tcMessage)

Parameters:

tcMessage
  The message to display

Open ZIP archive file.

Syntax:

eqZIP::OpenArchive(m.tcZipName, m.tnAppend)

Parameters: 

m.tcZipName 

 m.tnAppend

 Return values 

Close ZIP archive file.

Syntax:  

eqZIP::CloseArchive(m.tcComment)

Parameters:

m.tcComment

Open file handle.

Syntax:

eqZIP::OpenNewFile(m.tcFileName, m.ttCreated, m.llIWontUTF8, m.lcPassword, m.liCRC32)

Parameters:  

m.tcFileName

m.ttCreated

m.llIWontUTF8

   A wish uses UTF-8 for encoding file name.

m.lcPassword

 m.liCRC32

Return values
       0 - File append to ZIP archive.
  -102 - ZIP_PARAMERROR
  -103 - ZIP_BADZIPFILE
  -104 - ZIP_INTERNALERROR   

Add some file to ZIP archive.

Syntax:   

eqZIP::AppendFile(m.tcFilename, m.tcNameInArchive, m.llIWontUTF8, m.lcPassword)

Parameters:    

m.tcFileName

m.tcNameInArchive

m.llIWontUTF8
   A wish uses UTF-8 for encoding file name.

m.lcPassword

Return values 
  -1 - The source file doesn't exists 
  -2 - The source file cannot open
   0 - File append to ZIP archive 
  -102 - ZIP_PARAMERROR
  -103 - ZIP_BADZIPFILE
  -104 - ZIP_INTERNALERROR

Write data to opened file handle. 

Syntax:  

eqZIP::WriteData(m.tcData)

Parameters:  

m.tcData
   Data which will be write to file handle. 

Return values
  -102 - ZIP_PARAMERROR
  -103 - ZIP_BADZIPFILE
  -104 - ZIP_INTERNALERROR

Close file handle.

Syntax: 

eqZIP::CloseFile()

Calculate CRC32 checksum for data.

Syntax: 

eqZIP::SYS2007(m.lcData)

Parameters:  

m.lcData
   Data which calculate CRC32 checksum.