.ln(-2)
will jump two lines up. And you can write into the same rows again. select myRptCursor .FlashContainer(oForm.ReportHeaderContainer) scan .FlashContainer(oForm.DetailBandContainer) endscan .FlashContainer(oForm.ReportSummaryContainer)Effect will be the same as if you did
select myRptCursor **block of code to write rpt header scan **block of code to write rpt detail .lw(25,'text') .lw(50,nValue) . endscan **block of code to write rpt summary .lw() .lw() .But with huge reduction in code written! Meaning you get all flexibility of scripted report while in the same you
.RSPageHeight .RSPageWidth .RSRowHeight &&when using .ln() .lw() .PgReminder &&Reminder of page in pixels .PgFooterAt &&Page break point calculated at run time .PgFooterHeight &&Dependding on this prop .nTop , .nLeft &&Current writing position .nColumnLeft &&Default left margin / starting positionHowever you should not play to much with these. All you need to know is basically reminder of the page.
** code snippet select parenttable scan . . select timerecords .FlashContainer(thisform.LabourHeader) scan while Timerecords.ifkey = parenttable.ipkey &&Outer loop if .pgRemainder < 200 .Eject() endif cGrp=str(timerecords.ifkey,1,0) + Timerecords.mach_num nMachTot=0.00 .FlashContainer(thisform.MachineGroupHeader) &&Group Header scan while str(timerecords.ifkey,1,0) + Timerecords.mach_num == cGrp &&Grouping nLineTot = Timerecords.mach_rate * Timerecords.hrs_worked &&Calculate Totals nMachTot = nMachTot + nLineTot nLabTot = nLabTot + nLineTot .FlashContainer(thisform.MachineDetail) endscan skip -1 .FlashContainer(thisform.MachineGroupFooter) &&GroupFooter endscan .FlashContainer(thisform.LabourFooter) . . . endscan *See demo sample #15 for full report code / content.Now if HTML is what you are after, you can send this report to HTML via XFRX. Also to all other file formats supported by XFRX.
cHTMLFile = oRS.Output(306,.f.) &&produce silently & returns path/name of result file **Then you take it and copy it to web folder of yours for publishing cWebFile= '\\mywebfolder\mypage.html' copy file (cHTMLFile) to (cWebFile) &&or ftp or whatever && 301 PDF && 302 Word doc && 303 FDOC && 304 RTF etc * See RS docs for all XFRX output parameters / file export type optionsEnjoy using Report Sculptor :)