Class SY_ReportCommon

Known SubClasses

AP_ACHInterfaceListing_rpt, AP_ASSIGNVENDORTAXSCHEDULES_UI, AP_DeleteChangeVendorsListing_rpt, AP_DeleteChangeVendorsLog_rpt, AP_DeleteChangeVendors_ui, AP_DivisionListing_rpt, AP_ExpenseDistTableListing_rpt, AP_FixedAssetsImportStatus_rpt, AP_GenerateACHCommon_Rpt, AP_InvoiceHistoryListInv_rpt, AP_InvoicePaymentListing_rpt, AP_OptionsListing_rpt, AP_SalesTaxCalcErrorLog_rpt, AP_TermsCodeListing_rpt, AP_VendorCustomerLinkList_rpt, AR_BillToCustomerListing_rpt, AR_CustomerCreditCardList_rpt, AR_DeleteChangeCustomersListing_rpt, AR_DeleteChangeCustomersLog_rpt, AR_DeleteChangeCustomers_ui, AR_DivisionListing_rpt, AR_OptionsListing_rpt, AR_PaymentTypeListing_rpt, AR_PriceLevelByCustCopyList_rpt, AR_PriceLevelByCustListing_rpt, AR_SalespersonListing_rpt, AR_TermsCodeListing_rpt, BC_OptionsListing_rpt, BM_OptionsListing_rpt, CI_BankCodeListing_rpt, CI_CommodityCodeApply_rpt, CI_CommodityCodeListing_rpt, CI_InactivationException_rpt, CI_InactiveReasonCodeListing_rpt, CI_OptionsListing_rpt, CI_SalesTaxAccountListing_rpt, CI_UnitOfMeasureListing_rpt, CM_ScriptListing_rpt, CU_CRMServerOptionsListing_rpt, CU_CustomerTemplateListing_rpt, CU_OptionsListing_rpt, ES_DashboardSelectionList_rpt, ES_OptionsListing_rpt, FL_AssetAccountListing_rpt, FL_OptionsListing_rpt, GL_AccountGroup_rpt, GL_AccountStructureListing_rpt, GL_AllocationListing_rpt, GL_ChangeAccountsListing_rpt, GL_ChangeAccountsLog_rpt, GL_ChangeAccounts_UI, GL_DeleteAccountsListing_rpt, GL_DeleteAccountsLog_rpt, GL_ErrorLog, GL_ExchangeAccountLog_rpt, GL_ExchangeBudgetLog_rpt, GL_ExchangeTransactionLog_rpt, GL_FinancialReportGroupListing_rpt, GL_FiscalYear_rpt, GL_InvalidAccountCharacter_rpt, GL_JournalDrillDownListing_Bus, GL_JournalDrillDown_rpt, GL_MainAccount_rpt, GL_Options_rpt, GL_OutOfBalanceSourceJrnl3_rpt, GL_PayAccountSelectList_rpt, GL_PayOptionsListing_rpt, GL_RecurringJournal_rpt, GL_Rollup_rpt, GL_SampleAccountsListing_rpt, GL_SourceJournal_rpt, GL_StandardJournal_rpt, GL_SubAccount_rpt, IM_AutoCostPriceChange_rpt, IM_BalanceQtyOnHandListing_rpt, IM_BALANCEQTYONHAND_UI, IM_BuyerPlannerCodeListing_rpt, IM_ChangeLotSerialExpDates_rpt, IM_DeleteChangeItemsListing_rpt, IM_DeleteChangeItemsLog_rpt, IM_DeleteChangeItems_ui, IM_ErrorLog, IM_OptionsListing_rpt, IM_PriceCodeListing_rpt, IM_ProductLineApply_rpt, IM_SalesPromotionApply_rpt, IM_SalesPromotionListing_rpt, IM_WarehouseListing_rpt, IM_WarrantyCodeListing_rpt, IT_CategoryListing_rpt, IT_CategoryTreeListing_rpt, IT_EBMUserIDListing_rpt, IT_EmailNotificationListing_rpt, IT_EmailReasonCodeListing_rpt, IT_HTMLTemplateListing_rpt, IT_OptionsListing_rpt, IT_ShoppingCartAcceptLog_rpt, IT_UIDCustomerAcceptLog_rpt, IT_WebMenuListing_rpt, IT_WebTemplateOptionsList_rpt, JC_BurdenRateListing_rpt, JC_ContractorListing_rpt, JC_CostTypeListing_rpt, JC_InvalidCostTypeListing_rpt, JC_JobStatusListing_rpt, JC_OptionsListing_rpt, JC_OverheadRateListing_rpt, JC_UnitOfMeasureListing_rpt, MD_BatchListing_rpt, MD_ContextTableListing_rpt, MD_ConversionDriverListing_rpt, MD_DefaultPerformListing_rpt, MD_DefaultPerform_rpt, MD_EMailNotificationListing_rpt, MD_GridDefinitionListing_rpt, MD_MemoMaintenanceListing_rpt, MD_MemoRelationshipListing_rpt, MD_ModuleListing_rpt, MD_ReportManagerMasterListing_rpt, MD_ReportManagerMaster_rpt, MD_ReportManagerTemplateListing_rpt, MD_ReportManagerTemplate_rpt, PL_EmailMessageListing_rpt, PL_FormListing_rpt, PL_JournalRegisterListing_rpt, PL_OptionsListing_rpt, PL_PeriodEndReportListing_rpt, PL_ReportListing_rpt, PO_CancelReasonCodeListing_rpt, PO_LandedCostTypeListing_rpt, PO_OptionsListing_rpt, PO_PurchaseOrderNoListing_rpt, PO_ShipToAddressListing_rpt, PO_VendorPriceLevelListing_rpt, RA_OptionsListing_rpt, RA_ReturnReasonCodeListing_rpt, RA_ReturnToAddressCodeListing_rpt, SO_AutoGenInvoicesListing_rpt, SO_AutoGenOrdersListing_rpt, SO_BatchAuthorizationList_rpt, SO_CancelReasonCodeListing_rpt, SO_CustomerLastPurchaseListing_rpt, SO_CustomerLastPurchase_ui, SO_DuplicatePOChecking_rpt, SO_ErrorLog, SO_LineItemCommissionListing_rpt, SO_OptionsListing_rpt, SO_PurchaseControlListing_rpt, SO_SalesOrdersThatAreOpenListing_rpt, SO_ShipperIDListing_rpt, SO_ShippingOptionsBCListing_rpt, SO_ShippingOptionsListing_rpt, SO_ShippingRateListing_rpt, SY_1099MaintListing_rpt, SY_BusinessInsightsReporterListing_rpt, SY_CompanyListing_rpt, SY_CountryCodeListing_rpt, SY_CrystalAnalysis_rpt, SY_InstalledModulesListing_rpt, SY_JournalErrorLog, SY_MemoManager_rpt, SY_ModuleDateListing_rpt, SY_OfficeUserMapListing_rpt, SY_PeriodEndListing_rpt, SY_PopupItemListing_rpt, SY_PopupMenuItemListing_rpt, SY_PopupMenuListing_rpt, SY_PopupXRefListing_rpt, SY_ProcessFlowsListing_rpt, SY_RebuildLogListing_rpt, SY_Report, SY_ReportManagerGeneratedListing_rpt, SY_SalesTaxClassListing_rpt, SY_SalesTaxCodeListing_rpt, SY_SalesTaxScheduleListing_rpt, SY_ServiceNotificationList_rpt, SY_StateCodeListing_rpt, SY_SystemConfigListing_rpt, SY_TaskSchedulerListing_rpt, SY_ThemeListing_rpt, SY_Update, SY_URLListing_rpt, SY_UserSettingsListing_rpt, SY_WizardListing_Bus, SY_WizardListing_rpt, SY_Wizard_rpt, SY_ZipCodeListing_rpt, VI_ExportJobDefinition_rpt, VI_ImportJobDefinition_rpt, VI_JobLogReport_rpt, XX_ListingTemplate_rpt

