SY_ReportEngine

Class SY_ReportEngine

Inherits

SY_Constant, SY_Password

Properties

LOCAL cReportObjectString$="[regfree]Sage100ERP.Reporting.dll.manifest;Sage100ERP.Reporting.Report"

LOCAL settingGeneral=1

LOCAL settingOptions=2

LOCAL settingSelections=3

LOCAL crRightAlign=3

LOCAL cFontSize=8

LOCAL inCreateSetting=isFALSE

LOCAL cDefaultHeight=221

PROPERTY ViewerZoom

PROPERTY ViewerPrint * Read Only *

PROPERTY PrintUser

PROPERTY NoOfPagesPrinted * Read Only *

PROPERTY OnServer * Read Only *

PROPERTY ConversionWarnings$

Methods

FUNCTION AddDatabaseTable(tableName$)

FUNCTION AddReportSettingInfo(section, settingLines$)

FUNCTION AdjustMargins(reason)

FUNCTION CloseReport()

FUNCTION ConvertReport(reportName$)

FUNCTION CreateFormula(formulaName$, formulaText$)

FUNCTION DatabaseLogon()

FUNCTION DatabaseVerify()

FUNCTION DeleteSection(sectionName$)

FUNCTION Export(prompt)

FUNCTION Export(prompt, destination$)

FUNCTION GetDataField(tableName$, fieldName$)

FUNCTION GetFieldDimensions(fieldObject, top, width, left, height)

FUNCTION GetFormula(formulaName$, formulaText$)

FUNCTION GetFormulaNames$()

FUNCTION GetNumberOfGroups()

FUNCTION GetOrientation()

FUNCTION GetReportKind()

FUNCTION GetReportSummaryInfo(reportTitle$, reportComments$, keywordsInReport$)

FUNCTION GetSectionHeight(sectionObject)

FUNCTION GetSectionObject(areaName$, sectionName$, sectionIndex)

FUNCTION GetSectionWidth(sectionObject)

FUNCTION GetSelectedPrinter$()

FUNCTION GetSelectionFormula$()

FUNCTION InsertDataField(sectionObject, tableName$, fieldName$, dataFieldObject)

FUNCTION InsertFormula(sectionObject, formulaName$, formulaObject)

FUNCTION InsertGroup(tableName$, fieldName$, formula$, sortOrder)

FUNCTION InsertSection(areaName$, newSectionName$)

FUNCTION InsertSort(tableName$, fieldName$, formula$, sortOrder)

FUNCTION InsertSummary(sectionObject, fieldObject, summaryOp)

FUNCTION InsertTextObject(sectionObject, text$)

FUNCTION IsReportOpen()

FUNCTION OpenReport(reportName$)

FUNCTION OpenReport(reportName$, source$)

FUNCTION PageBreakArea(areaName$, pageBreak, resetPageNumberAfter)

FUNCTION Preview()

FUNCTION Preview(orientation, size, source, duplex)

FUNCTION PrintDeferredReport(fileName$, destination$, printer$, port$, driver$, copies, collated$, pageStart, pageEnd)

FUNCTION PrinterSetup()

FUNCTION PrinterSetup(orientation, size, source, duplex)

FUNCTION PrintOut(prompt, copies, collated)

FUNCTION PrintOut(prompt, copies, collated, pageStart, pageEnd)

FUNCTION PrintOut(prompt, copies, collated, pageStart, pageEnd, orientation, size, source, duplex)

FUNCTION RedirectReport(reportName$)

FUNCTION ResetEngine()

FUNCTION ResetEngine(reportName$)

FUNCTION SaveReport(FileName$)

FUNCTION SaveReportAs(FileName$)

FUNCTION SaveReportAs(FileName$, pathOption$)

Save report as specified file name FileName [string, Required] name of Report (.rpt) file pathOption [string, Optional] If used, must be "REPORTS" to force save to the MAS90/Reports directory

Returns

[boolean] always returns success.

FUNCTION SelectPrinter(printer$)

FUNCTION SelectPrinter(printer$, ignoredDriver$, ignoredPort$)

FUNCTION SetExportOptions(formatType, fileName$)

FUNCTION SetExportToEmail()

FUNCTION SetFieldCoord(fieldObject, left, top)

FUNCTION SetFieldProp(fieldObject, horizontalAlignment$, bottomLineStyle$, topLineStyle$, fontBold$, fontSize$)

FUNCTION SetFieldProp(fieldObject, propertyName$, propertyValue$)

FUNCTION SetFieldWidth(fieldObject, width)

FUNCTION SetFormula(formulaName$, formulaText$)

FUNCTION SetFormula(formulaName$, formulaText$, returnFormulaError)

FUNCTION SetOrientation(orientation)

FUNCTION SetPreviewOptions(windowTitle$)

FUNCTION SetPreviewPosition(left, top, width, height)

FUNCTION SetReportSummaryInfo(title$, comments$)

FUNCTION SetReportTitle(reportTitle$)

