This topic is 2629 days old. Please don't post here. Open a new topic instead.
Dogged by a Slow FileMaker Database?
Cache in on this Quick Tip to Improve Layout Load Times & Report Generation
By Joe Cellino, FileMaker Developer
Have you ever wondered, “What is taking this report so long to generate?” or “Why does this layout take so long to load?” It may be that your FileMaker fields are set up inefficiently. If you have unstored calculation or summary fields on your layout, this will most certainly be the issue. Just as the names indicate, “unstored” calculation fields and “summary” fields don’t store any data. They must calculate the data each time the field is displayed. It may be easier to use unstored calculations in order to get your database functionality working, but this will inhibit your system from scaling with your business in the long run. The good news is — you can improve FileMaker performance with this data caching trick. Read More - > https://excelisys.com/dogged-by-a-slow-filemaker-database-check-out-this-data-caching-tip/
I need help trying to create this report as I can not figure out the best method of doing this. Here is what I need the report to do. My report is a sorted list of technology assets by location name. In each sub summary I need to list the count of all different types of devices. The device types are a value list which has all the items such as “Desktop, Laptop, Firewall, Cellphone” in the list. How can I get the totals for each location of each of these devices to appear?
Please see the image below for an idea of what I am talking about.
Thank you in advance for your help!
I have a customer database and with a customer table and a service call table. I am looking to create a report that would summarize total payment received in each month and a total for any given year with a grand total of every year. Not sure how to set up the layout part for the Year and Month so that they will produce the desired result.
Thank you for any assistance.
I have a database made up of 3 tables, Company, Event, and Registration.
I have created a report showing all of the events each company attend, summarized by Company.
What I am trying to figure out is how to create two different reports
One Report showing only the Companies that are attending only one event
One Report showing companies that will be attending more than one event.
Each report should be able to show the name of the company and the event or events they are attending
Can anyone offer me a suggestion or guidance as to how to accomplish this?
I have several reports which I'd like the user to be able to select from a list and then have FM print overall upon one button press, rather than the current set up I have which is a button on each report which fires the relevant print script.
To add a little layer of complexity to the process, the reports need a letter index added to them prior to printing. This is because, depending on the circumstances, in one instance Report XYZ could have an index position of say, 'D', but the next time, due to an additional report being required, Report XYZ would have the index position of 'E'. This index position needs to be visible on the report.
The reason I'm posting is because I'm not really certain where to start on this one. The one thing I do have is a table which lists all the reports and currently allows a user to enter any report via a portal list based on that table.
Any thoughts or suggestions greatly appreciated on this! Thanks