Least Resources & Most Efficient Report Storage

rbuser

My application is going to use a considerable number of reports. The
easiest way to work with the reports is to store them with the form. The
most space saving way appears to be in a database, which is what I am doing
now.

For a large application not compiled with run-time packages, what would you
recommend and why? If the .EXE is loaded dynamically already by Windows,
would having a 10-15MB EXE make a difference? When Windows starts such a
program from a LAN does it need to copy the entire EXE contents to the local
computer's memory first?

All of my forms are created dynamically as would be any forms that contain
report components.

Thanks for any advice,
Johnnie

rbuser

> My application is going to use a considerable number of reports. The

I don't think so, but that is

doing


you

If you support Wnidows 9x, you could run into resource limitations here, ie
your app can not run on them.

local

Yes, if it isn't compressed. Window's is smarter then DOS use to be.



What I like about DB based/file based reports is that I can update the
reports for my users.

I have a 2 tier system: standard reports are in a DB, custom reports are
file based. This has allowed for me to easily keep them separate, and update
users reports.

Ed Dressel
Team DM

rbuser

Can I programatically transfer reports saved as form resources (multiple
TppReport Components) to a form template database?

I've written a small utility program to allow me to group my standard
reports and forms in their own unit, and any custom forms for each of my
customers in their own special units. Actually I use DataModules. The
actual data pipelines are also in their own common DataModule. The entire
purpose of this program is to make editing the forms as simple as clicking
on a form component. It makes a nice test setup too.

Now that I have done this what I would like to do is create a new table at
run-time using the utility program and save each of the persistent report
templates to the file. What I don't know how to do is move from the
TppReport component report to my table fields. I use the standard "Name",
and "Template" field names.

Then I can just distribute the table files and use a single report component
to load the templates as needed at run-time.

Any help would be appreciated.

-Johnnie

rbuser

Sorry,
I wanted to clarify that when I said a "form component" I actually mean a
TppReport component. Most of my reports are actually full page forms.
-Johnnie

rbuser

After much testing I believe I found how to do it.

-Johnnie