FUNCTION SetSectionProperty(areaName$, sectionIndex, propertyName$, propertyValue$)

FUNCTION SetSelectionFormula(selectionFormulaText$)

FUNCTION SetXYCoord(xOffset, yOffset)

FUNCTION ShowSection(sectionName$, showSection)

FUNCTION TableExists(tableName$)

Check if specified table exists in Crystal Report

Parameter	Description
tableName$	[input, string] name of table to check

Returns

[boolean] returns success if table exists in Crystal Report

FUNCTION WinFaxDiscardSavedData()

Properties inherited from: SY_Constant

retFAILURE, retSUCCESS, retNEW, retWARNING, retCANCEL, retYES, retNO, msgYES$, msgNO$, msgCANCEL$, msgOK$, msgRETRY$, msgABORT$, msgIGNORE$, msgNOTONFILE$, msgTIMEOUT$, msgDISABLE, msgACTIVE, msgLinkHELP$, msgLinkMSG$, isFALSE, isTRUE, isYES$, isNO$, isBUSY$, edtNONE, edtEXISTS, edtNEW, ctlDISABLE, ctlENABLE, ctlSHOW, ctlHIDE, ctlLOCK, ctlUNLOCK, ctlLOCKORDISABLE, ctlUNLOCKORENABLE, popHIDE, popDISABLE, popSHOW, popSHOWCHECKED, grdMODEVIEW, grdMODEMAINT, grdMODEADD, filCREATE, filLOCK, filCREATELOCK, filGLOBAL, filCREATEGLOBAL, filLOCKGLOBAL, filCREATELOCKGLOBAL, filCHANNEL, filRAW, filPURGE, filLOAD, filINPUT, filNOOBJECT, filPVX, filREFRESH, filPVX4$, filPVX5$, pthCOMPANY$, pthOTHERCOMPANY$, pthPRCOMPANY$, pthOTHERPRCOMPANY$, pthSYSTEM$, pthUSER$, pthSOA$, pthHOME$, pthROOT$, pthDICTIONARY$, pthTEXTOUT$, pthLOCK$, pthLOCKSYS$, pthPREFIX$, pthARCHIVE$, pthLOGFILES$, folderCOMMONPROGRAMFILES, folderCOMMONAPPLICATIONDATA, errOBJECT, errSYSTEMLOCK, errCONTINUE, errEMBEDDEDIO, errSYSLOCK, extSQLCREATETABLE$, extSQLALLOWNULLDATES$, dbALL$, dbNONE$, dateTOSTRINGFORMAT$, dateLONGMASK$, dateSHORTFMT, dateLONGFMT, dateYEARFIRST, dateMONTHFIRST, dateDAYFIRST, timeMINUTESMASK$, timeMINUTES24MASK$, timeSECONDSMASK$, timeSECONDS24MASK$, idxPRIMARY$, idxBATCH$, idxDISPLAY$, dirFIRST, dirLAST, dirNEXT, dirPREVIOUS, typALPHANUM, typZEROFILL, typCHARNUM, typMASTERNUM, typALPHANUMNF, typMASTERNUMC, typALPHA$, typNUMBERS$, typALPHANUM$, typALPHANUMNF$, typCHARNUM$, typMASTERNUM$, typMASTERNUMCLEN, modTASKOTFDISALLOW$, logALLACTIVITY$, logACTIVITY$, logERROR$, logACTNEWCUSTOMER$, logACTDATASYNC$, logACTDATAIMPORT$, logACTOPTIONCHANGED$, logACTPROGRAMLAUNCH$, logDFDM$, logSECURITY$, logTASKSCHEDULER$, logWEBERROR$, logVISUALINTEGRATOR$, logEntryIDLength, chkOFF$, chkON$, chkGRAYED$, secVIEWONLY, secCREATEONLY, secMODIFYONLY, secCREATEMODIFY, secDELETEONLY, secCREATEDELETE, secMODIFYDELETE, secFULLACCESS, secDEFAULTUSER$, secDEFAULTROLE$, regHKEY_CLASSES_ROOT, regHKEY_CURRENT_USER, regHKEY_LOCAL_MACHINE, regHKEY_USERS, regHKEY_CURRENT_CONFIG, regODBC_PATH$, regMAS_PATH$, E3_MYHANDLE, E3_TASK, E3_QUIT, E3_COCHANGE, E3_DATECHANGE, E3_USERCHANGE, E3_SRVRPATH, E3_HELPFILE, E3_TECHSUPPORT, E3_QUERYTOQUIT, E3_SUPERVISOR, E3_CUSTOMIZE, E3_SWITCHMODULE, E3_DISABLEWIN, E3_CURSOR, E3_USERID, E3_PRIVATETASK, E3_CHAT, E3_BROADCAST, E3_RELOAD, E3_PASSTHROUGH, E3_EXECUTE, E3_EXPCOCHANGE, E3_EXPTASK, E3_EXPLAUNCH, E3_SILENT, E3_DIRECT, E3_NODELIST, E3_OCXITEM, E3_MODULEID, E3_CUSTFAV, E3_HOMEPAGE, E3_MINIMIZE, E3_UNDOCKED, E3_DOCKED, E3_PUBLICTASK, E3_LAUNCHURL, E3_BTNCHANGE, E3_STDBTNRELOAD, E3_MYBUSINESS, E3_REGLOADED, E3_LOADED, E3_V4TASK, E3_PUBMODIFY, E3_TASKRELOAD, E3_SETAUTOHIDE, E3_COCHANGE2, E3_TASK_NC, E3_V4TASK_NC, E3_TASK_ALTC, E3_V4TASK_ALTC, E3_PASSWORD, E3_LAUNCHVIEW, E3_LAUNCHBIETASK, E3_CLEANUPBIE, E3_STARTVIEW, E3_BIE_ADMIN, E3_HELPPATH, E3_CUSTOMERID, E3_MASVERSION, E3_LAUNCHEMBEDDED, E3_LAUNCHERMENU, E3_APP_POINTSIZE, E3_LAUNCHERVERSION, E3_DISABLE, E3_ENABLE, E3_SHOW, E3_HIDE, E3_REFRESH, E3_LIBMASTER, WM_COPY, wtsINITIALPROGRAM, wtsAPPLICATIONNAME, wtsWORKINGDIRECTORY, wtsOEMID, wtsSESSIONID, wtsUSERNAME, wtsWINSTATIONNAME, wtsDOMAINNAME, wtsCONNECTSTATE, wtsCLIENTBUILDNUMBER, wtsCLIENTNAME, wtsCLIENTDIRECTORY, wtsCLIENTPRODUCTID, wtsCLIENTHARDWAREID, wtsCLIENTADDRESS, wtsCLIENTDISPLAY, wtsCLIENTPROTOCOLTYPE, thmNORMAL, thmMETAL, thmOLIVE, rptREPORTTYPESTD, rptREPORTTYPELABEL, rptREPORTTYPEMULTCOL, rptISTRUE, rptISFALSE, rptISDEFAULT, rptPORTRAIT, rptLANDSCAPE, rptASCENDING, rptDESCENDING, rptRIGHTALIGN, rptLEFTALIGN, rptHORCENTERALIGN, rptLSSINGLELINE, rptSTSUM, rptSTAVERAGE, rptSTCOUNT, rptDFLTHSPACING, rptDFLTVSPACING, rptDFLTFONTSIZE, rptDFLTLEFT, rptDFLTTOP, rptTWIPSPERCHARW, rptTWIPSPERCHARH, rptSVTREPORTTITLE, rptEDTDISKFILE, rptGCANYVALUE, rptGCDAILY, rptCRDATEFIELD, rptCRDATETIMEFIELD, crEFTCrystalReport, crEFTRichText, crEFTWordForWindows, crEFTExcel, crEFTPortableDocFormat, crEFTHTML32, crEFTHTML40, crEFTExcelRecord, crEFTText, crEFTCharacterSeparatedValues, crEFTTabSeparatedText, crEFTEditableRTF, crEFTXml, crEFTRPTR, crEFTExcelWorkbook, cContextKeyLen1, cContextKeyLen2, cContextKeyLen3, adCmdText, adCmdStoredProc, adClipString, adExecuteNoRecords, adVarChar, adInteger, adParamInput, adParamOutput, adParamInputOutput, adParamReturnValue, adTextNoRecords, adOpenForwardOnly, adOpenStatic, adLockReadOnly, adUseServer, adUseClient, dbTMP$, dbTEMPDB$, dbSYSDB$, dbPVXDDF, dbPVXDB, dbMYSQL, dbADO, dbSQL, LastErrorMsg$, LastErrorNum$, SageCloudAppDesc$, IolNomads$

Properties inherited from: SY_Password

AESCipher$, AES256Cipher$

Methods inherited from: SY_Constant

GetNOMADSIolist$(), MaskString(), RawString(), ClassValidateEMailAddress(), dateTODAY$(), Element$(), fmtMODCODE$(), fmtMODPREFIX$(), PERFORM FunctionBreak(), GetExceptionMsg$(), GetFileName(), GetJobTitles(), GetPrinterProps(), GetRecordCount(), isALPHA(), isDATE(), isNUMERIC(), MsgPath$(), ParseString(), ParseTagField(), Position(), QUO$(), ValidateFormatType()

Methods inherited from: SY_Password

ConfirmAESKey(), ConfirmPassword(), EncryptAESData(), EncryptAESKey(), EncryptAESPassword(), EncryptPassword(), GetAESDataTest$(), PasswordAcceptable(), ValidateAESData(), ValidateAESPassword(), ValidatePassword(), VerifyAESDataEncryption(), DecryptAESData(), DecryptAESKey(), DecryptAESPassword(), DecryptAltAESData(), DecryptPassword(), EncryptAltAESData(), GetKEK$(), InitAESKey(), InitializeAES(), InitializeAltAES(), ValidateAltAESData(), VerifyAltAESDataEncryption()