RW technique

sjacquin

I have used this with several customers and thought I would post it. As you know, reports by date range agains the SO.HIST (past invoice) file can be really slow to execute as you must traverse a potentially huge file. If in the "header" of a prompt report you specify the alternate sort of ORDER.DATE (which is really the second alt key kno=2, and is sort by invoice date) you can put this expression in the "Begin with" (you must start and end with the single quote): 'hta(bin(jul([[START YEAR]]),[[START MONTH]],[[START DAY]]),3))' and a similar expression in the using END YEAR, etc in the "End With". When I applied this to a report this morning it went from taking several minutes to complete to taking less than a second. You can still add sort phrases and other select criteria as you please, but this radically reduces the number of records read by bracketing only the dates of interest.

[Updated on 7/15/2011 3:43 PM]

Legacy Contributor

Excellent tip! I've filed it for future reference.

0911060553270289.pdf