Nhan Doan

Of course, the data must be ready first, then you have to test it. yes, the food category must be sorted on the report layout of course. Based on the screenshot you attached, i guess the button to print the report should be from the invoice layout Nhan

Well, I think the report layout should be based on line item tables and sub-summary part is based on line item details and sorted on food category. Just an idea, hope it helps. Another thing is that I think you should NOT use portal in a report like this because it will limit displayed data on it. Using it if you are know for sure there is a limit on displayed data. Nhan

I recommend you should use script triggers to update the normal fields instead of using those unstored calculation fields. I am recreating one old solution which is using hundreds of unstored calculation fields in a table which nearly has 2000 fields. The system is really slow. Yes, upgrading hardware is a good way, but for a long run, you have to reduce using unstored fields. Regards, Nhan

View File FM Locator This file is a small FileMaker-based tool whose input is the XML data of Database Design Report exported from Filemaker. It can help developers save time finding elements in a solution. Below is what the tool provides • Search any fields in a whole solution • Search any layouts in a whole solution • Search any scripts in a whole solution • Search any TO (Table Occurrence) in a whole solution • Import many solutions Submitter Nhan Doan Submitted 11/02/2016 Category Solutions FM Version FM Version: 13

Dear all, I want to publish my analysis tool for the community to use. But i don't know which field or area the tool can be added. Could you please tell me where I can publish my tool in the forum? Thanks in advance. Best Regards, Nhan