I'm not a programmer, especially a db one, and I don't play one on TV err
with Filemaker....rather I'm an EE & the sign on my monitor says:

"My programming language is solder..."

But I need to get a solution built for a small non-profit, and think I
should ask more questions than I have to date.

The platform is FMP/FMS-10, on OSX10.5. There are 10 or so FMP 9/10/11
clients, with one or two using the system simultaneously.

We have a running system that does what we need in terms of screens,
procedures, etc.

We now need to create reports for people to view with HTML. These are not
interactive reports as much as the user chooses which report{s} {s}he wants
to see; i.e. the reports could be created nightly via cron, or built on the
fly.

There are 3-4 types of reports, and 100 versions of one; 10 of the others,
i.e. Report A for Jack, Report A for Jill, and so forth. They will not be
complex as they are basically activity summaries. It would be nice to have
both viewable and printable formats, but that's a complexity.

FMP & Server would have to run on the one box; I have been told this is
doable but a performance hit....but our loading is so low, it should not
ever matter.

We have an external, off-site Apache server, replete with AJAX & PHP tools,
and a fellow EE who *does* like to code in those....he wrote that aspect.
But we want the reports in FM because that is one area FM beats MySQL/PHP
hands down; report creation/display.

I know the words IWP, & CWP.

So:

I can see the FM box creating each report; we serve them with the OSX web
server. Or we could rsync the completed reports files up to the Apache box,
and serve them from there. That implies nightly cron runs.

What say the brain trust here on each approach?

What other questions should I consider?









#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>