Shuli,
>This may sound stupid, but I haven't figured out how to take the HTML report output and save it onto a specified directory. I've tried PUTFILE() but that seems to save the report on a default directory. If you have any suggestions, I would appreciate it. I tried to use STRtoFILE() but was unable to make it work.
Let's say you have built a string called "cHTML" containing your report in HTML format:
STRTOFILE(cHTML, "c:\somepath\somefilename.htm")