Properties

LOCAL tmpCustomDirectory  
LOCAL kCrystalTrue=-1  
LOCAL kCrystalFalse=0  
LOCAL kCrystalDefault=0  
LOCAL kCrystalPortrait=1  
LOCAL kCrystalLandscape=2  
LOCAL rptReportTypeStd=1  
LOCAL rptReportTypeList=2  
LOCAL rptReportTypeReg=3  
LOCAL rptReportTypeBusFrm=4  
LOCAL rptReportTypeFinStmt=5  
LOCAL rptReportTypeExchng=6  
LOCAL rptReportTypeCustom=9  
LOCAL cWinFax=1  
LOCAL cFaxServer=2  
LOCAL settingGeneral=1  
LOCAL settingOptions=2  
LOCAL settingSelections=3  
LOCAL cFaxServerDriver$="microsoft shared fax driver"  
LOCAL cWinFaxDriver$="winfax"  
LOCAL cAvailableForPaperlessOffice$  
LOCAL cPDFAdditionalReport=isFALSE  
LOCAL cPDFPreservePLCommon=isFALSE  
PROPERTY AlternateCompanyCode$  
PROPERTY ReportType  
PROPERTY ReportFile$   * Read Only *
PROPERTY ReportFullPath$   * Read Only *
PROPERTY ViewerPrint   * Read Only *
PROPERTY ViewerPrintAll   * Read Only *

