4 Replies Latest reply on Mar 13, 2014 5:18 AM by FrancoT

    Empty portal if a file is open by Flm12 Server vs.Flm12 Pro

    FrancoT

      Title

      Empty portal if a file is open by Flm12 Server vs.Flm12 Pro

      Post

           We have in a single database 3 different tables containing various records for which we properly calculate partial and total data summary, sorting them with identical criteria.

           Such summary values are added together in calculated fields of an other table and listed in a portal.

           Any idea why the portal properly shows the requested data summary duly listed in each portal row if the file is open with Flm12 stand-alone and it is empty when managed by Flm12 Server?

            

        • 1. Re: Empty portal if a file is open by Flm12 Server vs.Flm12 Pro
          philmodjunk

               Are there any global fields that are part of this process?

               They can function differently on a hosted database--such as from FM Server, than what you get with the same file open in just FileMaker Pro.

          • 2. Re: Empty portal if a file is open by Flm12 Server vs.Flm12 Pro
            FrancoT

                 Thank you, but no global fields are used.

                 To summarize, there are 3 independent tables containg each the same calculations, as follows:

                 table 1: ... field A1 as GetSummary( costs; costs)

                 table 2: ... field A2 as  GetSummary( costs; costs)

                 table 3: ... field A3 as GetSummary( costs; costs)

                 where all the records of tables 1,2,3 are sorted by the fields "Products"

                  

                 An other separate table contains a calculated field "Total cost A = A1+A2+A3"

                 The portal that refers to such last table and containing "Total cost A" shows in each row the correct values grouped by "Products" only if FlmPro is used, nothing when the same file is managed by FlmServer.

            • 3. Re: Empty portal if a file is open by Flm12 Server vs.Flm12 Pro
              philmodjunk

                   I don't see how what you have posted could possibly work in just FileMaker Pro let alone when it is hosted over a network from Server.

                   

                        To summarize, there are 3 independent tables containg each the same calculations, as follows:

                   

                        table 1: ... field A1 as GetSummary( costs; costs)

                   

                        table 2: ... field A2 as  GetSummary( costs; costs)

                   

                        table 3: ... field A3 as GetSummary( costs; costs)

                   

                        where all the records of tables 1,2,3 are sorted by the fields "Products"

                   But the second parameter of GetSummary cannot be the same field as the first field. The first field should be a summary field and the second cannot be a summary field. It should be the "break" field--the field on which they are sorted.

                   Are you sure that these calculations don't read as: GetSummary( costs; Products ) ???

                   And getSummary will evaluate from the context of a layout's current found set and the table specified for that layout must be the same table as where you defined the summary field used as the first parameter in this function. Referring to this calculation from the context of a related table (such as your portal) is unlikely to consistently return correct results.

              • 4. Re: Empty portal if a file is open by Flm12 Server vs.Flm12 Pro
                FrancoT

                     Thanks for your comments, the situation is the following:

                     - despite what I wrote before there was a global field driving a relationship of the file. Even if not directly involved in the specific process of the subject, it was clearly of disturb. As soon as modified, Flm Server OK as well. Great!

                     - regarding your comment related to the function GetSummary, even if strange also for us, it works as described. There would be certainly a reason as usual...

                     thanks

                     FT