6 Replies Latest reply on Oct 7, 2010 11:23 AM by TSGal

    DDR issue with Summary fields using Additional Fields

    nickorr

      Summary

      DDR issue with Summary fields using Additional Fields

      Description of the issue

      There is a bug in the DDR where if you're doing a summary field and that field uses an "Additional" sorted by field, the DDR doesn't report the Table (TO) properly. Detailed description of the issue:When reporting on the DDR the option for "Field/SummaryInfo/AdditionalField/Field" doesn't always include the table.  When you use the first Table/TO in the list, the table attribute is missing.  When it's from a different TO/Table the table attribute appears.  When you delete the TO it's using the table attribute is there, but empty. So it's difficult to distinguish between a missing Table (ie an empty table attribute) and the default table ( no table attribute). Exact steps to reproduce the issue:Create a new file with a single table with a new field that is doing a Summary and has the "Restart summary" option checked.  Choose a field from this single Table/TO for the sorted field ( you will need a total of 4 four fields to set this up).Run the DDR.Note the table attribute listed for the AdditionalField/Field is empty. Add another Table and another field to that table, then change the sort to use the other Table.When you run the DDR the table now appears. Delete the second Table and it's TableOccurrence without altering the summary field.When you run the DDR the table attribute is present, but empty.  Expected Result:The Table attribute should always appear, regardless of which table you choose. Actual Result:The table attribute is inconsistent. Notes:I have a sample file that can demonstrate this completely if required.

        • 1. Re: DDR issue with Summary fields using Additional Fields
          TSGal

          nickorr:

           

          Thank you for your post.

           

          I am not getting the same results, so let me go through your steps.

           

          > Create a new file with a single table with a new field that is doing a Summary and has the "Restart summary" option checked

           

          I created a new file, Sample.fp7 as follows:

          FIELDNAME (FIELDTYPE)

          Number (Number)

          Summary Total (Summary - Total of Number)

          Text (Text)

           

          I then returned to "Summary Total" and checked the option "Running total" and "Restart summary for each sorted group" and selected "Text".

           

          Therefore, I only need three fields; not four as you suggested.  Am I missing a step?

           

          > Run the DDR.

          > Note the table attribute listed for the Additional Field/Field is empty.

           

          My attributes for Text and Number are identical.  They are not empty.

           

           

          > Add another Table and another field to that table, then change the sort to use the other Table.

           

          My second table is named "Second", and I created a text field "second".  I sorted on "second"

           

          > When you run the DDR the table now appears.

           

          Yes, as it did previously.

           

           

          > Delete the second Table and its Table Occurrence without altering the Summary field.

          Did you mean in the step above to change the sort in the Summary field?  Assuming you meant that, I have done this prior to deleting the second Table and its Table Occurrence.

           

          > When you run the DDR the table attribute is present, but empty.

           

          My DDR does show <Missing Base Table> for the second table occurrence, and does display an entry under "In Field Definitions" for "Total Summary" field as it should to alert you of the error.

           

           

          Yes, I would like to see your sample file for the first part.  I have sent you a private message (top of this page - envelope icon on the right side below the reddish horizontal bar) with instructions where to send the file.

           

          TSGal

          FileMaker, Inc.

          • 2. Re: DDR issue with Summary fields using Additional Fields
            TSGal

            nickorr:

             

            I received your file.  Thank you.

             

            I ran the DDR report in both FileMaker Pro 10 and FileMaker Pro 11.  I do not see any inconsistency.

             

            I noticed the Summary Broken field displays <Missing Field> as it should.  I don't see where the empty field is located.

             

            What steps should I take (other than what you described earlier) to discover the empty entry.

             

            TSGal

            FileMaker, Inc.

            • 3. Re: DDR issue with Summary fields using Additional Fields
              nickorr

              TSGAL,

               

              I'm trying to post the details of the XML to the forum, but it's not liking them.  Wonderful forum software keeps telling me it's changing my HTML.

               

              I've sent you another direct email with the details.

               

              Nick

              • 4. Re: DDR issue with Summary fields using Additional Fields
                TSGal

                nickorr:

                 

                I received your email.

                 

                I've had other problems with literal tags being interpreted as HTML.  Therefore, paste what you have, but then remove the "<" and ">" from each line.  I'll work with it to try and get it to display properly so others may be able to comment.

                 

                TSGal

                FileMaker, Inc.

                • 5. Re: DDR issue with Summary fields using Additional Fields
                  nickorr

                  I didn't realise but I never posted a follow up here for this.  Some details :

                  ---

                  The difference is in the way it's reporting the field used by the summary field.  Compare in my example file.  This is the "SummaryWorks" field :

                  Field id="7" dataType="Number" fieldType="Summary" name="SummaryWorks"

                  SummaryInfo restartForEachSortedGroup="True" summarizeRepetition="Together" operation="RunningTotal"

                  SummaryField

                  Field id="1" name="Number"

                  /SummaryField

                  AdditionalField

                  Field table="Second" id="1" name="Sort"/

                    /AdditionalField

                  The bit that has the issue is the "Field" node inside the AdditionalField node.  The above one is what it should look like.  This is what you get when you select any TO other than the first TO for the Table.  If you delete that TO (ie the "Second" Table Occurrence), then it changes to this :


                  Field table="" id="1" name=""/


                  Same as the SummaryBroken field in my example file.

                  At this point, everything as is it should.  But if you select the very first TO in the list, then it doesn't show the table name as an attribute of the Field node, it just has :


                  Field id="1" name="Sort"/


                  Same as the SummaryDefault field in my example file.  As you can see there, the table is missing, even though it's valid and the field works fine.  It should show the table name attribute node regardless of which TO you've picked from the list.  It is actually using the TO, it just doesn't tell you which one.  If you deleted the TO the field would break, but it's not referenced in the DDR. 


                  I'm doing this in v11, but I'm fairly certain the behaviour is the same in 10.

                  • 6. Re: DDR issue with Summary fields using Additional Fields
                    TSGal

                    Nicholas Orr:

                    Thank you for the follow-up.  The information has been sent to our Development and Software Quality Assurance (Testing) departments.  There is no update at this time.  When additional information becomes available, I will let you know.

                    TSGal
                    FileMaker, Inc.