[numeric] -1: Initial value. 0: Not all previewed reports have been printed from the preview window. 1: All previewed reports have been printed from the preview window.

PROPERTY PrintStatus   * Read Only *
PROPERTY PreviewSelected  
PROPERTY coPLCommon   * Read Only *
PROPERTY PDFPrint   * Read Only *
PROPERTY PDFSilent  
PROPERTY HostedPrintNow  
[numeric] In the online environment, set to indicate that the report or form should be printed immediately
PROPERTY HostedPreview  
[numeric] In the online environment, set to indicate that the report or form should be previewed immediately
PROPERTY PrintRunDateTime$  
Overrides the printing of report run date time in the footer
PROPERTY SkipProcessErrorDisplay   * Read Only *
[boolean] when set the ProcessReport error message will be skipped

Methods

FUNCTION CheckForFaxPrinter(PrinterName$, OutPut$)  
FUNCTION ClearWtPopulateFlag()  
FUNCTION DeleteSection(Section$)  
FUNCTION DisableUseOfUI()  

Disable use of UI object in ProcessReport() method. Used in Task Scheduler as work-around for hung tasks when messages sent to server desktop

Returns [boolean] returns retSUCCESS (1)
FUNCTION ExportToCSV()  
FUNCTION GetPrinterProperties(orientation, size, source, duplex)  
FUNCTION GetReportFile$()  
FUNCTION InitReportEngine()  
FUNCTION PrinterSetup()  
FUNCTION ProcessReport(Destination$)  

Process the report and outputs the data to the specified destination

ParameterDescription
Destination [input, string] Destination where the repoirt will be processed. Either a printer name, paperless, deferred, email, etc.
Returns [boolean] Success returns one. Failure returns zero
FUNCTION ReportFileChanged()  
FUNCTION SetDeferredOptions(prt$, copies, purge$, secure$, collate$)  
FUNCTION SetExportOptions(FormatType, OutputFileName$)  
FUNCTION SetPrinterProperties(orientation, size, source, duplex)  
FUNCTION SetReportFormula(formulaname$, formulatext$)  
FUNCTION SetReportFormula(formulaname$, formulatext$, returnFormulaError)  
FUNCTION SetReportOrientation(orientation)  
FUNCTION SetReportSelection(selectionformula$)  
FUNCTION WinfaxPrinterSetupReset()  
FUNCTION LOCAL PERFORM AdjustForHolepunch()  
FUNCTION LOCAL CloseWorkTables()  
FUNCTION LOCAL ConvertCrystalReport()  

