Based on a large DB I have created a summary report (I'm not interested in the detail) which extracts products according to certain criteria and groups them under sub-summaries. The product at the top represents the most sales, and the product at the bottom - the least. I wanted to obtain a ranking no eg No1 at the top and had thought to define a field which would accept this number by inputting the rank using Replace Field Contents with a serial number. However, it inserts incremental numbers through the whole file rather than just for the sub-summary. For example: say, I have a file of 2000 different hats in 50 different colours. A red hat is the most expensive at $100, the black hat the least - $50, say. But I sell only 10 of the red hat and 1000 of the black hats. So, in my summary at the top I have Black hats $50,000 (at my proposed No.1) and Red Hats below it at only $5,000 (proposed No. 2). eg
Black hats $50,000
Red hats $5,000
How can I create and populate a field which I can add to this report which will indicate the following:
Black hats $50,000 Rank 1
Red hats $5,000 Rank 2
After the weekend races and all the results are imported into FM, I mark (now by hand) the “Key Races”. I’ll find each horse who either won or finished 2nd. As in this screen shot of Cherry Summer you can see he won his last race on Oct 3. (1)
Then I mark the preceding race. (now I’m using a ‘K’, but I intend to change it to a number — different problem). The point is to show which race produced winners. The screenshot shows I have put a 'K' in Cherry Summer's race on may 31 and changed the 4 to a 5.
Then I find matching records for RaceID (31may15tok5) on the record I just tagged, and count the ‘K’s and enter the number in KRG. So before I updated this there were 4 'K's in the field KR and the field KRG showed 4s.
It would be nice to have FM do this, but marking the previous race is my problem. It's not a terrible task now, but a while back I lost everything and it took me a month to get all the key races data back. I'd like to avoid that.
By Daniel Wood
When FileMaker sorts records it happens on the client machine. Consequently, sorting can be a very painful process for users over a slow connection to a database. In this article we show a very fast way in which records can be presented to the user in descending creation order, without sorting delays...
Read the Full Article Here…
I'm working on a task at the moment which involves sorting around 65000 records on a data table. The table itself has many occurrences but I only need to sort on this particular occurrence, therefore my sort criteria (ClientID, Date) are based on this occurrence.
The issue is that when I sort the data on my local PC, it takes maybe two seconds to sort, calculate and display. For the task in mind, this is perfectly acceptable as I won't be doing it too often. However, now this has been deployed on a server which is more than up to the task and exceeds the recommended spec, the sort takes several minutes with a countdown of records sorted slowly going from 65000 downwards.
The network between the server and the client is again, up to speed and poses no issues in other areas.
So, what's FM doing to make the sort so slow?
The local sort is fine, so can I cache to a local client and sort from there?
I don't get why the sort cannot utilise the speed of the server or where the bottleneck is occurring?
Thanks in advance
By Justin Close
I am running into an issue of some records not sorting the same way. The user's UI has a portal viewing some related records; this portal is sorted by two fields. However, it doesn't appear that the 2nd field is having the correct sorting affect.
This same table, when viewed in Table view with the same found set, and then sorted by these two fields, does appear to correctly sort.
The relationship for the portal isn't itself sorted, so I can't seem to discern where the issue is. I have attached screen shots of the Table view (along with it's applied sorting options), and the portal (showing both the records as viewed, and then one with the sorting options).
This is in FM11.
Anyone have some suggestions?