AnsweredAssumed Answered

Strange Reporting Behaviour

Question asked by milton.kirkwood@gmail.com on Oct 13, 2016
Latest reply on Oct 17, 2016 by TSGal

Hi All,

 

With the recent upgrade to Filemaker 15 Advanced Pro (Ver 15.2.2.220) which is currently running on my 15" MacBook Pro Retina display (Mid 2012) with OSX 10.11.6 (El Capitan) with 16 GB of RAM I have started to notice some unusual behaviour.

 

I have a commercial application running hosted with FMP Host but the behaviour occurs whether I run it in the Cloud or on my laptop. Reports which were previously running correctly now start to miss records. I have a parent CLIENT table and a child PROJECTS table linked on the CLIENT ID unique index field. For the report I select records from the PROJECTS table based on three selection criteria. Of the selection fields two are binary and the third is a date field which I compare against the current date using Get(CurrentDate).

 

I had a similar problem with another report, based on the same two tables and the only way I was able to fix the problem was to recreate two CLIENT entries and their linked PROJECTS. Once I had done this the report worked okay.

 

Has anyone else noticed similar strange behaviour with reports?

 

Thanks,

 

Milton

Outcomes