var stDrvName, stPrnName, stPrnInfo,rp,rf,tx String i,S,cc SmallInt r report ReportInfo ReportPrintInfo prnOptions printerOptionInfo objWinfaxSend OLEAuto TCUser,TCRec,TCComp, sourceTC Tcursor PP,DP,CP,OP,BP, WP,SP,EP,SE, FP,U,UN,UCN, SN,SSN,SW,SV,SF, strTb,TCDel,TCDis ,TCTer,Tcent String destTb,tb Table ss,SA1,SA2,SCI1, SPR1,SC1,SPC1 ,SCE,SGF,H ,eU string endvar self.frame.style = Inside3DFrame Action(Datapostrecord) rp = ReportName s = quoteno ;******** User Info U = LoginName ; GetNetUserName() eU = EnteredBy UN = anotherarray["zUN"] ; UCN = anotherarray["zUCN"] ; If CompNo = PWCompanyNo then else TCUser.open("sysUser.db") scan TCUser for TCUser.SPUser = eU and TCUser.SCompanyNo = CompNo : If NOT TCUser.SUserNo.isblank() then ; PP = TCUser.SPrinter ; CP = TCUser.SPrinterCopy ; OP = TCUser.SPrinterOrder ; DP = TCUser.SPrinterDefault ; WP = TCUser.SPrinterWorkOrder ; SP = TCUser.SPrinterPickingSlip ; BP = TCUser.SPrinterBarCode ; EP = TCUser.SPrinterEmail ; FP = TCUser.SPrinterFax U = TCUser.SPUser UN = TCUser.SUserNo UCN = TCUser.SCompanyNo SE = TCUser.SEmail TCComp.open("sys.db") TCComp.Locate("CompanyNo",UCN) SN = TCComp.Name SSN = TCComp.SubName SW = TCComp.Website SV = TCComp.Phone SF = TCComp.Fax SA1 = TCComp.Address1 SA2 = TCComp.Address2 SCI1 = TCComp.City SPR1 = TCComp.Province SC1 = TCComp.Country SPC1 = TCComp.PCode SCE = TCComp.Email TCComp.Close() endif endscan TCUser.Close() endif strtb = ":PRIV:ReportNo.DB" tb.attach(strtb) if isTable(tb) then TCRec.open(":PRIV:ReportNo.DB") TCRec.edit() TCRec.rCompanyNo = UCN TCRec.SUserNo = UN TCRec.Quote = s TCRec.EndEdit() TCRec.Close() else sourceTC.open("ReportNo.DB") destTb.attach(":PRIV:ReportNo.DB") sourceTC.copy(destTb) TCRec.open(":PRIV:ReportNo.DB") TCRec.edit() TCRec.rCompanyNo = UCN TCRec.SUserNo = UN TCRec.Quote = s TCRec.EndEdit() TCRec.Close() endif IF FaxNo <> "" then objWinfaxSend.open("WinFax.SDKSend8.0") objWinfaxSend.LeaveRunning() objWinfaxSend.setPrintFromApp(1) objWinfaxSend.SetNumber (FaxNo) objWinfaxSend.SetTo (Contact) objWinfaxSend.SetCompany (CustomerName) objWinfaxSend.SetPriority(3) objWinfaxSend.AddRecipient() objWinfaxSend.ShowSendScreen(0) objWinfaxSend.Done ( ) objWinfaxSend.Send(1) If printerSetCurrent(anotherarray["zFP"]) then if printerSetOptions(prnOptions) then ReportInfo.PanelOptions = PrintClipToWidth ReportInfo.Name = rp r.print(ReportInfo) else errorShow("Could not set printer options.") endIf else msgStop("Printer setup", "A printer Named " +" ' "+ FP +" ' "+ "is not installed !") endif objWinfaxSend.close() return else msgStop("No Fax Number", "No Fax Number Found !") endif