any suggestions to exporting/(converting) Layouts for use in another reporting tool
We have Filemaker Pro 5.0v3 under Windows and we are converting it to another database (Oracle).
My dilemna is I have over 200 layouts (letter templates) to import and convert them over into Crystal Reports.
These 200+ layouts (templates) are basically formatted letters where our customer and related claim information is populated and then printed out.
I'd be a pig in mud if I could somehow extract & identify each template (one by one or batched?) with its "layout name", filemaker fields, and text somehow. Has anyone been through this or have any suggestions ?
Thanks in Advance
NY City Transit, New York City
You might consider converting your database to FMP 10 and then using it in place of Crystal Reports as your database "front end".
That would preserve your report layouts but require building the SQL expressions needed to query oracle for your data.