Leatherpriest

I am creating a project tracking system which has 3 time tracking files that relate to a master Projects file, based on departments. Data is entered through portals there and lives in each respective department file. In each TT file there are a few summary reports for time tracking which are sorted by month and year. These are fine on their own. What I am trying to do is consolidate all three of these files for a report within the master projects file, where the time totals are already stored according to project. It is no problem to summarize the hours - the problem is to list everything by month and year in a nice neat consolidated report. Otherwise I have 3 Januarys, 3 Febs, etc, etc. What Im looking to do is have 5 fields - month, year, dept 1, 2, and 3 - and have a one page report that summarizes the above by month and year. Any suggestions would be greatly appreciated. Thanx.

Thanks for your response - Have you any suggestions regarding the "white space" , such as top/bottom and left/right fixed margins ?? I have about 40 reports, all which print in Portrait , but I can't seem to settle on the sizing.

The "Filemaker Pro Bible" is a pretty good one too- it covers the basics, and gives you some intermediate stuff too for when you get beyond the basics. It too can be found on Amazon, Barnes&Noble, etc....

One other thing - Put a "show all records" before the "sort " command.....

What about a script in the new version that sorts the files by their id (ascending), replaces all of the existing files id's, and updates the auto-enter serial number to pick up where it left off ? The replace command can be done without dialog, and the script could run on startup of the new version. The only thing I'm uncertain of is how you could make the script run only once, for the initial update. ... Be sure to opt for "auto update serial #" under the "specify" button, and choose the id field to replace. Provided that your users haven't deleted any files, the sort,replace,and serial# update could theoretically work , as the present id's would be replaced by the same ones, and any additions would pick up where the user left off. However, if there are any files deleted- the replace command would give many of the files new id's and knock things out of sync. If the id itself is not crucial, but the names and other info are - it should be no trouble. Whatever the case - Use caution if you decide to go this route!

Seems that in FMP3 & 4 printing cross-platform reports harmoniously required dual page/print setups for printing scripts. Is this also true for version 5? If so, are there any workarounds for such a situation? I'm designing the db on a Mac, and many of the users of the solution are going to be Windows users, and I suspect they may also have several different printers.

Sounds like you could use a copy of Filemaker Developer if you have the bucks. It has a "Kiosk" mode which to the best of my knowledge allows you to get rid of menubars, window options, etc. without any plug-ins. If you come across anything of this nature for fmp5 though, please do tell as I would also like to have such window control. . .. .

I've been searching and searching for an international phone number format calculation - Seems all I can find is US formatting. I would like it to be able to handle both if possible. . .. If anyone has some info on this, please do tell.