Best way to generate HTML report from UIA
Nancy Palmquist
nlp at vss3.com
Wed Jan 25 10:54:24 PST 2006
Boaz Bezborodko wrote:
> I want to generate some A/R information reports from the UIA screen of a
> customer's record. I would like to be able to generate it as an HTML
> document. But the question is what is the fastest method.
>
> I ma operating in a windows environment with a Novell file server for
> the data. I figure there are two ways to do this. The first is use a
> SYSTEM call using the START command to open a new window to run a report
> while passing the customers number. The other is to do the lookups and
> generate the file with OPENFILE and WRITELN statements.
>
> Executing a report in a separate screen will involve a little bit of a
> delay to both open the screen and start RREPORT. Does this mean that
> the OPENFILE option would be quicker?
Boaz,
I am a bit behind on responding to the list so I apologize for those
that have already moved on past this thread.
If you generate a report from UIA using lookups, it will be faster.
Running a report from SYSTEM, had the disadvantage that it has to
process the entire file. You can use a selection set and have it do an
index scan type of selection and that can improve the speed (Or use
lookup - logic to jump right to the records you want.) but you are
loading another filepro program and locking can be an issue for some
reports.
Running lookups to the exact records you want, formating an output and
generating a report is much faster.
Of course, this all depends on the volumes. I have a long time customer
and running statements once a month on about 1,900,000 records of which
about 40,000 are current billing. I started by designing the statements
to run from the detail and selecting the 40,000 records, sorting and
printing statements. This took 2.5 days to run (yes I said days)
I redesigned it to run from a monthly summary account record, selecting
about 2,000 records, it would generate the statements for the 40,000
records in about 5 hours.
Now it is so fast it can not keep up with a high-speed line printer and
with some new hardware it runs in a few hours.
Now this example is extreme but demonstrates the difference in speed
when changing the point of view of a process or output.
Nancy
--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: http://www.vss3.com
More information about the Filepro-list
mailing list