Convert Crystal Report

Returns [boolean] True = success, False = failure
FUNCTION LOCAL CreateWorkTable(workTable$, recID$)  
FUNCTION LOCAL CreateWorkTableClone(workTable$, recID$)  
FUNCTION LOCAL GetDeferredFile()  
FUNCTION LOCAL OpenPVXWorkTable(workTable$, recID$)  
FUNCTION LOCAL OpenPVXWorkTable(workTable$, recID$, deleteOnClose$)  
FUNCTION LOCAL PERFORM OpenReportFile()  
FUNCTION LOCAL PopulateSQLTempDB()  
FUNCTION LOCAL PreWorkTableWrite()  
FUNCTION LOCAL PERFORM PrintSettings()  
FUNCTION LOCAL PERFORM ResolveReportFile()  
FUNCTION LOCAL PERFORM SetPrinter()  
FUNCTION LOCAL SetStdFormulas(destination$)  
FUNCTION LOCAL PERFORM TranslateNonstandardProgramNames()  
FUNCTION LOCAL WriteDeferredLog()  

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_Customization

cDummyIol$

Properties inherited from: SY_OpenObject

cLockInfoNOKEY$

Properties inherited from: SY_PDFConverter

cNoPrompt, cUseFilename, cEmbedFonts, cPrintWatermark, cMultilingualSupport, cAppendExisting, PDFAppend, PDFWatermark$, PDFWatermarkFontName$, PDFWatermarkFontSize, PDFWatermarkOrientation, PDFWatermarkColor, PDFWatermarkHorzpos, PDFWatermarkVertpos, PDFWatermarkForeground, PDFFilename$, PDFDirectory$, PDFOutputFile$, PDFPaperSize, PDFOrientation, PDFPopUp, PDFOwnerPassword$, PDFUserPassword$, PDFConverterStatus$, PDFConverterOK, PDFEmailEngineOK, PDFFaxEngineOK, PDFAttemptedInstallConverter, PDFAttemptedInstallEmailEngine, PDFEnabled, PDFEmailEnabled, PDFFaxEnabled, PDFEmailErrorOptions$, PDFDeletePostProcess, PDFRevealExtendedFunctions$, PDFLogKey$, PDFSkipElectronicDelivery, EmailEngineObj, FaxEngineObj, PDFDevice$

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_Customization

GetCustomizations(), PostTableRead(), PreNextRecord(), PreTableWrite()

Methods inherited from: SY_OpenObject

CheckWhoHasLock(), CreateLockInfo(), RemoveLockInfo(), OpenTable(), OpenTempFile()

Methods inherited from: SY_PDFConverter

ClosePDFConverterAfterPrinting(), ElectronicDelivery(), EndOfPDFConverterJob(), GetLockfileForCrystal(), GetPDFConverterStatus(), PDFVerifyFaxService(), PDFVerifyMailService(), PrepareForPDFing(), SetConverterName$(), SetPDFOptions(), SetupPDFConverterForPrinting(), ApplyPassword(), ParseFilename(), PDFDefaultValues(), PDFDriverEnd(), PDFPostFormLoop(), PDFPostPrintProcessing(), PDFPreFormLoop(), PDFPrePrintProcessing(), PERFORM PDFSetPrinter(), SetDeliveryProperties(), SetPDFProperties(), PERFORM SetupWatermarks()

Methods inherited from: SY_Printers

GetPort(), GetPrinters$(), ValidatePrinter(), PERFORM CheckTerminalServicesPrinters(), InitializeDB_Output(), PERFORM InitPrinterList(), PERFORM RemovePDFDevices()